A company runs SQL Server on an Azure VM in the West US region. They also have an on-premises datacenter in Phoenix. The DR requirement is an RPO of 30 minutes and an RTO of 4 hours. The company wants to use Azure Site Recovery (ASR) for the VM. What additional configuration is required to meet the RPO?

Configure a VPN gateway between Azure and Phoenix and use log shipping

Set the ASR recovery point to 'Latest' and enable multi-VM consistency

Use Azure Backup instead of ASR to replicate the VM to the on-premises site

Enable replication with a recovery point objective of 30 minutes and application-consistent snapshots

When planning a testing procedure for an HA/DR solution, which step is essential to include after the failover test is completed?

Immediately increasing the backup frequency

Deleting the secondary replica to save costs

Documenting the test results and lessons learned

Disabling all monitoring alerts

A company has a hybrid environment with an on-premises SQL Server and an Azure SQL Database. They want to use the Azure SQL Database as a reporting replica and as a DR target. The on-premises database is 1 TB and changes at 5 MB/s. The company has a 500 Mbps ExpressRoute connection. Which solution should you recommend?

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

Use SQL Server transactional replication from on-premises to Azure SQL Database.

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

Use log shipping to Azure SQL Database.

A company is designing a DR plan for a database. Management states that after a disaster, the database must be restored to a state no more than 15 minutes before the failure, and the application must be available within 2 hours. Which two metrics are these requirements?

RTO of 15 minutes and RPO of 2 hours

RPO of 15 minutes and RTO of 2 hours

RPO of 2 hours and RTO of 15 minutes

A company runs a line-of-business database on Azure SQL Database in the East US region. The compliance team requires that, in the event of a regional outage, no more than 15 minutes of data loss is acceptable and the database must be available within 1 hour. The application can be reconfigured to point to a different connection string. What should you configure?

A local zone-redundant configuration within the same region

Automated backups with point-in-time restore to a new server in a different region

Active geo-replication with a secondary in a paired region and automatic failover group

Long-term retention backups with geo-restore enabled

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 1

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

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 16–20

16application · medium
A company runs SQL Server on an Azure VM in the West US region. They also have an on-premises datacenter in Phoenix. The DR requirement is an RPO of 30 minutes and an RTO of 4 hours. The company wants to use Azure Site Recovery (ASR) for the VM. What additional configuration is required to meet the RPO?
Select an answer first
17foundation · easy
When planning a testing procedure for an HA/DR solution, which step is essential to include after the failover test is completed?
Select an answer first
18application · medium
A company has a hybrid environment with an on-premises SQL Server and an Azure SQL Database. They want to use the Azure SQL Database as a reporting replica and as a DR target. The on-premises database is 1 TB and changes at 5 MB/s. The company has a 500 Mbps ExpressRoute connection. Which solution should you recommend?
Select an answer first
19application · easy
A company is designing a DR plan for a database. Management states that after a disaster, the database must be restored to a state no more than 15 minutes before the failure, and the application must be available within 2 hours. Which two metrics are these requirements?
Select an answer first
20application · medium
A company runs a line-of-business database on Azure SQL Database in the East US region. The compliance team requires that, in the event of a regional outage, no more than 15 minutes of data loss is acceptable and the database must be available within 1 hour. The application can be reconfigured to point to a different connection string. What should you configure?
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.

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

Questions 16–20

When planning a testing procedure for an HA/DR solution, which step is essential to include after the failover test is completed?

A company is designing a DR plan for a database. Management states that after a disaster, the database must be restored to a state no more than 15 minutes before the failure, and the application must be available within 2 hours. Which two metrics are these requirements?

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