MicrosoftMicrosoft
DP-300 · Question #189
DP-300 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
Submitted by tunde_lagos· Mar 6, 2026
Question
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?
Options
- AImplement memory-optimized tables.
- BRun the dbcc flushprocindB command.
- CReplace the sequential index keys with nonsequential keys.
- DRun the dbcc dbreindex command.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.