A company runs SQL Server on an Azure VM in the East US region. They want to use an on-premises data center as a DR site. The database is 2 TB and changes at 20 MB/s. The company has a 1 Gbps ExpressRoute connection. Management requires an RPO of 10 minutes and an RTO of 2 hours. Which solution should you recommend?

Use Azure Site Recovery to replicate the VM to the on-premises site.

Use log shipping from the Azure VM to the on-premises server.

Use SQL Server Always On Availability Groups with an asynchronous replica on-premises.

Use Azure SQL Database Managed Instance with a failover group to on-premises.

A company has implemented a failover group for Azure SQL Database. The DR plan specifies an RTO of 1 hour. The team needs to validate the plan without impacting production. What should they do?

Restore a backup to a new server and test the application against it

Run a read-only query against the secondary to verify it is reachable

Use Azure Site Recovery to fail over the entire resource group

Perform a planned failover during a maintenance window and measure the time to connect

A company runs a non-critical application on Azure SQL Database in the East US region. They need an RPO of 1 hour and an RTO of 4 hours. The solution must minimize cost. Which option should you recommend?

Use Azure Site Recovery to replicate the database.

Use automated backups with geo-restore.

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

Use a failover group with a secondary in West US.

What is the primary purpose of performing a failover test as part of an HA/DR testing procedure?

To verify that the backup files are stored in a different region

To measure the network latency between the primary and secondary regions

To ensure that all database users have been migrated to the secondary

To validate that the failover process works and that the application can 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 5)

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 21–25

21application · medium
A company runs SQL Server on an Azure VM in the East US region. They want to use an on-premises data center as a DR site. The database is 2 TB and changes at 20 MB/s. The company has a 1 Gbps ExpressRoute connection. Management requires an RPO of 10 minutes and an RTO of 2 hours. Which solution should you recommend?
Select an answer first
22application · medium
A company has implemented a failover group for Azure SQL Database. The DR plan specifies an RTO of 1 hour. The team needs to validate the plan without impacting production. What should they do?
Select an answer first
23application · medium
A company runs a non-critical application on Azure SQL Database in the East US region. They need an RPO of 1 hour and an RTO of 4 hours. The solution must minimize cost. Which option should you recommend?
Select an answer first
24foundation · easy
What is the primary purpose of performing a failover test as part of an HA/DR testing procedure?
Select an answer first
25foundation · easy
Which Azure SQL Database feature automatically replicates data to a secondary database in a different Azure region and supports automatic failover?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

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

Questions 21–25

A company has implemented a failover group for Azure SQL Database. The DR plan specifies an RTO of 1 hour. The team needs to validate the plan without impacting production. What should they do?

A company runs a non-critical application on Azure SQL Database in the East US region. They need an RPO of 1 hour and an RTO of 4 hours. The solution must minimize cost. Which option should you recommend?

What is the primary purpose of performing a failover test as part of an HA/DR testing procedure?

Which Azure SQL Database feature automatically replicates data to a secondary database in a different Azure region and supports automatic failover?

Keep studying — Plan and configure a high availability and disaster recovery (HA/DR) environment