Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-120 Exam - Topic 2 Question 99 Discussion

You have a highly available deployment of SAP NetWeaver on Azure virtual machines. The database tier is hosted on two virtual machines that run Windows Server 2019 and have Microsoft SQL Server 2017 installed. The NetWeaver, application, and database tiers each reside on a separate subnet within the same virtual network.You run ABAPMeter against the deployment and discover that the average value of Act DB is 2 ms.You need to lower the Acc DB value.What should you do?
C) Configure the SQL Server database to use asynchronous replication.
A) Increase the tempdb size on the SQL Server virtual machines.
B) Move the application virtual machines to the same subnet as the SQL Server virtual machines.
D) Redeploy the NetWeaver. application, and SQL Server virtual machines to the same proximity placement group.

Microsoft AZ-120 Exam - Topic 2 Question 99 Discussion

Actual exam question for Microsoft's AZ-120 exam
Question #: 99
Topic #: 2
[All AZ-120 Questions]

You have a highly available deployment of SAP NetWeaver on Azure virtual machines. The database tier is hosted on two virtual machines that run Windows Server 2019 and have Microsoft SQL Server 2017 installed. The NetWeaver, application, and database tiers each reside on a separate subnet within the same virtual network.

You run ABAPMeter against the deployment and discover that the average value of Act DB is 2 ms.

You need to lower the Acc DB value.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Rodney at Sep 11, 2024, 02:38 AM

Limited Time Offer

25%

Off

Get Premium AZ-120 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Eloisa
6 months ago
Really? I doubt that will make a big difference in Acc DB value.
upvoted 0 times
...
Kate
6 months ago
Redeploying to a proximity placement group sounds like a solid plan!
upvoted 0 times
...
Raylene
7 months ago
Asynchronous replication? Not sure that’s the right move here.
upvoted 0 times
...
Shannan
7 months ago
I think moving VMs to the same subnet might actually reduce latency.
upvoted 0 times
...
Eileen
7 months ago
Increasing tempdb size could help with performance.
upvoted 0 times
...
Tanesha
7 months ago
Asynchronous replication sounds familiar, but I’m not convinced it would directly lower the Act DB value in this scenario.
upvoted 0 times
...
Alesia
8 months ago
I practiced a similar question about optimizing SQL Server performance, and I feel like proximity placement groups could really help with latency issues.
upvoted 0 times
...
Twana
8 months ago
I think increasing the tempdb size could be beneficial, but I’m not clear on how much it would impact the Act DB value specifically.
upvoted 0 times
...
Harrison
8 months ago
I remember discussing how network latency can affect database performance, so moving the app VMs closer to the SQL Server might help, but I'm not entirely sure.
upvoted 0 times
...
Louvenia
8 months ago
I'm feeling pretty confident about this one. Separating the application and database tiers onto different subnets seems like the most likely culprit, so I'll go with moving the application VMs.
upvoted 0 times
...
Ressie
8 months ago
Okay, I think I have a strategy here. I'll focus on options that can directly impact the database performance, like increasing the tempdb size or configuring replication.
upvoted 0 times
...
Felicitas
8 months ago
Hmm, I'm a bit confused about the relationship between the subnets and the database performance. I'll need to review the details more closely.
upvoted 0 times
...
Pamella
8 months ago
This looks like a tricky one. I'll need to think through the different options carefully.
upvoted 0 times
...
Adell
1 year ago
I bet if we just yell at the database really loudly, it'll start running faster. Worth a shot, right?
upvoted 0 times
Dyan
1 year ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
upvoted 0 times
...
Haydee
1 year ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
Detra
1 year ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
upvoted 0 times
...
Fidelia
1 year ago
User 1: Maybe yelling at the database isn't the best solution.
upvoted 0 times
...
Stephen
1 year ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
Stacey
1 year ago
User 1: Maybe yelling at the database isn't the best solution.
upvoted 0 times
...
...
Patrick
1 year ago
Redeploying everything to the same proximity placement group? That's overkill, there must be a simpler solution.
upvoted 0 times
...
Shaquana
1 year ago
Asynchronous replication? Nah, that's not what we need here. We want to lower the Acc DB value, not introduce potential data consistency issues.
upvoted 0 times
...
Lovetta
1 year ago
Moving the application VMs to the same subnet as the SQL Servers could reduce network latency, that's an interesting option.
upvoted 0 times
Percy
1 year ago
B) Move the application virtual machines to the same subnet as the SQL Server virtual machines.
upvoted 0 times
...
Valentin
1 year ago
A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
...
Pete
1 year ago
Hmm, increasing the tempdb size seems like a logical step to improve database performance. I'll have to look into that further.
upvoted 0 times
Kanisha
1 year ago
User 4: Redeploying all the virtual machines to the same proximity placement group could also help lower the Acc DB value.
upvoted 0 times
...
Noelia
1 year ago
User 3: Configuring the SQL Server database to use asynchronous replication might be another option to improve performance.
upvoted 0 times
...
Wilson
1 year ago
User 2: Maybe we should also consider moving the application virtual machines to the same subnet as the SQL Server virtual machines.
upvoted 0 times
...
Raylene
1 year ago
User 1: I think increasing the tempdb size could help with the database performance.
upvoted 0 times
...
...
Sharika
1 year ago
I think redeploying all the virtual machines to the same proximity placement group might be the best solution.
upvoted 0 times
...
Kasandra
1 year ago
I disagree, I believe we should move the application virtual machines to the same subnet as the SQL Server virtual machines.
upvoted 0 times
...
Jacki
1 year ago
I think we should increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...

Save Cancel