Microsoft Certified:Azure Database Administrator Associate
Domain 1Objective 1
Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 1)
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 1–5
- 1
A DBA wants to deploy an Azure SQL Managed Instance using a repeatable infrastructure-as-code approach. Which tool should they use?
Select an answer first - 2
A financial services company has a large transaction table in Azure SQL Database that is frequently queried by date range. The table has over 1 billion rows, and queries that filter on the transaction date are slow. The team wants to improve query performance and simplify data archiving. They plan to partition the table. Which partitioning strategy should you recommend?
Select an answer first - 3
A multinational corporation has SQL Server instances in multiple on-premises data centers across different countries. They need to centralize security policy management, enable auditing, and get a unified inventory of all SQL instances. They also want to use Azure services like Defender for Cloud and Sentinel for threat detection. However, they cannot move the databases to Azure due to data residency requirements. Which solution should you recommend?
Select an answer first - 4
A company uses Azure SQL Database for its operational systems. They want to enable business analysts to run ad-hoc analytics and create reports without impacting the operational workload. They also want to use Microsoft Fabric's OneLake for data storage and integrate with Power BI. They need to minimize data duplication and ETL. Which approach should you recommend?
Select an answer first - 5
A company wants to use Microsoft Fabric to run analytics on data stored in Azure SQL Database without moving the data into a separate storage system. Which Fabric feature should they use?
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.