DP-300 Practice Test 45 — 15 Questions

Question 1

You have an Azure SQL Database in the Hyperscale service tier. You need to ensure that the database remains available during a single Azure zone failure. The solution must not require manual intervention. What should you configure?

Accepted Answer

Enable zone redundancy on the Hyperscale database.. Option A is correct because Hyperscale supports zone redundancy, which automatically places replicas in different zones. Option B (active geo-replication) is for DR, not zone failure. Option C (failover group) is for managed instances. Option D (auto-failover group) is for managed instances, not Hyperscale databases.

Answer

Create a failover group with a secondary in a different zone.

Answer

Configure active geo-replication to a secondary server in a different zone.

Answer

Configure an auto-failover group with a secondary in a different zone.

Question 2

You manage an Azure SQL Database that uses the General Purpose tier. The database has a failover group with a secondary in a paired region. During a regional outage, you initiate a forced failover. After the outage is resolved, you want to bring the original primary region back online without data loss. What should you do?

Accepted Answer

Wait for data synchronization, then initiate a planned failover.. Option C is correct because after a forced failover, the old primary becomes a secondary. To fail back, you need to re-sync data (which happens automatically) and then perform a planned failover to switch roles without data loss. Option A is wrong because it causes data loss. Option B is wrong because you cannot simply delete and re-add; the group still exists. Option D is wrong because a forced failover from the new primary would cause data loss.

Answer

Initiate a forced failover from the new primary to the old primary.

Answer

Perform a forced failover again to switch back.

Answer

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

Question 3

Your company has a SQL Server on Azure VM hosting a critical database. You need to ensure high availability with automatic failover and no data loss during a planned patching event. The solution must minimize cost. Which configuration should you use?

Accepted Answer

Deploy two Azure VMs in an availability set, configure SQL Server Always On availability group with synchronous commit and automatic failover.. Option A is correct because SQL Server Always On availability groups with synchronous replication and automatic failover meet the requirement of no data loss and automatic failover. Option B is wrong because FCI with Storage Spaces Direct does not provide automatic failover for planned patching. Option C is wrong because log shipping is not automatic. Option D is wrong because Azure SQL Database Managed Instance is not for SQL Server on Azure VM.

Answer

Migrate to Azure SQL Database Managed Instance and configure geo-replication.

Answer

Configure log shipping with a secondary VM in another region.

Answer

Use a single VM with a failover cluster instance (FCI) using Storage Spaces Direct.

Question 4

Your company has an Azure SQL Database in the East US region. You need to configure a disaster recovery solution that provides a readable secondary in the West US region with an RPO of 5 seconds. The solution must support automatic failover from the application. What should you configure?

Accepted Answer

Create an auto-failover group with a secondary server in West US using synchronous replication.. Option A is correct because auto-failover groups with synchronous replication can achieve an RPO of 5 seconds and provide automatic failover. Option B is wrong because active geo-replication does not support automatic failover. Option C is wrong because geo-restore does not provide a readable secondary. Option D is wrong because zone redundancy does not provide cross-region DR.

Answer

Enable zone-redundant replicas in the same region.

Answer

Enable geo-redundant backup storage and perform geo-restore.

Answer

Configure active geo-replication to a secondary server in West US.

Question 5

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 6

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 7

You run the above Kusto query and see that a database named 'OrdersDB' has high wait times for 'FAILOVER_GROUP_WAIT' every hour. What does this indicate?

Accepted Answer

Replication lag between primary and secondary is high. Option C is correct. 'FAILOVER_GROUP_WAIT' occurs when the secondary is behind due to replication lag. High wait times suggest significant replication lag. Option A is incorrect because the query does not indicate failover frequency. Option B is incorrect because it measures wait, not transaction throughput. Option D is incorrect because it is not a connection wait.

Answer

The secondary database is experiencing high connection requests

Answer

The primary database is not receiving any write transactions

Answer

The failover group is experiencing frequent automatic failovers

Question 8

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 9

You are planning a disaster recovery solution for an Azure SQL Managed Instance. The solution must meet the following requirements: provide automatic failover to a secondary region, support read-only workloads on the secondary, and allow manual failback. Which TWO features should you include? (Choose two.)

Accepted Answer

Failover group. Options A and D are correct. Failover groups provide automatic failover and support readable secondary. Manual failback is possible by initiating a failover in the opposite direction. Option B (active geo-replication) is not for managed instances. Option C (geo-restore) does not provide automatic failover. Option E (log shipping) is not built-in.

Answer

Active geo-replication

Answer

Geo-restore

Answer

Log shipping

Question 10

You have an Azure SQL Database in the Business Critical tier with zone redundancy enabled. The database experiences a brief outage due to a zone failure. How does the platform automatically recover?

Accepted Answer

A replica in another availability zone is automatically promoted to primary.. Option B is correct because the Business Critical tier with zone redundancy automatically fails over to a replica in another zone without data loss. Option A is wrong because the service heals itself without manual intervention. Option C is wrong because no data loss occurs (zero data loss is guaranteed). Option D is wrong because automatic failover happens within seconds.

Answer

You must perform a manual failover to a secondary replica.

Answer

The database is restored from the latest backup.

Answer

The database becomes read-only until the zone is restored.

Question 11

You are designing a disaster recovery plan for an Azure SQL Database that uses the Business Critical service tier. The database is 2 TB. You need to ensure that the secondary replica in a different Azure region is readable for reporting queries. What should you configure?

Accepted Answer

Configure active geo-replication to a secondary server in the target region.. Option B is correct because active geo-replication creates a readable secondary database in a different region. Option A is wrong because auto-failover groups require a secondary in the same region for readable secondaries. Option C is wrong because geo-restore is not readable during recovery. Option D is wrong because backup redundancy does not provide a readable secondary.

Answer

Create an auto-failover group with a secondary in the paired region.

Answer

Enable zone-redundant backup storage.

Answer

Use geo-restore from geo-redundant backups.

Question 12

You manage a critical database in Azure SQL Database that must recover within 5 minutes in case of a regional outage. You configure geo-replication. Which SKU guarantees the fastest failover time with the least data loss?

Accepted Answer

Business Critical (BC). Option C is correct because Azure SQL Database Business Critical tier uses premium SSDs and in-memory technologies, providing the lowest RPO and fastest failover (typically <30 seconds). Hyperscale (A) has longer failover and higher RPO. General Purpose (B) has higher RPO. Serverless (D) is not suitable for geo-replication.

Answer

General Purpose (GP)

Answer

Hyperscale (HS)

Answer

Serverless

Question 13

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 14

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 15

You have an Azure SQL Database that is part of a failover group with automatic failover. The primary region experiences a complete outage. The failover group automatically fails over to the secondary region. After the primary region is restored, you need to ensure the database is operational in the primary region with minimal data loss. What should you do?

Accepted Answer

Initiate a manual failover of the failover group back to the primary region.. Option C is correct because after automatic failover, you must manually fail back to re-establish the primary in the original region. Option A is wrong because automatic failover would have already occurred. Option B is wrong because restoring from backup would cause data loss. Option D is wrong because you cannot simply delete and recreate the failover group without data loss.

Answer

Wait for automatic failback to occur.

Answer

Restore the database from a geo-redundant backup.

Answer

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