Microsoft Certified:Azure Database Administrator Associate
Domain 3Objective 3
Configure Database Solutions for Optimal Performance DP-300 Practice Questions (Page 4)
Part of the Monitor, configure, and optimize database resources domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)
26questions here
6free pages
9concepts
20–25%of the exam
Questions 16–20
- 16
In SQL Server 2016 and later, which statement is used to configure database-scoped settings such as MAXDOP or query optimization for a specific database?
Select an answer first - 17
Which automatic tuning option in Azure SQL Database can automatically create missing indexes to improve query performance?
Select an answer first - 18
Which server configuration option should you adjust to control the amount of memory SQL Server reserves for buffer pool usage?
Select an answer first - 19
Which intelligent query processing feature in SQL Server can improve performance for queries that process large numbers of rows by using batch mode execution?
Select an answer first - 20
Which command should you run to check the logical and physical integrity of all objects in a SQL Server database?
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-300” is a trademark of its owner, used for identification only.