Microsoft Certified:Azure Database Administrator Associate
Domain 1Objective 1
Plan and Deploy Azure SQL Solutions DP-300 Practice Questions (Page 6)
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 26–30
- 26
You manage a hybrid SQL Server environment with two Azure VMs in an availability set running an Always On availability group. You need to apply a SQL Server cumulative update that requires a reboot. The maintenance window is limited to 30 minutes. You must ensure no data loss and minimal downtime. What should you do?
Select an answer first - 27
An organization requires the highest level of compatibility with on-premises SQL Server, including SQL Agent, cross-database queries, and CLR, but they want to avoid managing the underlying operating system and patching. Which Azure SQL offering should they select?
Select an answer first - 28
A company runs SQL Server 2019 on-premises and wants to use Azure for disaster recovery. They need to replicate the database to an Azure VM and be able to fail over with minimal data loss. They also want to use Azure Arc to manage the on-premises instance. Which hybrid solution should you recommend?
Select an answer first - 29
A company runs SQL Server on Azure VMs and wants to automate the installation of Windows and SQL Server updates. Which Azure feature should they use?
Select an answer first - 30
A manufacturing company runs SQL Server 2019 on-premises in a factory that has intermittent internet connectivity. They want to manage these instances centrally from Azure, apply consistent security policies, and enable point-in-time restore to Azure for disaster recovery. They cannot migrate to Azure SQL Managed Instance due to regulatory constraints. Which solution should you recommend?
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.