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

Microsoft Exam AZ-120 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

Contribute your Thoughts:

Adell
2 months 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
25 days ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
upvoted 0 times
...
Haydee
1 months ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
Detra
1 months ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
upvoted 0 times
...
Fidelia
1 months ago
User 1: Maybe yelling at the database isn't the best solution.
upvoted 0 times
...
Stephen
1 months ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
Stacey
1 months ago
User 1: Maybe yelling at the database isn't the best solution.
upvoted 0 times
...
...
Patrick
2 months ago
Redeploying everything to the same proximity placement group? That's overkill, there must be a simpler solution.
upvoted 0 times
...
Shaquana
2 months 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
2 months 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 months ago
B) Move the application virtual machines to the same subnet as the SQL Server virtual machines.
upvoted 0 times
...
Valentin
2 months ago
A) Increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...
...
Pete
2 months 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
23 days 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
28 days ago
User 3: Configuring the SQL Server database to use asynchronous replication might be another option to improve performance.
upvoted 0 times
...
Wilson
1 months 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
2 months ago
User 1: I think increasing the tempdb size could help with the database performance.
upvoted 0 times
...
...
Sharika
3 months ago
I think redeploying all the virtual machines to the same proximity placement group might be the best solution.
upvoted 0 times
...
Kasandra
3 months 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
3 months ago
I think we should increase the tempdb size on the SQL Server virtual machines.
upvoted 0 times
...

Save Cancel