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

Question 1

A company runs SQL Server on Azure VMs using SQL Server Standard Edition. They need a disaster recovery solution that replicates the database to a secondary Azure region with a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 2 hours. They cannot use Always On Availability Groups due to licensing constraints. They also need to perform non-disruptive disaster recovery drills. Which Azure service should they implement?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Azure Site Recovery. Azure Site Recovery (ASR) replicates entire SQL Server VMs (including their databases) to a secondary Azure region, supporting RPOs as low as 30 seconds and RTOs of 2 hours or less. It allows non-disruptive disaster recovery drills by performing test failovers in an isolated network without affecting the production environment. This solution avoids the licensing constraints of Always On Availability Groups and works with SQL Server Standard Edition.

Answer

Azure Backup for SQL Server

Answer

SQL Server Log Shipping to an Azure VM

Answer

Geo-replication for Azure SQL Database

Question 2

A company runs critical Azure VMs. They want to protect against accidental deletion or corruption of data by implementing a retention policy for Azure Backup. They need to keep daily backups for 30 days, weekly backups for 12 weeks, and monthly backups for 12 months. Which Azure Backup feature should they configure?

Accepted Answer

Backup policy with long-term retention. A backup policy with long-term retention (LTR) in Azure Backup allows you to define granular retention rules for daily, weekly, monthly, and yearly backup points. This directly meets the requirement to keep daily backups for 30 days, weekly for 12 weeks, and monthly for 12 months by configuring the retention duration for each frequency in the backup policy.

Answer

Immutable vault

Answer

Backup tiering

Answer

Soft delete

Question 3

A company runs a mission-critical application on Azure VMs in West US. They need a disaster recovery plan with an RPO of 5 minutes and an RTO of 30 minutes. The application consists of multiple VMs that must be recovered in a specific order: the database VM first, then the front-end VMs. They also need to ensure that after failover, the IP addresses of the VMs are retained to avoid DNS propagation delays. The company wants to test the recovery process periodically without affecting production. Which Azure Site Recovery features should they use?

Accepted Answer

Use recovery plans with virtual machine group ordering and failover network settings to assign static IPs.. Azure Site Recovery recovery plans allow you to define the order of VM recovery using groups, and you can assign static IP addresses via failover network settings to retain IPs after failover. This meets the RPO of 5 minutes (via continuous replication) and RTO of 30 minutes (via orchestrated failover), while test failover can be performed without impacting production.

Answer

Use failover settings with retention IP and test failover.

Answer

Use recovery plans with custom scripts for ordering and Azure Traffic Manager for IP retention.

Answer

Use Azure Site Recovery with Application Consistent Snapshots and ignore IP retention.

Question 4

A company runs several Azure virtual machines (VMs) that host SQL Server databases. The databases are stored on data disks attached to the VMs. The company needs to back up the databases and VMs separately. They require application-consistent backups for SQL Server to ensure transactional integrity. Additionally, they need to retain backups for up to 7 years to meet compliance requirements. The solution must minimize administrative overhead and support long-term retention of database backups. Which Azure service or feature should they use for the database backups?

Accepted Answer

Azure Backup for SQL Server in Azure VMs. Azure Backup for SQL Server in Azure VMs is the correct choice because it provides native, application-consistent backups specifically for SQL Server databases running on Azure VMs. It integrates directly with SQL Server VSS writer to ensure transactional integrity, supports long-term retention up to 10 years (exceeding the 7-year requirement), and minimizes administrative overhead by automating backup scheduling, retention management, and point-in-time restore. This service is purpose-built for SQL Server database backups, separate from VM-level backups.

Answer

Azure Backup for Azure VMs with application-consistent snapshots

Answer

Azure Site Recovery

Answer

Azure Files

Question 5

A company runs an SAP HANA database on Azure large instances (HLI) in the West US region. The database is critical for business operations. They need a disaster recovery solution with a recovery point objective (RPO) of near zero (seconds) and a recovery time objective (RTO) of less than 30 minutes in the event of a region-wide outage. The solution must automatically replicate data to a secondary region (East US) and support automated failover. Which design should they implement?

Accepted Answer

Configure HANA System Replication (async) between the primary and secondary site, and use a Pacemaker cluster with Azure Load Balancer to enable automated failover. HANA System Replication (async) provides near-zero RPO by continuously replicating log changes to the secondary region, while a Pacemaker cluster with Azure Load Balancer enables automated failover within the required 30-minute RTO. This combination meets the strict RPO/RTO requirements for SAP HANA on Azure Large Instances, as Azure Site Recovery does not support HLI and synchronous replication would introduce unacceptable latency over the West US to East US distance.

Answer

Use Azure Site Recovery to replicate the HANA large instance VMs with a replication frequency of 30 seconds and enable auto-failover

Answer

Schedule HANA database backups every 5 minutes to Azure Blob Storage with geo-redundant storage (GRS), and restore in the secondary region on demand

Answer

Set up HANA System Replication with synchronous mode to the secondary region

Question 6

A company runs a mission-critical application on Azure virtual machines (VMs) in the West US region. The application consists of multiple VMs that must be recovered in a specific order during a disaster: database VM first, then application VMs, then web VMs. They also require that after failover to East US, the VMs retain their private IP addresses to avoid DNS updates. The recovery point objective (RPO) is 5 minutes and recovery time objective (RTO) is 30 minutes. The company needs to perform quarterly disaster recovery tests without impacting production. Which combination of Azure Site Recovery features should they configure?

Accepted Answer

Use app-consistent replication, recovery plans with pre/post scripts for ordering, and static IP address assignment in failover settings. The requirement for an RPO of 5 minutes and RTO of 30 minutes necessitates application-consistent replication, which ensures database and application integrity. The need to recover VMs in a specific order is met by recovery plans with pre/post scripts, which allow custom actions (e.g., starting the database VM first, then application, then web). Static IP address assignment in failover settings ensures that VMs retain their private IP addresses after failover to East US, avoiding DNS updates.

Answer

Use crash-consistent replication, recovery plans with manual ordering, and target network with same IP address range

Answer

Use multi-VM consistency groups, recovery plans with automation runbooks, and Azure Traffic Manager to redirect traffic

Answer

Use application-consistent replication, recovery plans with pre/post scripts for ordering, and target network with different IP address range and DNS updates

Question 7

A company runs a critical application on Azure virtual machines (VMs) in the West US region. They need a disaster recovery solution that replicates the VMs to East US with a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 2 hours. The application consists of multiple VMs, and the company needs to be able to fail over a single VM without impacting others during an actual disaster. They also want to periodically test the recovery process without affecting the production environment. Which Azure Site Recovery feature should they use to enable non-disruptive testing?

Accepted Answer

Test failover. Test failover (Option C) is the correct feature because it allows you to validate your disaster recovery process by creating an isolated copy of your replicated VMs in a separate test network, without impacting the ongoing replication or the production environment. This directly meets the requirement for periodic, non-disruptive testing while maintaining the RPO of 15 minutes and RTO of 2 hours.

Answer

Recovery Plans

Answer

Planned failover

Answer

Network mapping

Question 8

A company runs a mission-critical multi-tier application on Azure VMs in West US. The application consists of database VMs, application VMs, and web VMs. During a disaster, the VMs must be recovered in a specific order: database tier first, then application tier, then web tier. The recovery point objective (RPO) is 5 minutes and recovery time objective (RTO) is 15 minutes. The company wants to periodically test the recovery process without impacting production. After failover to East US, the VMs must retain their private IP addresses to avoid DNS propagation delays. Which combination of Azure Site Recovery features should they configure?

Accepted Answer

A recovery plan, test failover, and static IP address assignment. A recovery plan enforces the required startup order (database → application → web), test failover allows non-disruptive validation of the recovery process, and static IP address assignment ensures VMs retain their private IP addresses after failover to East US, avoiding DNS propagation delays. This combination meets the RPO of 5 minutes and RTO of 15 minutes while satisfying the requirement for periodic testing without impacting production.

Answer

A recovery plan, planned failover, and network mapping

Answer

A recovery plan, test failover, and network mapping

Answer

A recovery plan, planned failover, and static IP address assignment

Question 9

A company runs a critical OLTP application on Azure SQL Database in the West US region. They need to ensure business continuity if a regional outage occurs. The solution must have a recovery point objective (RPO) of 5 seconds and a recovery time objective (RTO) of less than 1 hour. They also want to use the secondary region for read-only query offloading. Which Azure SQL Database feature should they enable?

Accepted Answer

Active geo-replication with automatic failover group. Active geo-replication with automatic failover groups is the correct choice because it provides continuous asynchronous data replication to a secondary Azure SQL Database in a paired region, achieving an RPO of 5 seconds and an RTO of under 1 hour. The automatic failover group enables coordinated failover of multiple databases and allows the secondary region to be used for read-only query offloading by connecting with ApplicationIntent=ReadOnly.

Answer

Geo-restore

Answer

Azure Site Recovery

Answer

Read scale-out with manual regional failover

Question 10

A company runs a critical 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 less than 1 hour. Additionally, they want to offload read-only workloads to the secondary database during normal operations. Which Azure SQL Database feature should they enable?

Accepted Answer

Active geo-replication with failover groups. Active geo-replication with failover groups is the correct choice because it provides automatic, asynchronous replication of an Azure SQL Database to a secondary region (East US) with an RPO of up to 5 seconds and an RTO of less than 1 hour. Additionally, it supports readable secondary replicas, allowing read-only workloads to be offloaded to the secondary database during normal operations, meeting all stated requirements.

Answer

Point-in-time restore

Answer

Long-term backup retention

Answer

Always On availability groups (self-managed)

Question 11

Drag and drop the steps to configure an Azure Application Gateway with end-to-end TLS encryption into the correct order.

Accepted Answer

Step 1: Obtain a TLS/SSL certificate. Step 2: Upload the certificate to the Application Gateway. Step 3: Configure the backend pool. Step 4: Create backend HTTP settings with HTTPS and upload the backend certificate (if required). Step 5: Create a routing rule.. First, have the certificate. Upload it, configure the backend, set up HTTP settings with TLS, then create the rule.

Answer

Step 1: Upload the certificate to the Application Gateway. Step 2: Obtain a TLS/SSL certificate. Step 3: Configure the backend pool. Step 4: Create backend HTTP settings with HTTPS and upload the backend certificate. Step 5: Create a routing rule.

Answer

Step 1: Obtain a TLS/SSL certificate. Step 2: Configure the backend pool. Step 3: Upload the certificate to the Application Gateway. Step 4: Create backend HTTP settings with HTTPS and upload the backend certificate. Step 5: Create a routing rule.

Answer

Step 1: Obtain a TLS/SSL certificate. Step 2: Upload the certificate to the Application Gateway. Step 3: Create backend HTTP settings with HTTPS and upload the backend certificate. Step 4: Configure the backend pool. Step 5: Create a routing rule.

Question 12

A company uses Azure Backup to protect on-premises Windows servers. The backup data is stored in a Recovery Services vault. They want to ensure that backup data is protected even if the entire Azure region fails. What should they configure?

Accepted Answer

Enable Cross-region restore (CRR) for the Recovery Services vault.. Cross-region restore (CRR) is the correct feature to protect backup data against an entire Azure region failure. When enabled on a Recovery Services vault with geo-redundant storage (GRS), CRR allows you to restore backup data to a paired secondary Azure region even if the primary region is unavailable. This ensures business continuity by providing a secondary restore point in a different region.

Answer

Configure backup replication across two Recovery Services vaults in different regions.

Answer

Enable geo-redundant storage (GRS) for the Recovery Services vault.

Answer

Use zone-redundant storage (ZRS) for the Recovery Services vault.

Question 13

You are reviewing a PowerShell script for Azure SQL Database. The exhibit shows the script that sets backup retention. What is the effect of running this script?

Accepted Answer

It sets the short-term backup retention to 7 days, enabling point-in-time restore within that period.. The script uses the `Set-AzSqlDatabaseBackupShortTermRetentionPolicy` cmdlet with `-RetentionDays 7`, which configures the short-term backup retention period for point-in-time restore (PITR) to 7 days. This allows restoring the database to any point within the last 7 days, as automated backups are retained for that duration.

Answer

It enables geo-redundant backups for the database.

Answer

It sets the long-term retention (LTR) backup policy to 7 days.

Answer

It increases the backup retention from 7 to 35 days.

Question 14

Refer to the exhibit. An administrator configured Azure Site Recovery for a VM. The replication is ongoing but the health shows a warning. What is the most likely cause?

Accepted Answer

The Azure Site Recovery service does not have sufficient permissions to access the source VM or storage account.. Error code 0x80070005 indicates an access denied error, meaning the Azure Site Recovery service does not have sufficient permissions to access the source VM or storage account. Option A is wrong because the recovery point retention is set to 1440 minutes (24 hours), not 5 days. Option B is wrong because the provisioning state is Succeeded, so there is no provisioning failure. Option D is wrong because the replication frequency is set to 300 seconds, which means a 5-minute RPO, not 15 minutes.

Answer

The recovery point retention is set to 5 days, causing storage issues.

Answer

The replication provisioning state failed.

Answer

The replication interval is set to 15 minutes, exceeding the required RPO.

Question 15

Refer to the exhibit. An administrator runs the PowerShell script to enable replication for a VM. The script fails with an error that the VM is not found. What is the most likely cause?

Accepted Answer

The Azure PowerShell context is not set to the subscription that contains the VM.. The PowerShell script uses `Get-AzRecoveryServicesBackupItem` and `Enable-AzRecoveryServicesBackupProtection` to enable replication for a VM. If the Azure PowerShell context (set via `Set-AzContext` or `Connect-AzAccount`) is not targeting the subscription containing the VM, the cmdlets will not find the VM resource, resulting in a 'VM not found' error. This is the most likely cause because the script otherwise references a valid vault, container, and policy.

Answer

The Recovery Services vault does not exist.

Answer

The protection container is not available.

Answer

The replication policy is not valid.