DP-300 Practice Test 48 — 15 Questions

Question 1

You have an Azure SQL Database in the General Purpose service tier. The database must be available during a planned patching event that updates the underlying infrastructure. What high availability feature is provided by default?

Accepted Answer

Built-in high availability with a standby replica. Option B is correct because the General Purpose service tier uses local redundancy with built-in high availability through a standby replica on a different node. Option A is wrong because zone redundancy is not default for General Purpose. Option C is wrong because geo-replication requires manual setup. Option D is wrong because Business Critical is a different tier.

Answer

Active geo-replication

Answer

Zone-redundant availability

Answer

Business Critical service tier

Question 2

You are designing a disaster recovery plan for an Azure SQL Managed Instance that hosts a financial application. The application requires an RPO of 0 seconds and an RTO of 30 seconds. Which TWO configurations meet these requirements? (Choose two.)

Accepted Answer

Deploy a Business Critical instance with zone redundancy and a failover group to a secondary instance in a paired region, using the Business Critical service tier.. Options A and C are correct. To achieve zero data loss, you need synchronous replication within the primary region and a failover group that uses planned failover. Active geo-replication is asynchronous. Manual failover may not meet RTO. Option B is wrong because active geo-replication is asynchronous. Option D is wrong because manual failover is too slow. Option E is wrong because zone-redundancy alone does not provide zero RPO across regions.

Answer

Configure active geo-replication between two Business Critical instances in different regions.

Answer

Deploy a zone-redundant Business Critical instance in a single region and rely on automatic failover.

Answer

Set up a manual failover process using a PowerShell script that restores from the latest backup.

Question 3

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 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

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 6

A company plans to migrate an on-premises SQL Server database to Azure SQL Database Managed Instance. They require a high availability solution that provides automatic failover between replicas within the same region with an RPO of 0 and an RTO of less than 30 seconds. Which service tier should they choose?

Accepted Answer

Business Critical. Option A is correct because Business Critical service tier provides Always On availability groups with synchronous replicas ensuring zero data loss and fast failover. Option B is wrong because General Purpose has asynchronous replicas. Option C is wrong because Hyperscale uses buffer pool extension. Option D is wrong because Azure SQL Database is not Managed Instance.

Answer

General Purpose

Answer

Azure SQL Database (single)

Answer

Hyperscale

Question 7

You manage a critical application that uses Azure SQL Database in the West US region. The application requires an RPO of 5 seconds and an RTO of 1 hour in the event of a regional outage. You need to recommend a high availability solution that meets these requirements with minimal cost. What should you recommend?

Accepted Answer

Create a failover group with a secondary replica in a paired region using active geo-replication.. Option D is correct because failover groups with active geo-replication provide the lowest RPO (typically 5 seconds or less) and can meet an RTO of 1 hour with automated failover. Option A is wrong because zone-redundant configuration protects only within a region, not against regional failure. Option B is wrong because auto-failover groups without geo-replication also protect only within a region. Option C is wrong because geo-restore has a much higher RPO and RTO.

Answer

Configure an auto-failover group with a secondary in a different availability zone within West US.

Answer

Enable geo-restore for the database with a backup retention of 35 days.

Answer

Deploy a zone-redundant Azure SQL Database in the West US region.

Question 8

You manage an Azure SQL Managed Instance that hosts a line-of-business application. The instance is currently deployed in the UK South region using the General Purpose service tier. The business has a new requirement for disaster recovery with an RPO of 30 minutes and an RTO of 2 hours. You need to implement a solution that minimizes ongoing costs. The secondary region should be UK West. The application can tolerate a brief outage during failover. What should you do?

Accepted Answer

Deploy a secondary General Purpose instance in UK West and configure a failover group.. Option B is correct because a failover group with General Purpose instances meets the RPO/RTO at minimal cost. Option A is wrong because zone-redundancy doesn't protect regionally. Option C is wrong because Business Critical is more expensive than needed. Option D is wrong because manual restore cannot meet RTO.

Answer

Deploy a zone-redundant General Purpose instance in UK South only.

Answer

Keep the current instance and rely on geo-restore to UK West.

Answer

Upgrade both instances to Business Critical and configure a failover group.

Question 9

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 10

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 11

You are designing a disaster recovery plan for an Azure SQL Managed Instance in the East US region. The plan must meet an RPO of 15 minutes and an RTO of 1 hour. You need to minimize costs while meeting these requirements. Which solution should you recommend?

Accepted Answer

Configure a failover group between two General Purpose instances in different regions.. Option D is correct because geo-replication with a secondary in another region provides RPO of seconds and RTO of minutes, and using General Purpose tier minimizes cost. Option A is wrong because it doesn't cover regional DR. Option B is wrong because Managed Instance zones are not available in all regions. Option C is wrong because it's expensive and might not meet RTO.

Answer

Use a zone-redundant Business Critical instance.

Answer

Deploy a second instance in the same region with zone redundancy.

Answer

Configure a failover group between two Business Critical instances in different regions.

Question 12

You have an Azure SQL Database that uses the General Purpose service tier. The database is critical and you need to protect against a regional outage with an RPO of 1 hour and an RTO of 12 hours. What is the most cost-effective solution?

Accepted Answer

Use geo-restore with the default backup retention.. Option C is correct because geo-restore meets an RPO of 1 hour and RTO of 12 hours at no extra cost beyond backup storage. Option A is wrong because it is more expensive than needed. Option B is wrong because it also incurs extra cost. Option D is wrong because it does not protect against regional failure.

Answer

Enable active geo-replication.

Answer

Configure auto-failover group with a secondary in a different region.

Answer

Deploy a zone-redundant configuration.

Question 13

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

Question 14

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 15

Your company requires that all production databases in Azure SQL Database have an RPO of less than 5 seconds and an RTO of less than 1 minute during a regional outage. You need to recommend a high availability and disaster recovery solution. Which feature should you use?

Accepted Answer

Auto-failover groups with active geo-replication. Option C is correct because failover groups with active geo-replication provide the lowest RPO and RTO for regional outages. Option A is wrong because zone-redundant configuration protects only within a region. Option B is wrong because auto-failover groups without geo-replication are for within-region. Option D is wrong because long-term retention backup is for archival, not DR.

Answer

Zone-redundant configuration (Hyperscale service tier)

Answer

Long-term retention (LTR) backups

Answer

Geo-restore from geo-redundant backups