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

Question 1

Refer to the exhibit. You have an Azure SQL Database failover group configured with the ARM template snippet shown. You need to ensure that read-only queries are routed to the secondary region when the primary is healthy. What should you modify?

Accepted Answer

Set the readOnlyEndpoint failoverPolicy to Enabled.. Option D is correct because the read-only endpoint failover policy is currently Disabled; you need to enable it to allow read-only routing to the secondary. Option A is wrong because the grace period does not affect read-only routing. Option B is wrong because adding databases is unrelated. Option C is wrong because the read-only endpoint is separate from the read-write endpoint.

Answer

Set the readWriteEndpoint failoverPolicy to Manual.

Answer

Add the database to the partnerServers array.

Answer

Change the failoverGracePeriodMinutes to 0.

Question 2

Refer to the exhibit. You are configuring a backup policy for an Azure SQL Database. The database is in the East US region. You need to ensure that the database can be restored to a different region in the event of a regional disaster. Which setting in the exhibit must be correctly configured?

Accepted Answer

The backupStorageRedundancy is set to Geo.. Option B is correct because backupStorageRedundancy must be set to 'Geo' to enable geo-redundant backups that can be restored to a paired region. Option A is wrong because retention settings do not affect cross-region restores. Option C is wrong because geoBackupPolicy state being Enabled does not guarantee geo-redundancy if storage redundancy is not geo. Option D is wrong because the location in geoBackupPolicy is where the backup is stored, but the key is storage redundancy.

Answer

The geoBackupPolicy state is Enabled.

Answer

The geoBackupPolicy location is set to eastus2.

Answer

The weeklyRetention is set to P4W.

Question 3

Refer to the exhibit. You have an Azure SQL Managed Instance configured with the failover group properties shown. The primary region experiences an outage. After 30 minutes, the failover group has not failed over. You need to force failover immediately. What should you do?

Accepted Answer

Use the Switch-AzSqlDatabaseFailoverGroup cmdlet with -AllowDataLoss.. Option A is correct because the grace period is 60 minutes; after 30 minutes, you can force failover with data loss by using -AllowDataLoss. Option B is wrong because the grace period has not expired. Option C is wrong because the failover policy is already Automatic. Option D is wrong because the secondary type is Geo, which is correct.

Answer

Change the failover policy to Manual and then fail over.

Answer

Set the secondaryType to Standby.

Answer

Wait for the grace period to expire.

Question 4

Which TWO of the following are benefits of using Azure SQL Database failover groups for high availability?

Accepted Answer

Automatic failover to a secondary region based on a grace period.. Options A and D are correct. Failover groups provide automatic failover (A) and read-only routing (D). Option B is wrong because failover groups do not provide load balancing within a region. Option C is wrong because failover groups do not replicate data synchronously across zones within a region (zone-redundancy does). Option E is wrong because failover groups do not provide backup redundancy.

Answer

Synchronous replication of data across availability zones.

Answer

Load balancing read-write traffic across multiple replicas.

Answer

Geo-redundant backup storage for disaster recovery.

Question 5

Which THREE factors should you consider when choosing between active geo-replication and failover groups for an Azure SQL Database disaster recovery solution?

Accepted Answer

Failover groups require all databases in the group to fail over together.. Options A, C, and D are correct. Active geo-replication supports up to 4 secondaries (A). Failover groups provide a listener endpoint (C). Failover groups require all databases to fail over together (D). Option B is wrong because both support readable secondaries. Option E is wrong because both support the same tiers.

Answer

Active geo-replication is only available in the Business Critical tier.

Answer

Failover groups do not support readable secondaries.

Question 6

Which TWO of the following are valid methods to recover an Azure SQL Database after a regional outage?

Accepted Answer

Fail over to a secondary region using a failover group.. Options B and D are correct. Geo-restore uses geo-redundant backups (B). Failover groups with automatic failover can recover (D). Option A is wrong because point-in-time restore is limited to the same region. Option C is wrong because you cannot directly copy from geo-backup without restore. Option E is wrong because replication from a backup is not a standard recovery method.

Answer

Replicate the database from a backup to a secondary region using log shipping.

Answer

Point-in-time restore to a time before the outage.

Answer

Copy the database from a geo-redundant backup to a new server.

Question 7

You manage a critical SQL Server on Azure Virtual Machine running SQL Server 2019. The VM is in a single availability set. You need to ensure automatic failover in case of a zone-level failure. What should you implement?

Accepted Answer

Deploy the VM in an availability zone and configure an Always On availability group with a secondary replica in another zone.. Option A is correct because deploying the VM in an availability zone with Azure SQL Managed Instance or SQL Server on Azure VM with Always On availability groups using zone-redundant storage provides zone-level resilience. Option B is incorrect because geo-replication is for regional failures, not zonal. Option C is incorrect because automated backups do not provide failover. Option D is incorrect because a single VM in an availability set protects against rack failures but not zone failures.

Answer

Place the VM in an availability set.

Answer

Enable geo-replication to another Azure region.

Answer

Configure automated backups with long-term retention.

Question 8

Your company uses Azure SQL Database in a General Purpose service tier. You need to minimize downtime during a planned patching event. Which feature should you enable?

Accepted Answer

Zone-redundant configuration. Option B is correct because zone-redundant configuration for Azure SQL Database provides high availability by replicating across zones, reducing downtime during patching. Option A is incorrect because geo-replication is for disaster recovery. Option C is incorrect because auto-failover groups require geo-replication. Option D is incorrect because read scale-out only offloads read workloads.

Answer

Auto-failover group

Answer

Read scale-out

Answer

Active geo-replication

Question 9

You have a SQL Server 2022 on Azure VM configured with a Basic availability group for a line-of-business application. The application requires automatic failover without manual intervention. What additional component is needed?

Accepted Answer

Windows Server Failover Cluster (WSFC). Option A is correct because a Basic availability group requires a Windows Server Failover Cluster (WSFC) with an odd number of voting nodes to achieve automatic failover. Option B is incorrect because a listener is for client connectivity, not for automatic failover. Option C is incorrect because a virtual network gateway is for cross-premises connectivity. Option D is incorrect because Azure Load Balancer is used for listener IP, not for automatic failover itself.

Answer

Azure Load Balancer

Answer

Virtual network gateway

Answer

Availability group listener

Question 10

You have an Azure SQL Database configured with active geo-replication to a secondary region. The primary region experiences a full outage. You need to fail over with minimal data loss. What should you do?

Accepted Answer

Initiate a planned failover from the primary to the secondary.. Option B is correct because a planned failover (with data synchronization) ensures minimal data loss by syncing data before switching. Option A is incorrect because an unplanned failover may lose transactions not yet replicated. Option C is incorrect because you need to failover, not delete the secondary. Option D is incorrect because creating a new secondary does not failover.

Answer

Initiate an unplanned failover from the primary to the secondary.

Answer

Delete the secondary database and create a new one in the primary region.

Answer

Create a new secondary database in the same region as the primary.

Question 11

You need to design a disaster recovery plan for an Azure SQL Managed Instance. The recovery time objective (RTO) is 1 hour, and the recovery point objective (RPO) is 15 minutes. What is the most cost-effective solution?

Accepted Answer

Create an auto-failover group with a secondary instance in a paired region.. Option D is correct because auto-failover groups with a secondary in a paired region provide RTO of ~1 hour and RPO of 5 seconds to 5 minutes, meeting the requirements cost-effectively. Option A is incorrect because active geo-replication is not supported for Managed Instance. Option B is incorrect because log shipping is not natively supported. Option C is incorrect because point-in-time restore has longer RTO.

Answer

Configure active geo-replication between instances in different regions.

Answer

Set up log shipping to a secondary instance.

Answer

Use point-in-time restore to a secondary region.

Question 12

You have a SQL Server on Azure VM running a mission-critical database. The VM is configured with Azure Site Recovery (ASR) for disaster recovery. During a disaster recovery drill, you notice that the recovered database is not consistent. What is the most likely cause?

Accepted Answer

Application-consistent snapshots are not enabled in the ASR replication policy.. Option C is correct because ASR replicates at the VM level, not application-consistent unless application-consistent snapshots are configured. Option A is incorrect because ASR does not require Always On AG. Option B is incorrect because ASR supports cross-region replication. Option D is incorrect because backup retention does not affect ASR consistency.

Answer

The secondary region is not in the same geo as the primary.

Answer

The backup retention period is too short.

Answer

The database is not part of an Always On availability group.

Question 13

You need to ensure high availability for an Azure SQL Database in the Business Critical service tier. Which feature provides the fastest failover within the same region?

Accepted Answer

Built-in Always On availability groups. Option B is correct because Business Critical tier uses Always On availability groups with synchronous replication, providing fast automatic failover within the region. Option A is incorrect because zone-redundant configuration adds zone resilience but not faster failover within a zone. Option C is incorrect because read scale-out does not provide failover. Option D is incorrect because geo-replication is for cross-region failover.

Answer

Zone-redundant configuration

Answer

Read scale-out

Answer

Active geo-replication

Question 14

Your company has an Azure SQL Database with a failover group configured to a secondary region. The primary region experiences a temporary network issue. The failover group is set to automatic failover with a grace period of 1 hour. What will happen?

Accepted Answer

Automatic failover will start after 1 hour if the primary is still unreachable.. Option A is correct because automatic failover occurs only after the grace period expires and the primary is unreachable. Option B is incorrect because the grace period allows time for the primary to recover. Option C is incorrect because the secondary is already provisioned. Option D is incorrect because you cannot manually failover during the grace period if automatic failover is enabled.

Answer

Automatic failover will happen immediately.

Answer

You must manually initiate failover.

Answer

The secondary database will be deleted and re-created.

Question 15

You have a SQL Server on Azure VM running SQL Server 2022 with a Distributed availability group (DAG) for disaster recovery across two Azure regions. You need to ensure that the secondary replica can become the primary without data loss if the primary region fails. What setting must be configured?

Accepted Answer

Synchronous commit mode on the distributed AG. Option D is correct because synchronous commit mode with automatic seeding ensures that all committed transactions are replicated to the secondary before acknowledgment. Option A is incorrect because asynchronous commit may cause data loss. Option B is incorrect because backup priority does not affect data loss. Option C is incorrect because automatic seeding is for initial setup, not ongoing synchronization.

Answer

Backup preference set to secondary

Answer

Asynchronous commit mode on the distributed AG

Answer

Automatic seeding enabled

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

Exhibit

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

Exhibit