Microsoft Certified:Azure Database Administrator Associate
Domain 3Objective 3
Configure Database Solutions for Optimal Performance DP-300 Practice Questions (Page 5)
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 21–25
- 21
What is the primary purpose of updating statistics on a table in SQL Server?
Select an answer first - 22
Which command is used to manually update statistics for a specific table in SQL Server?
Select an answer first - 23
Which SQL Server server-level setting controls the maximum number of processors that can be used for parallel query execution?
Select an answer first - 24
Your company runs an Azure SQL Database that supports a seasonal application. During peak season, the workload increases significantly, and you need to handle the load without manual scaling. You also want to minimize cost during off-peak periods. The database is currently on a General Purpose service tier. You need to choose a scaling strategy that automatically adjusts compute resources based on demand. What should you do?
Select an answer first - 25
Which database-scoped configuration option can be set to control the maximum degree of parallelism for queries in a single database without affecting other databases on the same server?
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.