Microsoft Certified:Azure Database Administrator Associate
Domain 1Objective 1
Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 2)
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 6–10
- 6
An application has a rapidly growing user base and needs to scale out horizontally by distributing data across multiple databases based on a customer ID. Which database architecture should you implement?
Select an answer first - 7
Your organization uses Azure DevOps to manage infrastructure as code. You need to deploy a new Azure SQL Managed Instance and a database as part of a release pipeline. The deployment must be idempotent and support rollback. Which deployment method should you use?
Select an answer first - 8
You need to deploy a new Azure SQL Database for a development team. The deployment must be automated and integrated into their CI/CD pipeline. The team uses GitHub for source control and wants to deploy schema changes from a repository. Which tool should you use to deploy the database schema?
Select an answer first - 9
A data analytics team wants to use Microsoft Fabric to create a unified data platform that includes data from an Azure SQL Database. What is the primary way to integrate Azure SQL Database with Microsoft Fabric?
Select an answer first - 10
A financial services company needs to migrate a large data warehouse workload from on-premises SQL Server to Azure. The workload involves complex queries and large fact tables that are partitioned by date. They require the ability to manage the operating system and have full control over the SQL Server instance. Which Azure SQL offering should you choose?
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.