Microsoft Certified:Azure Database Administrator Associate
Domain 1Objective 1
Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 5)
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 31 practice questions to prepare you well beyond it. (estimate)
31questions here
7free pages
9concepts
15–20%of the exam
Questions 21–25
- 21
A multi-tenant SaaS application needs to isolate each tenant's data and scale out across multiple databases. Which sharding strategy is most appropriate?
Select an answer first - 22
A team wants to deploy Azure SQL Database resources using a declarative JSON template that can be version-controlled and used for repeatable infrastructure deployments. Which automated deployment method should they use?
Select an answer first - 23
A database has a large fact table that is frequently queried by month. To improve query performance and manageability, you want to split the table into smaller, more manageable segments based on the month column. Which SQL Server feature should you use?
Select an answer first - 24
A company needs a fully managed relational database in Azure with built-in high availability, automatic backups, and the ability to scale compute and storage independently. They have no requirement for OS-level access or custom CLR assemblies. Which Azure SQL offering should they choose?
Select an answer first - 25
A company uses Azure SQL Database for its operational ERP system. Business analysts want to run analytics and create reports in Microsoft Fabric without impacting the ERP workload. They need the data to be available in Fabric with minimal latency and without duplicating data manually. What should you implement?
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.