A company runs a critical application on Azure SQL Database in the East US 2 region. They need an RPO of 5 seconds and an RTO of 1 hour. The application must remain available even if an entire Azure region fails. Which solution should you recommend?

Use automated backups with geo-restore.

Use active geo-replication to a secondary in East US.

Use zone-redundant configuration within East US 2.

Use a failover group with a secondary in Central US.

A company runs SQL Server on an on-premises VM and also has a SQL Server on an Azure VM. They want a DR solution that provides an RPO of 5 minutes and an RTO of 1 hour. The on-premises site is the primary. What should they implement?

Azure Site Recovery replication from on-premises to Azure

Log shipping from on-premises to Azure every 15 minutes

Always On Availability Groups with automatic failover to the Azure VM

Azure SQL Database Managed Instance with geo-replication

A company runs a mission-critical application on Azure SQL Database in the North Europe region. They need an RPO of 5 seconds and an RTO of 1 hour. The secondary must be readable for reporting. Which Azure SQL Database feature should you use?

Automated backups with point-in-time restore

Failover group with manual failover

You have implemented a DR solution using Azure SQL Database geo-restore. You need to test the solution without affecting the production database. Which testing approach should you use?

Perform a failover to the secondary and then fail back.

Use Azure Site Recovery to test failover in a sandbox.

Restore a backup to a new database in the target region and run validation queries.

Stop the production database and attempt to connect to the secondary.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 1

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

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 6–10

6expert · hard
A company runs a critical application on Azure SQL Database in the East US 2 region. They need an RPO of 5 seconds and an RTO of 1 hour. The application must remain available even if an entire Azure region fails. Which solution should you recommend?
Select an answer first
7application · medium
A company runs SQL Server on an on-premises VM and also has a SQL Server on an Azure VM. They want a DR solution that provides an RPO of 5 minutes and an RTO of 1 hour. The on-premises site is the primary. What should they implement?
Select an answer first
8application · medium
You have implemented a DR solution using Azure SQL Database geo-replication. You need to validate that the RPO is being met. Which metric should you monitor?
Select an answer first
9application · medium
A company runs a mission-critical application on Azure SQL Database in the North Europe region. They need an RPO of 5 seconds and an RTO of 1 hour. The secondary must be readable for reporting. Which Azure SQL Database feature should you use?
Select an answer first
10application · medium
You have implemented a DR solution using Azure SQL Database geo-restore. You need to test the solution without affecting the production database. Which testing approach 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.