A company has an Azure SQL Database in the UK South region. The DR plan requires an RPO of 10 seconds and an RTO of 30 minutes. The application is a web app that can automatically retry on connection failure. What should you implement?

A failover group with manual failover and a connection string pointing to the secondary

Zone-redundant configuration within UK South

Automated backups with geo-restore to a new server

Active geo-replication with a failover group and read-write listener endpoint

A company runs a critical application on Azure SQL Database in the Southeast Asia region. They need an RPO of 5 seconds and an RTO of 1 hour. The secondary must be in a different region. Which Azure SQL Database feature should you use?

Automated backups with geo-restore.

Zone-redundant configuration within Southeast Asia.

Active geo-replication to a secondary in East Asia.

For a hybrid deployment where an on-premises SQL Server must be failed over to Azure, which option provides a readable secondary replica in Azure?

Azure Backup with file-level restore

SQL Server Always On Availability Groups

Azure SQL Database failover group

A company runs SQL Server 2019 on an on-premises VM. They want to use Azure as a disaster recovery site. The database is 500 GB and changes at a rate of 10 MB per second. Management requires an RPO of 15 minutes and an RTO of 4 hours. The company has a 200 Mbps site-to-site VPN to Azure. Which solution should you recommend?

Use Azure SQL Database Managed Instance with auto-failover groups.

Use log shipping to an Azure SQL Database.

Deploy a SQL Server on an Azure VM and use log shipping from the on-premises server.

Use Azure Site Recovery to replicate the VM to Azure.

An organization's database can tolerate up to 15 minutes of data loss and up to 2 hours of downtime. Which HA/DR strategy is most appropriate?

Synchronous replication with automatic failover

Asynchronous replication with manual failover

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 1

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

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 11–15

11application · medium
A company has an Azure SQL Database in the UK South region. The DR plan requires an RPO of 10 seconds and an RTO of 30 minutes. The application is a web app that can automatically retry on connection failure. What should you implement?
Select an answer first
12application · medium
A company runs a critical application on Azure SQL Database in the Southeast Asia region. They need an RPO of 5 seconds and an RTO of 1 hour. The secondary must be in a different region. Which Azure SQL Database feature should you use?
Select an answer first
13foundation · easy
For a hybrid deployment where an on-premises SQL Server must be failed over to Azure, which option provides a readable secondary replica in Azure?
Select an answer first
14application · medium
A company runs SQL Server 2019 on an on-premises VM. They want to use Azure as a disaster recovery site. The database is 500 GB and changes at a rate of 10 MB per second. Management requires an RPO of 15 minutes and an RTO of 4 hours. The company has a 200 Mbps site-to-site VPN to Azure. Which solution should you recommend?
Select an answer first
15foundation · easy
An organization's database can tolerate up to 15 minutes of data loss and up to 2 hours of downtime. Which HA/DR strategy is most appropriate?
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.