CCNA Plan and configure a high availability and disaster recovery environment Questions — Page 3 of 3

151

MCQeasy

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?

A.It maintains multiple synchronous replicas in different availability zones within the region.

B.It creates read-only replicas in other zones that can be promoted to primary.

C.It replicates data to a secondary region for failover.

D.It uses asynchronous replication to a standby replica in another zone.

AnswerA

Zone redundancy uses synchronous replicas across zones for automatic failover.

Why this answer

Zone redundancy for Azure SQL Database Business Critical tier maintains multiple synchronous replicas in different availability zones within the same region. If one zone fails, another replica automatically becomes the primary, ensuring minimal downtime. Option B is incorrect because read-only replicas are not promoted to primary; all replicas are read/write capable and failover is automatic.

Option C is incorrect as it describes geo-replication to a secondary region, not zone redundancy. Option D is incorrect because replicas are kept synchronous, not asynchronous.

Practice this question →

152

Multi-Selectmedium

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

Select 3 answers

A.The replication mode is 'async' (asynchronous) with a low RPO target.

B.The seed type is set to 'automatic' to ensure continuous replication.

C.The secondary database is in a paired region with low network latency.

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

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

AnswersA, B, C

Async replication is standard; RPO is typically below 5 seconds.

Why this answer

Options A, B, and C are correct. Option A is correct because active geo-replication uses asynchronous replication with a configurable RPO; a low RPO target minimizes potential data loss. Option B is correct because automatic seed type ensures continuous synchronization of the secondary database.

Option C is correct because locating the secondary in a paired region with low network latency reduces replication lag, thereby minimizing data loss. Option D is wrong because making the secondary readable does not affect data loss; it is designed for read-scale workloads. Option E is wrong because the failover group name does not influence data loss; a forced failover policy would actually cause data loss.

Practice this question →

153

MCQhard

You are using Azure SQL Managed Instance with auto-failover groups. The primary region is East US, secondary is West US. The primary region experiences a full outage. How does the failover group behave?

A.The failover group automatically fails over to West US and the read-write endpoint now points to West US.

B.You must manually initiate failover via the portal.

C.The read-only listener continues to point to West US.

D.The failover group remains in primary region and does not fail over.

AnswerA

Automatic failover switches endpoints.

Why this answer

Auto-failover groups automatically fail over to the secondary region with automatic read-write endpoint switch. Option B is incorrect because automatic failover does not require manual initiation; it occurs after the grace period. Option C is incorrect because the read-only listener is also updated to point to the new secondary (formerly primary) after failover.

Option D is incorrect because the failover group will fail over automatically, not remain in the primary region.

Practice this question →

154

MCQeasy

You are planning a disaster recovery strategy for an Azure SQL Database that supports a critical application. The database is 500 GB in size and you need to recover it within 1 hour (RTO) with a maximum data loss of 5 minutes (RPO). Which Azure SQL Database feature should you use?

A.Long-term retention (LTR) backups.

B.Point-in-time restore (PITR) with geo-redundant backup storage.

C.Auto-failover group with a secondary in a different region.

D.Active geo-replication to a secondary server in a paired region.

AnswerD

Active geo-replication offers low RPO (seconds to minutes) and fast failover, meeting the requirements.

Why this answer

Active geo-replication provides asynchronous replication with an RPO of a few seconds to a few minutes, and failover can be initiated manually within minutes, meeting the RTO and RPO. Option A is wrong because point-in-time restore does not provide a separate secondary region. Option B is wrong because long-term retention is for archival, not DR.

Option C is wrong because failover groups use geo-replication but the RPO is still asynchronous; the question asks for the feature, and geo-replication is the core.

Practice this question →

155

MCQmedium

You need to ensure high availability for an Azure SQL Database in the Business Critical service tier. Which feature provides the fastest failover within the same region?

A.Built-in Always On availability groups

B.Zone-redundant configuration

C.Read scale-out

D.Active geo-replication

AnswerA

Provides synchronous replication and automatic failover.

Why this answer

The Business Critical service tier uses Always On availability groups with synchronous replication, providing automatic and fast failover within the same region. Option B (Zone-redundant configuration) adds zone resilience but does not provide faster failover within a zone. Option C (Read scale-out) is for read-only workloads and does not provide failover.

Option D (Active geo-replication) is for cross-region failover and has a higher RTO.

Practice this question →

156

Multi-Selectmedium

You are designing high availability for a critical Azure SQL Database. The database is 1 TB in size and requires an RPO of 0 (zero data loss) and an RTO of less than 30 seconds. Which TWO configurations can meet these requirements?

Select 2 answers

A.Business Critical service tier with zone redundancy enabled.

B.Auto-failover group with a secondary in the same region.

C.Hyperscale service tier with zone redundancy enabled.

D.General Purpose service tier with zone redundancy enabled.

E.Active geo-replication to a secondary in a different region.

AnswersA, C

Business Critical with zone redundancy uses three synchronous replicas across zones, ensuring zero data loss and fast failover.

Why this answer

Options A and C are correct. For zero data loss (RPO=0), synchronous replication is required. Business Critical (option A) with zone redundancy provides synchronous replicas within the same region and automatic failover, meeting both RPO=0 and RTO<30 seconds.

Hyperscale (option C) also offers zone redundancy with synchronous log replication, enabling rapid failover without data loss. Option B (auto-failover group with same-region secondary) uses asynchronous replication, so data loss can occur. Option D (General Purpose) uses asynchronous replication as well and cannot guarantee zero data loss.

Option E (active geo-replication) is also asynchronous, so it does not meet the RPO requirement.

Practice this question →

157

Multi-Selecteasy

Which TWO are benefits of using a failover group for Azure SQL Database? (Select two.)

Select 2 answers

A.Allows the secondary database to be readable for reporting

B.Enables transparent data encryption (TDE) across regions

C.Provides a single read/write listener endpoint for the primary database

D.Automatically balances read queries between primary and secondary

E.Supports synchronous replication between primary and secondary

AnswersA, C

You can configure the secondary to be readable.

Why this answer

Failover groups in Azure SQL Database provide a single read/write listener endpoint for the primary database (option C) and allow the secondary database to be readable for reporting purposes (option A). Option B is incorrect because Transparent Data Encryption (TDE) is not a feature of failover groups; TDE can be configured independently. Option D is incorrect because failover groups do not automatically balance read queries; for read scaling, you would use a read-scale replica.

Option E is incorrect because failover groups use asynchronous replication, not synchronous.

Practice this question →

158

Multi-Selectmedium

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

Select 2 answers

A.Active geo-replication

B.Geo-restore

C.Failover group

D.Manual failover

E.Log shipping

AnswersC, D

Failover groups provide automatic failover and readable secondary.

Why this answer

Options C and D are correct. Failover groups provide automatic failover to a secondary region, support readable secondary workloads, and allow manual failback by initiating a failover in the opposite direction. Option A (Active geo-replication) is not supported for Azure SQL Managed Instance.

Option B (Geo-restore) does not provide automatic failover. Option E (Log shipping) is not built-in for managed instances and does not meet the requirements.

Practice this question →

159

MCQeasy

You are designing a high availability solution for a mission-critical Azure SQL Database. The database must have an uptime SLA of 99.995% and automatically recover from zone-level failures without data loss. Which service tier and redundancy option should you choose?

A.Basic tier with zone redundancy

B.General Purpose tier with zone redundancy

C.Hyperscale tier with zone redundancy

D.Business Critical tier with zone redundancy

AnswerD

Business Critical with zone redundancy provides 99.995% SLA and automatic zone failure recovery.

Why this answer

The Business Critical tier with zone redundancy provides an SLA of 99.995% and automatic recovery from zone-level failures without data loss. The Basic tier does not support zone redundancy. The General Purpose tier with zone redundancy offers a 99.99% SLA.

The Hyperscale tier with zone redundancy offers a 99.95% SLA for zone-redundant configurations. Therefore, only the Business Critical tier meets the 99.995% uptime requirement with zone redundancy.

Practice this question →

160

MCQeasy

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?

A.The database is taken offline during patching and restored afterward.

B.You must manually fail over to a secondary database to avoid downtime.

C.Zone-redundant replicas that ensure zero downtime.

D.Automated failover to a built-in standby replica with minimal downtime.

AnswerD

General Purpose tier uses a built-in standby replica for high availability during patching.

Why this answer

The General Purpose tier includes built-in high availability with automated failover to a standby replica during planned patching events, minimizing downtime. Option A is incorrect because the database is not taken offline; it fails over seamlessly. Option B is incorrect because manual failover is not required—the process is automatic.

Option C is incorrect because General Purpose does not provide zone-redundant replicas by default; that is a feature of the Business Critical or Hyperscale tiers.

Practice this question →

161

MCQhard

You administer a SQL Managed Instance in the West Europe region. You need to create a disaster recovery replica in North Europe with automated failover. The replica must be readable and support backups. What should you configure?

A.Set up log shipping from West Europe to North Europe.

B.Configure active geo-replication between the instances.

C.Create a failover group, but note the secondary is not readable.

D.Create a failover group with the secondary instance in North Europe.

AnswerD

Failover groups provide automated failover and readable secondary for Managed Instance.

Why this answer

SQL Managed Instance supports failover groups for automated failover between regions, and the secondary instance in a failover group is readable and supports backups. Option A is incorrect because log shipping is not supported for SQL Managed Instance. Option B is incorrect because active geo-replication is not supported for SQL Managed Instance; failover groups are the appropriate solution.

Option C is incorrect because the secondary instance in a failover group is readable and can be used for read-only workloads.

Practice this question →