Microsoft Certified:SQL AI Developer Associate
Domain 2Objective 2
Optimize Database Performance DP-800 Practice Questions (Page 2)
Part of the Secure, optimize, and deploy database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)
32questions here
7free pages
9concepts
35–40%of the exam
Questions 6–10
- 6
Which DMV provides information about currently executing requests, including the SQL text and the status of the request?
Select an answer first - 7
A financial application uses SERIALIZABLE isolation for all transactions to ensure consistency. This is causing frequent deadlocks and blocking, leading to poor performance. The application can be modified, but the business requires that transactions never see phantom rows. Which isolation level should you recommend to reduce blocking while still preventing phantoms?
Select an answer first - 8
When analyzing a query performance issue, which metric from sys.dm_os_wait_stats would you examine to determine if the query is waiting on I/O?
Select an answer first - 9
A query is performing poorly due to a table scan. Which action is most likely to resolve the issue?
Select an answer first - 10
Which Query Store view or report would you use to see the queries that have had the most significant change in duration over a selected period?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.