MENU
You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.
You need to resolve the performance issues.
What should you do?
Suggested Answer: A
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
BO
Bo
11 months ago
Wait, can tempDB contention really be fixed this way?
JA
Jacquline
11 months ago
D seems outdated, not sure it’s relevant anymore.
ME
Melissa
12 months ago
C sounds interesting, but not sure it’ll help much.
DA
Daisy
12 months ago
I disagree, B might be more effective here.
AS
Ashlee
1 year ago
A is a solid choice for tempDB issues.
RA
Rasheeda
1 year ago
This question feels similar to one we practiced on performance tuning. I wonder if replacing sequential index keys could actually reduce contention.
UN
Una
1 year ago
I think implementing memory-optimized tables could help, but I’m not entirely confident if that’s the best approach for tempDB problems.
LI
Lisbeth
1 year ago
I remember reading about tempDB contention, but I'm not sure which option directly addresses that issue.
FL
Florinda
1 year ago
I vaguely recall that dbcc commands are more for maintenance than for resolving contention issues. I’m leaning towards option A, but I’m not completely sure.
JA
Janine
1 year ago
Ugh, I hate long package paths. At least option A gives us a way to deal with it, so I'll consider that one.
TA
Tamar
1 year ago
I'm a little confused by this question. Wouldn't deleting the backup be the worst thing to do? I'm leaning towards submitting the file, but I want to make sure I'm not missing something.
CO
Colton
1 year ago
I think the answer is GLBP. It's designed to maximize uplink utilization and minimize configuration compared to the other options.