DP-300 Practice Test 47 — 15 Questions

Question 1

You have an Azure SQL Database configured with active geo-replication. The primary region experiences an outage that lasts longer than the recovery time objective (RTO) of 5 minutes. You need to initiate a failover to the secondary region with minimal data loss. What should you do?

Accepted Answer

Initiate a planned failover to the secondary region using the Azure portal.. Option B is correct because initiating a planned failover via the portal ensures the secondary becomes primary with minimal data loss by synchronizing data before failover. Option A is wrong because automatic failover groups are not configured here. Option C is wrong because geo-restore is for point-in-time recovery, not failover. Option D is wrong because forced failover may cause data loss.

Answer

Configure an auto-failover group and let it fail over automatically.

Answer

Force a failover to the secondary region using a PowerShell script.

Answer

Use geo-restore to recover the database from the most recent geo-replicated backup.

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

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 4

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 5

Your organization uses Azure SQL Database Hyperscale tier. You need to ensure that if the primary region fails, the database can be failed over to a secondary region with minimal data loss. What should you configure?

Accepted Answer

Set up active geo-replication to a secondary region.. Option A is correct because Hyperscale supports geo-replication to a secondary region. Option B is wrong because zone redundancy is within region. Option C is wrong because failover groups are supported but require geo-replication. Option D is wrong because geo-restore has higher RPO.

Answer

Use geo-restore from geo-redundant backups.

Answer

Enable zone redundancy on the Hyperscale database.

Answer

Configure an auto-failover group with a secondary in the same region.

Question 6

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database backup policy. The database is used for a reporting workload that is updated daily. The compliance team requires that point-in-time restore (PITR) be available for the past 30 days. What action should you take?

Accepted Answer

Change the retentionDays property to 30.. Option B is correct because the retentionDays property is set to 14, which is less than the required 30 days. The diffBackupIntervalInHours is not relevant for PITR retention. Option A is wrong because PITR retention is not set by the diff backup interval. Option C is wrong because PITR retention is not set by long-term retention. Option D is wrong because 14 days does not meet the requirement.

Answer

Change the diffBackupIntervalInHours to 24.

Answer

No action is needed; the current policy meets the requirement.

Answer

Add a long-term retention policy with a weekly retention of 30 days.

Question 7

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 8

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 9

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 10

You manage an Azure SQL Managed Instance in the East US region. To meet a 5-second RPO, you configure a failover group with a secondary in West US. During a planned maintenance, the primary becomes unavailable. The failover group is set to automatic with a grace period of 1 hour. You need to minimize downtime. What should you do?

Accepted Answer

Initiate a manual forced failover to the secondary.. Option D is correct because performing a manual failover immediately reduces downtime without waiting for the grace period. Option A is wrong because waiting for automatic failover would take up to 1 hour. Option B is wrong because altering the grace period requires downtime. Option C is wrong because creating a new secondary takes time.

Answer

Drop the failover group and create a new one with immediate failover.

Answer

Wait for the automatic failover to occur after the grace period.

Answer

Alter the failover group grace period to 0 and wait for automatic failover.

Question 11

You are the database administrator for a global e-commerce company. The company uses Azure SQL Database in the Business Critical service tier for its transactional database, db1, hosted in the East US region. The database is 500 GB and experiences high write throughput. The current disaster recovery solution uses active geo-replication to a secondary in West US, but during a recent failover drill, the failover took 45 seconds, exceeding the corporate RTO of 30 seconds. The RPO requirement is zero data loss. You need to improve the failover time while maintaining zero data loss. The secondary must be in a different Azure region for compliance. What should you do?

Accepted Answer

Configure an auto-failover group between East US and West US using zone-redundant deployment within each region and ensure the secondary is zone-redundant.. Option B is correct because using an auto-failover group with a secondary in the same region (West US) but in a different availability zone provides synchronous replication with zero data loss and faster failover due to lower latency. Option A is wrong because increasing replicas does not reduce failover time significantly. Option C is wrong because changing to General Purpose would increase RPO. Option D is wrong because Hyperscale does not guarantee zero data loss in this context.

Answer

Increase the number of replicas in the Business Critical tier to 5.

Answer

Change the secondary to a General Purpose tier and use async replication.

Answer

Move both primary and secondary to Hyperscale tier and use named replicas.

Question 12

You have an Azure SQL Database that uses active geo-replication between two regions. You need to ensure minimal data loss during an unplanned failover while maintaining the current configuration. Which THREE settings should you verify? (Choose three.)

Accepted Answer

The replication mode is 'async' (asynchronous) with a low RPO target.. Options A, C, and D are correct. The seed type determines initial synchronization. The secondary type (readable/non-readable) affects performance but not data loss. The failover group name is for management. Option B is wrong because secondary type does not affect data loss. Option E is wrong because it's part of the failover group name.

Answer

The secondary database is configured as 'readable' to avoid lag.

Answer

The failover group is named with a 'forced' failover policy.

Question 13

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 14

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 15

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.