AZ-305 Design business continuity solutions Practice Test 2 — 15 Questions

Question 1

A company runs SQL Server on an Azure virtual machine. They need to automate database backups with application-consistency and retain backups for 10 years to meet compliance. They also want to restore to any point in time within the last 35 days. Which Azure Backup solution should they use?

Accepted Answer

Azure Backup for SQL Server in Azure VM. Azure Backup for SQL Server in Azure VM (Option A) is correct because it provides native application-consistent backups for SQL Server databases running on Azure VMs, supports long-term retention (LTR) up to 10 years using the backup vault's retention rules, and enables point-in-time restore (PITR) for the last 35 days by leveraging SQL Server transaction log backups. This solution is specifically designed for SQL Server workloads and meets both compliance and recovery requirements without additional infrastructure.

Answer

Azure Backup for Azure VM

Answer

Azure Site Recovery

Answer

SQL Server Always On Availability Groups

Question 2

A company runs a critical application that uses Azure SQL Managed Instance in the West Europe region. They need to ensure that the database remains available if a regional failure occurs. The solution must provide automatic failover with an RPO of less than 5 seconds and an RTO of less than 1 minute. The secondary region must also be able to serve read-only queries for reporting purposes. Which Azure service should they use?

Accepted Answer

Configure Azure SQL Managed Instance with an auto-failover group to a secondary instance in North Europe.. Azure SQL Managed Instance supports auto-failover groups, which enable automatic, synchronous replication of databases to a secondary instance in a paired region (North Europe). This provides an RPO of less than 5 seconds (synchronous commit) and an RTO of under 1 minute, while the secondary can be used for read-only queries by adding the `-AllowReadOnlyFailoverToSecondary` parameter or using the listener's read-only endpoint. This meets all stated requirements for regional failover, low RPO/RTO, and read-only reporting.

Answer

Enable read-access geo-redundant storage (RA-GRS) on the storage account hosting the database files.

Answer

Deploy SQL Server Always On Availability Groups with a synchronous replica in North Europe.

Answer

Use Azure Site Recovery to replicate the SQL Managed Instance to a secondary region as a virtual machine.

Question 3

A company has an on-premises Hyper-V environment with 20 virtual machines running various workloads. They want to use Azure as a disaster recovery site. The required recovery point objective (RPO) is 15 minutes, and the recovery time objective (RTO) is 2 hours. They want to automate failover and failback. Which Azure service should they use?

Accepted Answer

Azure Site Recovery. Azure Site Recovery (ASR) is the correct service because it provides orchestrated replication, failover, and failback for Hyper-V VMs to Azure as a DR site. It supports the required RPO of 15 minutes (using near-synchronous replication with change tracking) and RTO of 2 hours (via automated recovery plans), and it natively automates both failover and failback processes without additional scripting.

Answer

Azure Migrate

Answer

Azure Backup

Answer

Azure Recovery Services Vault

Question 4

A company runs a file server on an Azure VM in the East US region. They want to back up the file shares to Azure and be able to restore individual files if accidentally deleted. They also need to be able to restore the entire file share to a secondary region (West US) in case of a regional disaster. The solution should automatically protect the file shares and provide versioning for up to 30 days. Which Azure service and configuration should they recommend?

Accepted Answer

Configure Azure Backup on the Azure file share using a Recovery Services vault with geo-redundant storage (GRS). Enable cross-region restore on the vault.. Azure Backup for Azure file shares uses a Recovery Services vault and can be configured with geo-redundant storage (GRS) to replicate backup data to a paired secondary region. Enabling cross-region restore on the vault allows restoring the entire file share to the secondary region (West US) during a regional disaster. Azure Backup automatically protects the file share with scheduled backups and provides up to 30 days of retention for point-in-time restores of individual files or the entire share.

Answer

Use Azure File Sync to sync the file share to an on-premises server, and then back up the on-premises server using Azure Backup.

Answer

Enable soft delete and versioning on the storage account, and configure replication to a secondary region using RA-GRS.

Answer

Create a scheduled Azure Automation runbook that takes snapshots of the file share every day and copy them to a storage account in West US.

Question 5

A company runs a critical SQL Server database on an Azure virtual machine. They need a backup strategy that supports point-in-time restore down to the second and long-term retention of backups for 7 years to meet compliance. They want to offload backup management to Azure. Which backup solution should they use?

Accepted Answer

Azure Backup for SQL Server on Azure VM. Azure Backup for SQL Server on Azure VM provides native integration that supports point-in-time restore down to the second for SQL Server databases and allows configuring long-term retention (LTR) for up to 10 years, meeting the 7-year compliance requirement. It offloads backup management to Azure by automating backup schedules, retention policies, and restore operations without requiring manual scripting or third-party tools.

Answer

Azure Site Recovery

Answer

SQL Server managed backup to Azure

Answer

Azure Disk Backup

Question 6

A company backs up their Azure VMs using Azure Backup. They need to meet compliance that requires backups to be stored in a separate geographic region. Additionally, they want to be able to restore the entire VM to that secondary region in case of a regional disaster. What should they configure?

Accepted Answer

Use a Recovery Services vault with Geo-Redundant Storage (GRS) and enable cross-region restore. Option B is correct because Azure Backup with a Recovery Services vault using Geo-Redundant Storage (GRS) replicates backup data to a paired secondary region, meeting the compliance requirement for geographic separation. Enabling cross-region restore allows the entire VM to be restored in that secondary region during a regional disaster, as the backup data is already available there.

Answer

Use a Recovery Services vault with Locally Redundant Storage (LRS) and enable cross-region restore

Answer

Use Azure Site Recovery to replicate the entire VM to the secondary region

Answer

Manually copy backup snapshots to a storage account in the secondary region

Question 7

A company runs a critical web application on Azure VMs that uses Azure SQL Database. They need a disaster recovery solution that provides automatic failover to a secondary region with an RPO of 5 seconds and an RTO of 1 minute. The secondary region must also be able to serve read-only queries for reporting purposes. Which Azure SQL Database feature should they use?

Accepted Answer

Azure SQL Database with active geo-replication and an auto-failover group. Active geo-replication with an auto-failover group is the correct choice because it provides automatic, asynchronous replication of data to a secondary region with an RPO of 5 seconds (typically under 5 seconds) and an RTO of 1 minute when the failover group is configured with a grace period. Additionally, the secondary replica can be used for read-only queries by connecting with ApplicationIntent=ReadOnly, meeting the reporting requirement.

Answer

Azure SQL Database with geo-restore

Answer

Azure SQL Database with a standby replica

Answer

Azure SQL Database with cross-region failover

Question 8

A company runs a multi-tier application on Azure VMs in the West US region. The application has web, application, and database tiers. They want to use Azure Site Recovery for disaster recovery to East US. They need to ensure that after failover, the web tier starts first, then the application tier, and finally the database tier after a consistency check. They also need to be able to perform non-disruptive DR drills. Which Azure Site Recovery capabilities should they use together?

Accepted Answer

Create a recovery plan with custom groups and scripts for startup order, and use test failover for DR drills. Azure Site Recovery (ASR) recovery plans allow you to define custom groups and scripts to control the startup order of VMs after failover. By placing the web, application, and database tiers into separate groups with pre- and post-actions (e.g., PowerShell scripts), you can ensure the web tier starts first, then the application tier, and finally the database tier after a consistency check. ASR's test failover capability performs a non-disruptive DR drill by creating isolated copies of VMs in a separate VNet without impacting the production environment.

Answer

Use Azure Backup for the VMs and restore them in order after failover

Answer

Use an availability set to control startup order and use disaster recovery drills in a separate VNet

Answer

Use Azure Traffic Manager to route traffic after failover and manually start VMs in order

Question 9

A company runs a critical application on Azure virtual machines in the West US region. They need a disaster recovery solution that replicates VMs to East US with a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 2 hours. They also need to perform non-disruptive disaster recovery drills. Which Azure service should they use?

Accepted Answer

Azure Site Recovery. Azure Site Recovery (ASR) orchestrates replication, failover, and failback of Azure VMs between regions. It supports RPOs as low as 15 minutes (continuous replication with crash-consistent or app-consistent snapshots) and RTOs of 2 hours or less, and it enables non-disruptive disaster recovery drills via test failover that isolates replicated VMs in a separate virtual network without impacting production.

Answer

Azure Backup

Answer

Azure Traffic Manager

Answer

Azure Front Door

Question 10

A company runs SQL Server on an Azure virtual machine. They need to ensure high availability within a single Azure region. The solution must provide automatic failover with zero data loss (synchronous replication) and support read-only routing for reporting workloads. Which solution should they implement?

Accepted Answer

SQL Server Always On Availability Group. SQL Server Always On Availability Groups (AG) provide high availability and disaster recovery at the database level. They support synchronous replication with automatic failover, ensuring zero data loss (RPO=0) within a single Azure region. Additionally, AGs allow secondary replicas to be configured as readable, enabling read-only routing for reporting workloads, which directly meets all stated requirements.

Answer

SQL Server Failover Cluster Instance (FCI)

Answer

Azure Site Recovery

Answer

Azure Backup

Question 11

A company runs a critical line-of-business application on 10 Azure VMs. They need a disaster recovery solution that replicates the VMs to a secondary region with a recovery point objective (RPO) of 30 minutes and a recovery time objective (RTO) of 1 hour. The solution must support non-disruptive testing of failover for quarterly compliance drills. Which Azure service should they use?

Accepted Answer

Azure Site Recovery. Azure Site Recovery (ASR) orchestrates replication, failover, and failback of Azure VMs to a secondary region, meeting the RPO of 30 minutes (continuous replication with 30-second RPO) and RTO of 1 hour (orchestrated recovery). It supports non-disruptive test failovers via isolated networks, which is essential for quarterly compliance drills without impacting production.

Answer

Azure Backup

Answer

Azure Migrate

Answer

Manual VM replication to secondary region

Question 12

A company uses Azure Backup to protect their critical Azure VMs. An administrator accidentally deleted a file from one of the VMs. They need to restore that specific file quickly without restoring the entire VM. Which Azure Backup feature should they use?

Accepted Answer

Azure Backup file recovery. Azure Backup's file recovery feature allows you to mount a recovery point as a drive on the VM (or another machine) using iSCSI, enabling you to browse and copy individual files without restoring the entire VM. This is the correct choice because it meets the requirement for a quick, granular restore of a single deleted file.

Answer

Azure Backup full VM restore

Answer

Azure Site Recovery

Answer

Azure Storage snapshots

Question 13

A company runs a critical application using Azure SQL Database in the West US region. They need a disaster recovery solution that automatically fails over to a secondary region (East US) with a recovery point objective (RPO) of 5 seconds and a recovery time objective (RTO) of 1 minute. The secondary region must also be able to serve read-only queries for reporting purposes. Which Azure SQL Database feature should they implement?

Accepted Answer

Azure SQL Database active geo-replication with auto-failover group. Active geo-replication with auto-failover groups is the correct choice because it provides automatic, synchronous failover to a secondary region with an RPO of 5 seconds and an RTO of 1 minute. Additionally, the secondary database can be used for read-only reporting by connecting with the 'ApplicationIntent=ReadOnly' connection string, meeting both the disaster recovery and reporting requirements.

Answer

Azure SQL Database geo-restore

Answer

Azure SQL Database copy

Answer

Azure SQL Managed Instance failover group

Question 14

A company runs a critical SQL Server database on an Azure virtual machine. They need a high-availability solution within a single region that provides automatic failover, zero data loss (synchronous replication), and support read-only routing for reporting workloads. Which solution should they implement?

Accepted Answer

SQL Server Always On Availability Group with synchronous replication across availability zones. SQL Server Always On Availability Group with synchronous replication across availability zones meets all requirements: it provides automatic failover, zero data loss through synchronous commit mode, and supports read-only routing by directing reporting workloads to readable secondary replicas. This solution operates within a single Azure region using availability zones for high availability.

Answer

SQL Server Always On Failover Cluster Instance (FCI) with shared disks

Answer

Azure SQL Database Managed Instance with active geo-replication

Answer

Azure SQL Database with active geo-replication

Question 15

A company runs a critical application on Azure VMs in the West US region. They want to protect against a regional disaster by replicating VMs to East US using Azure Site Recovery. They have both managed and unmanaged disks. They need to ensure that after failover, the recovery VMs are automatically placed in a specific availability set to support the application's multi-tier architecture. Additionally, they want to minimize downtime during planned failover. Which configuration should they use?

Accepted Answer

Configure a recovery plan that includes the VMs and specifies the target availability set and failover order. Option A is correct because a recovery plan in Azure Site Recovery allows you to group VMs, specify the target availability set, and define the failover order. This ensures that after failover, the recovery VMs are automatically placed in the specified availability set, supporting the application's multi-tier architecture. Additionally, recovery plans enable you to automate and sequence failover steps, minimizing downtime during planned failover by orchestrating the process efficiently.

Answer

Set the target availability set in each VM's replication settings individually without a recovery plan

Answer

Use Azure Traffic Manager to route traffic to the secondary region after manual failover

Answer

Enable consistency groups across the VMs using a replication policy