MicrosoftMicrosoft
DP-300 · Question #356
DP-300 Question #356: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #356. The question stem and answer options stay visible for context.
Submitted by brentm· Mar 6, 2026Monitor and optimize SQL Server performance - specifically configuring the Query Store to capture query execution data for performance analysis and troubleshooting (maps to DP-300: Administering Relational Databases on Microsoft Azure or equivalent SQL Server administration certification).
Question
SIMULATION You need to ensure that all queries executed against db1 are captured in the Query Store. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer:
Options
- taskEnsure that all queries executed against db1 are captured in the Query Store.
- prerequisitesSign in to the virtual machine, SQL Server Management Studio (version 16 or later), Azure portal access.
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.
Topics
#Query Store#SQL Server Performance Monitoring#Database Configuration#SSMS Administration