A business requires an RPO of 0 seconds and an RTO of less than 5 minutes for its mission-critical SQL Server database. Which HA/DR strategy best meets these requirements?

Automated backups with point-in-time restore

Daily full backups and weekly log backups

Asynchronous log shipping with manual failover

Synchronous data replication with automatic failover

A company runs SQL Server on-premises and wants to use Azure as a disaster recovery site. Which Azure service is designed to replicate on-premises virtual machines to Azure for DR purposes?

Azure SQL Database geo-replication

A company has an on-premises SQL Server and wants to use Azure as a DR site. They have a 100 Mbps VPN. The database is 1 TB and changes at 2 MB/s. Management requires an RPO of 30 minutes and an RTO of 4 hours. Which solution should you recommend?

Use log shipping to a SQL Server on an Azure VM.

Use transactional replication to Azure SQL Database.

Use Azure SQL Database Managed Instance with a failover group.

Use Azure Site Recovery to replicate the VM to Azure.

Which Azure service provides automated, application-consistent replication of on-premises virtual machines to Azure for disaster recovery?

Azure SQL Database geo-replication

You have configured an auto-failover group between two Azure SQL Databases in different regions. You need to validate that the solution meets the company's RTO of 1 hour and RPO of 5 seconds. Which testing procedure should you use?

Query the secondary database to verify it is readable and measure the latency.

Restore a backup to the secondary region and measure the restore time.

Perform a planned failover during a maintenance window and measure the time until the database is writable.

Perform an unplanned failover during a maintenance window and measure the time until the database is writable.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 1

Plan an HA/DR Strategy for Database Solutions DP-300 Practice Questions (Page 1)

Part of the Plan and configure a high availability and disaster recovery (HA/DR) environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 25 practice questions to prepare you well beyond it. (estimate)

25questions here

5free pages

5concepts

20–25%of the exam

Questions 1–5

1foundation · easy
A business requires an RPO of 0 seconds and an RTO of less than 5 minutes for its mission-critical SQL Server database. Which HA/DR strategy best meets these requirements?
Select an answer first
2foundation · easy
A company runs SQL Server on-premises and wants to use Azure as a disaster recovery site. Which Azure service is designed to replicate on-premises virtual machines to Azure for DR purposes?
Select an answer first
3application · medium
A company has an on-premises SQL Server and wants to use Azure as a DR site. They have a 100 Mbps VPN. The database is 1 TB and changes at 2 MB/s. Management requires an RPO of 30 minutes and an RTO of 4 hours. Which solution should you recommend?
Select an answer first
4foundation · easy
Which Azure service provides automated, application-consistent replication of on-premises virtual machines to Azure for disaster recovery?
Select an answer first
5application · medium
You have configured an auto-failover group between two Azure SQL Databases in different regions. You need to validate that the solution meets the company's RTO of 1 hour and RPO of 5 seconds. Which testing procedure should you use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

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.