MENU
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?
Suggested Answer: C
Get Premium AZ-120 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
33 comments · newest first
EL
Eloisa
11 months ago
Really? I doubt that will make a big difference in Acc DB value.
KA
Kate
11 months ago
Redeploying to a proximity placement group sounds like a solid plan!
RA
Raylene
11 months ago
Asynchronous replication? Not sure that’s the right move here.
SH
Shannan
12 months ago
I think moving VMs to the same subnet might actually reduce latency.
EI
Eileen
12 months ago
Increasing tempdb size could help with performance.
TA
Tanesha
1 year ago
Asynchronous replication sounds familiar, but I’m not convinced it would directly lower the Act DB value in this scenario.
AL
Alesia
1 year ago
I practiced a similar question about optimizing SQL Server performance, and I feel like proximity placement groups could really help with latency issues.
TW
Twana
1 year 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.
HA
Harrison
1 year 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.
LO
Louvenia
1 year 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.
RE
Ressie
1 year 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.
FE
Felicitas
1 year 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.
PA
Pamella
1 year ago
This looks like a tricky one. I'll need to think through the different options carefully.
AD
Adell
2 years ago
I bet if we just yell at the database really loudly, it'll start running faster. Worth a shot, right?
DY
Dyan
1 year ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
HA
Haydee
1 year ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
DE
Detra
1 year ago
User 3: D) Redeploy the NetWeaver, application, and SQL Server virtual machines to the same proximity placement group.
FI
Fidelia
1 year ago
User 1: Maybe yelling at the database isn't the best solution.
ST
Stephen
1 year ago
User 2: A) Increase the tempdb size on the SQL Server virtual machines.
ST
Stacey
1 year ago
User 1: Maybe yelling at the database isn't the best solution.
PA
Patrick
2 years ago
Redeploying everything to the same proximity placement group? That's overkill, there must be a simpler solution.
SH
Shaquana
2 years 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.
LO
Lovetta
2 years ago
Moving the application VMs to the same subnet as the SQL Servers could reduce network latency, that's an interesting option.
PE
Percy
1 year ago
B) Move the application virtual machines to the same subnet as the SQL Server virtual machines.
VA
Valentin
1 year ago
A) Increase the tempdb size on the SQL Server virtual machines.
PE
Pete
2 years ago
Hmm, increasing the tempdb size seems like a logical step to improve database performance. I'll have to look into that further.
KA
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.
NO
Noelia
1 year ago
User 3: Configuring the SQL Server database to use asynchronous replication might be another option to improve performance.
WI
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.
RA
Raylene
1 year ago
User 1: I think increasing the tempdb size could help with the database performance.
SH
Sharika
2 years ago
I think redeploying all the virtual machines to the same proximity placement group might be the best solution.
KA
Kasandra
2 years ago
I disagree, I believe we should move the application virtual machines to the same subnet as the SQL Server virtual machines.
JA
Jacki
2 years ago
I think we should increase the tempdb size on the SQL Server virtual machines.