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

Question 1

Which TWO of the following are benefits of using Azure SQL Database failover groups compared to active geo-replication? (Choose Two.)

Accepted Answer

Failover groups allow you to fail over multiple databases simultaneously.. Options A and D are correct. Failover groups allow multiple databases to fail over together as a unit (A) and provide a read-write listener endpoint that automatically updates after failover (D). Option B is incorrect because geo-replication also supports readable secondaries. Option C is incorrect because failover groups do not provide automatic failover without manual or auto-failover policy. Option E is incorrect because failover groups do not require additional costs beyond geo-replication.

Answer

Failover groups automatically fail over without any manual intervention.

Answer

Failover groups provide a readable secondary replica for read-only workloads.

Answer

Failover groups eliminate the need for geo-redundant storage.

Question 2

Which THREE of the following are prerequisites for configuring an Always On Availability Group on Azure VMs with automatic failover? (Choose Three.)

Accepted Answer

All VMs must be in the same availability set or availability zones.. Options A, C, and D are correct. A domain controller (A) is needed for Windows Server Failover Clustering. All VMs must be in the same availability set or availability zones (C). A load balancer (D) is required for the listener IP. Option B is incorrect because VMs can be in different regions, but then automatic failover across regions is not supported without additional configuration. Option E is incorrect because SQL Server authentication mode is not a prerequisite.

Answer

All VMs must use SQL Server authentication.

Answer

All VMs must be in the same Azure region.

Question 3

Which TWO of the following are valid reasons to use zone-redundant configuration for Azure SQL Database? (Choose Two.)

Accepted Answer

Protection against a single availability zone failure within a region.. Options B and D are correct. Zone-redundant configuration protects against failures within a region at the zone level (B) and provides higher availability than single-zone deployment (D). Option A is incorrect because zone redundancy does not protect against region-wide outages. Option C is incorrect because it does not reduce latency. Option E is incorrect because it does not provide geo-replication, only zonal redundancy.

Answer

Reduce read latency for globally distributed users.

Answer

Automatic failover to a paired region.

Answer

Protection against a regional disaster.

Question 4

You are reviewing the ARM template snippet for an Azure SQL Database failover group. The primary server is in East US. The secondary is in West Europe. The readWriteEndpoint has automatic failover with a grace period of 60 minutes. The readOnlyEndpoint is disabled. After a complete outage in East US, what will happen?

Accepted Answer

The failover group will wait 60 minutes, then automatically fail over to West Europe.. Option B is correct because with automatic failover policy and a grace period, the system will wait for 60 minutes before automatically failing over to West Europe. The read-only endpoint is disabled, so no read-only routing is available. Option A is incorrect because the grace period is 60 minutes, not zero. Option C is incorrect because automatic failover is enabled. Option D is incorrect because the failover will happen within 60 minutes, not immediately.

Answer

The failover group will not fail over automatically because the grace period is too long.

Answer

The failover group will immediately fail over to West Europe.

Answer

The failover group requires manual failover because readOnlyEndpoint is disabled.

Question 5

You query the sys.dm_geo_replication_link_status dynamic management view for an Azure SQL Database configured with active geo-replication. The exhibit shows the output. What does this indicate about the replication health?

Accepted Answer

The secondary is fully synchronized with minimal lag.. Option C is correct because replicationLag of 5 seconds indicates the secondary is catching up with minimal lag, and replicationState of CATCH_UP means it is fully synchronized. Option A is incorrect because 5 seconds lag is normal. Option B is incorrect because secondary role is expected. Option D is incorrect because the state is CATCH_UP, not SEEDING.

Answer

The secondary role indicates a failover has occurred.

Answer

The secondary is 5 seconds behind, indicating a problem.

Answer

The replication is in the seeding phase.

Question 6

You are preparing a disaster recovery runbook. You plan to use the PowerShell command shown in the exhibit to restore a database to a different region. What must be true for this command to succeed?

Accepted Answer

The source database must have geo-redundant backup storage configured.. Option B is correct because Restore-AzSqlDatabase with -FromGeoBackup requires that the source database has geo-redundant backups (geo-redundant storage) enabled. Option A is incorrect because the source database does not need to be online; geo-backups are taken automatically. Option C is incorrect because the command uses -FromGeoBackup, not -FromPointInTimeBackup. Option D is incorrect because the target server can be different.

Answer

The source database must have point-in-time restore enabled.

Answer

The source database must be online at the time of restoration.

Answer

The target server must be in the same region as the source server.

Question 7

Your company runs a mission-critical Azure SQL Database in the East US region. To meet an RPO of 5 seconds and an RTO of 30 minutes in the event of a regional outage, which deployment option should you choose?

Accepted Answer

Failover groups with auto-failover policy. Option A is correct because failover groups with auto-failover policy provide automatic failover with an RPO of 5 seconds (default) and RTO of 30 minutes. Active geo-replication requires manual failover, which does not meet the RTO. Zone-redundant configuration only protects within a region. Backup restore has much higher RPO/RTO.

Answer

Zone-redundant configuration

Answer

Point-in-time restore

Answer

Active geo-replication with manual failover

Question 8

You have an Azure SQL Managed Instance configured with a failover group between two regions. The primary region becomes unavailable. You need to fail over to the secondary region with minimal data loss. What should you do?

Accepted Answer

Run 'az sql mi failover-group force-failover-allow-data-loss' from the Azure CLI. Option B is correct because during a disaster, you can perform a forced failover with data loss in a failover group. The command 'az sql mi failover-group force-failover-allow-data-loss' initiates the failover. Option A would fail because the primary is unavailable. Option C is for elastic pools, not MI. Option D is for single databases.

Answer

Add the secondary instance to an elastic pool and initiate failover

Answer

Run 'az sql mi failover-group failover' from the Azure CLI

Answer

Use Azure portal to initiate geo-failover for the managed instance

Question 9

A manufacturing company uses Azure SQL Database Hyperscale tier for its IoT telemetry data. The database is in West Europe and must be readable in East US for reporting with a maximum lag of 10 seconds. You configure a failover group with East US as the secondary region. After setup, reporting queries in East US show data that is 5 minutes old. What is the most likely cause?

Accepted Answer

The secondary database is configured with 'Geo' secondary type; you need to set it to 'Readable' to minimize lag. Option B is correct because by default, failover groups use asynchronous replication with a secondary type 'Geo' which may have higher lag. To achieve low lag, you must enable 'Configure secondary type' to 'Readable' (or 'Named' secondary in some configurations) which ensures near-synchronous replication, though still asynchronous. Option A is incorrect because the secondary is readable by default. Option C is not a standard setting. Option D is unrelated.

Answer

The failover group has 'Read/Write failover policy' set to 'Automatic' causing the lag

Answer

The secondary database is not readable; it is only for failover

Answer

The replication mode is set to 'Async' and should be changed to 'Sync'

Question 10

You are designing a disaster recovery plan for an Azure SQL Database that supports an e-commerce application. The application requires an RPO of 15 seconds and an RTO of 1 hour during a regional outage. Which solution should you recommend?

Accepted Answer

Deploy active geo-replication to a secondary region and automate failover. Option C is correct because active geo-replication allows you to create a readable secondary in another region with an RPO of 5 seconds and manual failover, which can meet the RTO if automated via scripts. Failover groups have a default RPO of 5 seconds but an RTO of 1 hour; however, active geo-replication with a manual failover script can achieve the required RTO. Zone redundancy does not protect against regional outage. Backup restore has higher RPO.

Answer

Create a failover group with automatic failover policy

Answer

Use long-term backup retention and restore in another region

Answer

Configure zone-redundant availability for the database

Question 11

Your company has an Azure SQL Managed Instance in the UK South region. You need to implement a disaster recovery solution that provides automatic failover to a secondary region and allows read-only workloads to use the secondary replica. The solution must minimize data loss. What should you configure?

Accepted Answer

Deploy a second managed instance and use auto-failover groups. Option D is correct because a failover group for Azure SQL Managed Instance provides automatic failover and a readable secondary. Option A is for SQL Server on VMs. Option B is for Azure SQL Database, not Managed Instance. Option C is incorrect because automatic failover is a feature of failover groups, not a separate configuration.

Answer

Create an availability group in the secondary region and configure automatic failover

Answer

Configure a failover group between two managed instances

Answer

Enable active geo-replication and configure auto-failover using PowerShell

Question 12

You are reviewing an Azure Policy definition that audits SQL Servers. Based on the exhibit, which condition triggers the audit effect?

Accepted Answer

The SQL Server uses service-managed TDE or has no encryption protector configured. Option B is correct. The policy 'if' condition requires allOf: type is 'Microsoft.Sql/servers', version is '12.0', and anyOf: encryption protector does not exist OR is 'ServiceManaged'. This audits SQL servers that do not use a customer-managed key for TDE. Option A is wrong because it requires both conditions. Option C is wrong because it ignores the key name condition. Option D is wrong because the policy checks for server version.

Answer

The SQL Server uses a customer-managed key from Azure Key Vault

Answer

The SQL Server does not have an encryption protector set to a customer-managed key

Answer

The SQL Server is version 12.0 and uses a customer-managed key

Question 13

You manage an Azure SQL Database that uses active geo-replication with a secondary in a paired region. During a planned maintenance, you need to fail over to the secondary with zero data loss. What should you do?

Accepted Answer

Execute a planned failover (graceful failover) using Transact-SQL or PowerShell. Option A is correct because a planned failover (graceful failover) ensures no data loss by synchronizing all transactions before switching. Option B causes data loss. Option C and D are not valid for planned failover.

Answer

Use Azure portal to 'Failover' without specifying data loss tolerance

Answer

Take the primary offline, then promote the secondary

Answer

Execute a forced failover allowing data loss

Question 14

Your company wants to ensure business continuity for an Azure SQL Database that is used by a critical application. The database must remain available in the event of a single availability zone failure within a region. Which configuration should you use?

Accepted Answer

Configure zone-redundant availability for the database. Option B is correct because zone-redundant configuration replicates data across three zones within a region, protecting against a single zone failure. Option A protects within a single zone. Option C is for regional disasters. Option D does not provide HA.

Answer

Use active geo-replication to a different region

Answer

Deploy the database with locally redundant storage

Answer

Configure read scale-out with a secondary replica

Question 15

You have an Azure SQL Database configured with a failover group that includes a secondary in another region. The primary region experiences a complete outage. You initiate a forced failover. After the outage is resolved, you want to bring the original primary back as a secondary without data loss. What should you do?

Accepted Answer

Remove the original primary from the failover group, drop the database, and recreate it as a new secondary. Option C is correct. After a forced failover, the original primary becomes unavailable. To rejoin it without data loss, you must remove the failed primary from the failover group, drop it, and then add a new secondary database (which will be seeded from the current primary). Restoring from backup (A) will cause data loss. Re-synchronizing (B) is not possible as the original primary is in a broken state. Forcing replication (D) is not a valid operation.

Answer

Use the 'az sql db failover-group re-sync' command to re-synchronize

Answer

Configure replication from the new primary to the old primary using active geo-replication

Answer

Restore the original primary from backup and re-add it to the failover group