Microsoft Certified:Azure Database Administrator Associate
Domain 3Objective 3
Configure Database Solutions for Optimal Performance DP-300 Practice Questions (Page 1)
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 1–5
- 1
A company runs an Azure SQL Database in the General Purpose tier with 2 vCores. The database experiences high latency during peak hours. The DBA wants to improve performance by scaling up, but the budget is limited. The DBA also wants to ensure that the database can handle future growth. What should the DBA do?
Select an answer first - 2
What is the main purpose of running database integrity checks on a regular basis?
Select an answer first - 3
A large database on Azure SQL Database has a table with a clustered columnstore index. The DBA runs a nightly maintenance job that rebuilds the columnstore index and updates statistics. The job takes over 4 hours and causes performance degradation during the night. The DBA wants to reduce the maintenance time and impact. What should the DBA do?
Select an answer first - 4
In Azure SQL Database, which service tier allows you to independently scale compute and storage resources?
Select an answer first - 5
Which intelligent query processing feature helps avoid performance issues caused by parameter sniffing by adjusting the query plan at execution time?
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.