Microsoft Certified:Azure Database Administrator Associate
Domain 1Objective 2
Configure Resources for Scale and Performance DP-300 Practice Questions (Page 3)
Part of the Plan and implement data platform resources domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 34 practice questions to prepare you well beyond it. (estimate)
34questions here
7free pages
8concepts
15–20%of the exam
Questions 11–15
- 11
An Azure SQL Managed Instance is used for a line-of-business application. The instance is currently at 8 vCores and frequently hits the log I/O bottleneck during month-end processing. You need to increase the log write throughput. What should you do?
Select an answer first - 12
You need to optimize the performance of SQL Server on an Azure Virtual Machine by ensuring that data files are stored on a high-performance disk. Which type of disk should you use for the data files?
Select an answer first - 13
You need to reduce the storage cost of a large archive table in an Azure SQL Database. Which feature should you enable on the table?
Select an answer first - 14
You have SQL Server installed on an Azure Virtual Machine. You need to increase the number of vCPUs available to the VM to improve database performance. Which action should you take?
Select an answer first - 15
An Azure SQL Managed Instance is used for a database that requires high availability and read scalability. The instance is currently a single instance. You need to offload read-only queries to a secondary replica. What should you do?
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.