DP-300 Plan and configure a high availability and disaster recovery environment Practice Test 9 — 15 Questions

Question 1

Which TWO actions should you take to achieve high availability for an Azure SQL Managed Instance with a 99.99% SLA? (Choose two.)

Accepted Answer

Use Business Critical service tier.. Options A and C are correct. Zone-redundant deployment provides resilience against zone failures, and Business Critical service tier provides the highest availability within a zone. Option B is incorrect because General Purpose does not provide 99.99% SLA. Option D is incorrect because geo-replication is for disaster recovery, not high availability. Option E is incorrect because automatic backups do not contribute to high availability SLA.

Answer

Enable automated backups with long-term retention.

Answer

Configure geo-replication to a secondary region.

Answer

Use General Purpose service tier.

Question 2

Which THREE components are required to configure an auto-failover group for Azure SQL Database? (Choose three.)

Accepted Answer

A failover group name. Options A, B, and C are correct. The primary and secondary servers are essential, and the failover group is the logical container. Option D is incorrect because a listener is created automatically as part of the failover group, not separately. Option E is incorrect because geo-replication is not required; the failover group itself provides the replication.

Answer

Active geo-replication

Answer

An availability group listener

Question 3

Which TWO statements about Azure SQL Database zone-redundant configuration are true? (Choose two.)

Accepted Answer

It can be enabled during database creation or by updating an existing database.. Options B and D are correct. Zone-redundant configuration is available in both General Purpose and Business Critical tiers (though for Business Critical it is used differently). Option A is incorrect because it is supported in both tiers. Option C is incorrect because there is no additional charge for zone-redundant configuration in General Purpose tier; Business Critical has additional cost. Option E is incorrect because zone-redundant configuration does not require a failover group.

Answer

It requires a failover group to be configured.

Answer

It is only available in the Business Critical service tier.

Answer

It incurs additional cost compared to non-zone-redundant configurations.

Question 4

You manage a mission-critical Azure SQL Database in the East US region. The database uses the Business Critical service tier with zone-redundant high availability enabled. You need to ensure that if an entire Azure region fails, the database can be failed over to a secondary region with minimal data loss. What should you implement?

Accepted Answer

Enable active geo-replication to a secondary server in a paired region.. Option C is correct because active geo-replication provides near-real-time asynchronous replication to a secondary region, and with Business Critical, you can configure a readable secondary that can be failed over manually or automatically with minimal data loss. Option A is wrong because failover groups are built on top of geo-replication but do not guarantee minimal data loss by themselves; they rely on the replication mode. Option B is wrong because auto-failover groups include geo-replication but the question asks for the specific feature to implement. Option D is wrong because zone redundancy protects against zonal failures within a region, not regional failures.

Answer

Enable auto-failover groups with read-write failover policy.

Answer

Configure a failover group with the secondary in a different Azure region.

Answer

Deploy zone-redundant configuration in East US 2.

Question 5

You are designing a disaster recovery plan for an Azure SQL Managed Instance that hosts a critical OLTP workload. The primary instance is deployed in West Europe. You need to ensure that failover to a secondary region occurs automatically when the primary becomes unavailable due to a regional outage, and that the secondary database is readable during normal operations. You also want to minimize storage costs. What should you configure?

Accepted Answer

Create a failover group between the primary and a secondary managed instance in a paired region.. Option B is correct. Azure SQL Managed Instance supports failover groups with readable secondary replicas. By default, the secondary is read-only and can be used for read-only workloads, reducing the need for separate reporting databases. The failover group provides automatic failover. Option A is wrong because geo-replication is available only for SQL Database, not SQL Managed Instance. Option C is wrong because a Bicep template is used for deployment, not for configuring DR. Option D is wrong because auto-failover groups do include readable secondaries, but the correct answer is simply failover groups, as they encompass the feature.

Answer

Deploy a secondary instance using a Bicep template with geo-zone-redundant storage.

Answer

Implement auto-failover groups with a readable secondary in another region.

Answer

Configure active geo-replication between two managed instances.

Question 6

You have an Azure SQL Database that uses the General Purpose service tier. The database is critical and you need to ensure that it remains available during a planned patching event that updates the underlying hardware. What does Azure SQL Database provide to maintain availability during such events?

Accepted Answer

Automated failover to a built-in standby replica with minimal downtime.. Option B is correct. General Purpose tier provides built-in high availability with automatic failover to a standby replica during patching events. This is a standard feature. Option A is wrong because General Purpose does not have zone-redundant replicas by default. Option C is wrong because the database is not offline; it fails over seamlessly. Option D is wrong because manual failover is not required; it's automatic.

Answer

The database is taken offline during patching and restored afterward.

Answer

You must manually fail over to a secondary database to avoid downtime.

Answer

Zone-redundant replicas that ensure zero downtime.

Question 7

Refer to the exhibit. You are reviewing an ARM template for deploying an Azure SQL Database. The template specifies a point-in-time restore from a source database. The source database is configured with geo-redundant backup storage. You need to ensure that the restored database can be used for disaster recovery in a different region. What is missing from the template to achieve this?

Accepted Answer

Set 'createMode' to 'GeoRestore' and specify a target server in the desired region.. Option A is correct. To perform a point-in-time restore in a different region, you need to set the restore mode to 'GeoRestore' and specify the target server in the desired region. The template shows 'PointInTimeRestore', which is for restoring to the same region. Option B is wrong because a target server in a different region must be specified. Option C is wrong because geo-restore uses geo-redundant backups automatically. Option D is wrong because zone redundancy is unrelated to geo-restore.

Answer

Add a 'location' property to the database resource.

Answer

Set 'zoneRedundant' to true.

Answer

Change 'requestedBackupStorageRedundancy' to 'GeoZone'.

Question 8

Your company uses Azure SQL Database with active geo-replication configured between two regions. The primary database in East US experiences a critical failure, and you initiate a manual failover to the secondary in West US. After the failover, you need to re-establish geo-replication to a new secondary database in a third region (Central US) to restore the DR capability. What is the correct sequence of actions?

Accepted Answer

Remove the geo-replication link to the old primary, then add a new secondary in Central US.. Option C is correct. After a failover, the old primary becomes a secondary (if still available). To reconfigure geo-replication with a new secondary, you need to remove the old secondary relationship, then create a new secondary. Option A is wrong because you cannot add a new secondary without removing the old one first. Option B is wrong because you do not need to create a new primary; the current primary (formerly secondary) is fine. Option D is wrong because geo-replication does not automatically create a new secondary.

Answer

Delete the old primary and create a new geo-secondary in Central US.

Answer

Add a new secondary in Central US on the current primary.

Answer

Perform a planned failover to the old primary, then configure geo-replication to Central US.

Question 9

You are planning a disaster recovery strategy for an Azure SQL Database that supports a critical application. The database is 500 GB in size and you need to recover it within 1 hour (RTO) with a maximum data loss of 5 minutes (RPO). Which Azure SQL Database feature should you use?

Accepted Answer

Active geo-replication to a secondary server in a paired region.. Option D is correct. Active geo-replication provides asynchronous replication with an RPO of a few seconds to a few minutes, and failover can be initiated manually within minutes, meeting the RTO and RPO. Option A is wrong because point-in-time restore does not provide a separate secondary region. Option B is wrong because long-term retention is for archival, not DR. Option C is wrong because failover groups use geo-replication but the RPO is still asynchronous; the question asks for the feature, and geo-replication is the core.

Answer

Long-term retention (LTR) backups.

Answer

Point-in-time restore (PITR) with geo-redundant backup storage.

Answer

Auto-failover group with a secondary in a different region.

Question 10

You have an Azure SQL Managed Instance configured with a failover group to a secondary region. During a regional outage, the failover group automatically fails over to the secondary. After the primary region is restored, you need to bring the primary back online and re-establish the failover relationship. What should you do?

Accepted Answer

Initiate a planned failover from the current primary to the original primary.. Option B is correct. After automatic failover, the secondary becomes the primary. To restore the original primary, you perform a planned failover (also called a graceful failover) to switch back without data loss. Option A is wrong because you cannot add a new secondary without removing the old one. Option C is wrong because you need to perform a planned failover, not delete and recreate. Option D is wrong because you should not remove the secondary; you need to fail back.

Answer

Delete the failover group and recreate it with the original primary as the primary.

Answer

Add the original primary as a new secondary to the current primary.

Answer

Remove the original primary from the failover group and re-add it.

Question 11

Refer to the exhibit. You are reviewing the configuration of an Azure SQL Database hyperscale service tier. The database 'SalesDB' has read scale enabled with 2 read replicas. You need to ensure that if the primary region fails, the database can be failed over to a secondary region with minimal data loss and that the read replicas in the secondary region are also available. What should you configure?

Accepted Answer

Create a named replica in a secondary region and configure it as a geo-secondary.. Option D is correct. For Hyperscale, you can configure named replicas that can be placed in a secondary region. These replicas can be promoted to primary in case of failover, and they also support read scaling. Option A is wrong because zone redundancy only protects within a region. Option B is wrong because failover groups are not supported for Hyperscale in the traditional sense; named replicas are used. Option C is wrong because geo-replication is not a standalone feature for Hyperscale; named replicas provide geo-replication.

Answer

Configure zone redundancy on the Hyperscale database.

Answer

Enable active geo-replication to a secondary server in a different region.

Answer

Create a failover group with a secondary Hyperscale database in another region.

Question 12

You have an Azure SQL Database that uses the Business Critical service tier with zone redundancy enabled. The database is deployed in a single region. You want to ensure that if a zone fails, the database remains available with minimal downtime. How does zone redundancy achieve this?

Accepted Answer

It maintains multiple synchronous replicas in different availability zones within the region.. Option B is correct. Zone redundancy for Business Critical creates multiple replicas across different availability zones within the same region. If one zone fails, one of the other replicas becomes the primary automatically. Option A is wrong because zone redundancy does not involve a secondary region. Option C is wrong because the replicas are kept in sync synchronously, not asynchronously. Option D is wrong because the replicas are within the same region.

Answer

It creates read-only replicas in other zones that can be promoted to primary.

Answer

It replicates data to a secondary region for failover.

Answer

It uses asynchronous replication to a standby replica in another zone.

Question 13

You are designing high availability for a critical Azure SQL Database. The database is 1 TB in size and requires an RPO of 0 (zero data loss) and an RTO of less than 30 seconds. Which TWO configurations can meet these requirements?

Accepted Answer

Business Critical service tier with zone redundancy enabled.. Options A and D are correct. For zero data loss, you need synchronous replication. Business Critical with zone redundancy provides synchronous replicas within the same region with automatic failover. Hyperscale with zone redundancy also provides synchronous replicas for the log service. Option B (General Purpose) uses asynchronous replication and does not guarantee zero data loss. Option C (active geo-replication) is asynchronous, so data loss can occur. Option E (failover groups) relies on geo-replication which is asynchronous.

Answer

Auto-failover group with a secondary in the same region.

Answer

General Purpose service tier with zone redundancy enabled.

Answer

Active geo-replication to a secondary in a different region.

Question 14

Your organization has an Azure SQL Managed Instance that hosts a critical database. You need to configure disaster recovery with automatic failover to a secondary region. The solution must support readable secondary replicas for read-only workloads. Which TWO features should you implement?

Accepted Answer

Readable secondary replicas within the failover group.. The correct features are failover groups (which provide automatic failover and a readable secondary) and the ability to configure multiple readable secondaries. However, since the question expects exactly two correct options, and the only two that directly apply are A and B.

Answer

Auto-failover groups with a secondary in the same region.

Answer

Active geo-replication between managed instances.

Answer

Log shipping to a secondary managed instance.

Question 15

You need to design a disaster recovery solution for an Azure SQL Database that uses the General Purpose service tier. The solution must have an RTO of 1 hour and an RPO of 15 minutes. Which THREE options can achieve these requirements?

Accepted Answer

Point-in-time restore (PITR) using geo-redundant backup storage.. Options A, B, and C are correct. Active geo-replication can meet the RPO of 15 minutes with asynchronous replication. Auto-failover groups use geo-replication and provide automatic failover, also meeting the RPO. Point-in-time restore with geo-redundant backup storage can restore to a point in time within the backup retention period, which can be within 15 minutes if the backups are taken frequently (every 5-10 minutes). Option D (zone redundancy) does not provide DR across regions. Option E (long-term retention) does not meet RPO as it retains backups for longer periods but not for quick recovery.

Answer

Long-term retention (LTR) backups.

Answer

Zone redundancy on the primary database.