Microsoft AZ-305 Data High Availability Practice Test

 

Topic 16 focuses on High Availability for Relational and Non-Relational Data for the Microsoft Certified: Azure Solutions Architect Expert certification and the AZ-305 exam, using Microsoft Azure solution-architecture scenarios. For broader exam preparation, review the Microsoft Azure Solutions Architect Expert AZ-305 Exam Dumps page. Each question includes a concise explanation of the correct answer and the technical reason the other choices are incorrect.

Question 1

To maintain application continuity during a regional Cosmos DB outage, which Azure design option should be selected?

1. Azure SQL failover group
2. Azure Cosmos DB automatic failover
3. Azure Managed Redis zone redundancy
4. Azure Storage GZRS

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure Cosmos DB automatic failover can promote another region when the current write region becomes unavailable in supported configurations. It directly meets the requirement to maintain application continuity during a regional Cosmos DB outage.

Incorrect Answers

Answer A is incorrect because Azure SQL failover group is used to design regional SQL continuity with simplified application connection handling; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure Managed Redis zone redundancy is used to reduce cache downtime from a zone failure; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Storage GZRS is used to provide object or file durability against both zone and regional failures; that does not directly satisfy the requirement in this scenario.

 

Question 2

To enable read continuity from the secondary region before a storage failover, which Azure design option should be selected?

1. Azure SQL zone redundancy
2. Azure SQL failover group
3. Azure Managed Redis zone redundancy
4. Read-access geo-zone-redundant storage (RA-GZRS)

Correct Answer: D

 

Correct Answer

Answer D is correct because Read-access geo-zone-redundant storage (RA-GZRS) is designed to enable read continuity from the secondary region before a storage failover. Read-access geo-zone-redundant storage (RA-GZRS) adds read access to the secondary region for GZRS accounts.

Incorrect Answers

Answer A is incorrect because Azure SQL zone redundancy can be useful in Azure architectures, but its primary role is to protect relational databases from a zone failure within a region; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL failover group can be useful in Azure architectures, but its primary role is to design regional SQL continuity with simplified application connection handling; it is not the best match for the stated priority.

Answer C is incorrect because Azure Managed Redis zone redundancy can be useful in Azure architectures, but its primary role is to reduce cache downtime from a zone failure; it is not the best match for the stated priority.

 

Question 3

Which Azure capability adds read access to the secondary region for GZRS accounts?

1. Azure Managed Redis zone redundancy
2. Read-access geo-zone-redundant storage (RA-GZRS)
3. Azure SQL failover group
4. Azure SQL zone redundancy

Correct Answer: B

 

Correct Answer

Answer B is correct because Read-access geo-zone-redundant storage (RA-GZRS) matches the described capability and is intended to enable read continuity from the secondary region before a storage failover.

Incorrect Answers

Answer A is incorrect because Azure Managed Redis zone redundancy is intended to reduce cache downtime from a zone failure, which is a different architectural function.

Answer C is incorrect because Azure SQL failover group is intended to design regional SQL continuity with simplified application connection handling, which is a different architectural function.

Answer D is incorrect because Azure SQL zone redundancy is intended to protect relational databases from a zone failure within a region, which is a different architectural function.

 

Question 4

When considering Azure Cosmos DB multi-region writes, which requirement supports that choice?

1. To support globally distributed applications that require active-active database writes.
2. To maintain application continuity during a regional Cosmos DB outage.
3. To improve availability and latency for globally distributed data workloads.
4. To enable read continuity from the secondary region before a storage failover.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Cosmos DB multi-region writes allows supported Cosmos DB accounts to accept writes in multiple regions.

Incorrect Answers

Answer B is incorrect because that outcome is more directly associated with Azure Cosmos DB automatic failover, not Azure Cosmos DB multi-region writes.

Answer C is incorrect because that outcome is more directly associated with Geo-distributed data architecture, not Azure Cosmos DB multi-region writes.

Answer D is incorrect because that outcome is more directly associated with Read-access geo-zone-redundant storage (RA-GZRS), not Azure Cosmos DB multi-region writes.

 

Question 5

Which Azure capability uses zone redundancy in the primary region and asynchronous replication to a secondary region?

1. Azure Storage GZRS
2. Read-access geo-zone-redundant storage (RA-GZRS)
3. Geo-distributed data architecture
4. Azure SQL active geo-replication

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Storage GZRS matches the described capability and is intended to provide object or file durability against both zone and regional failures.

Incorrect Answers

Answer B is incorrect because Read-access geo-zone-redundant storage (RA-GZRS) is intended to enable read continuity from the secondary region before a storage failover, which is a different architectural function.

Answer C is incorrect because Geo-distributed data architecture is intended to improve availability and latency for globally distributed data workloads, which is a different architectural function.

Answer D is incorrect because Azure SQL active geo-replication is intended to scale reads or implement database-level regional failover, which is a different architectural function.

 

Question 6

A security architect needs to improve availability and latency for globally distributed data workloads. Which Azure service or capability is the best fit?

1. Azure Cosmos DB multi-region writes
2. Azure SQL failover group
3. Geo-distributed data architecture
4. Azure SQL zone redundancy

Correct Answer: C

 

Correct Answer

Answer C is correct because Geo-distributed data architecture places appropriate data replicas near users and uses service-specific replication and consistency controls. It directly meets the requirement to improve availability and latency for globally distributed data workloads.

Incorrect Answers

Answer A is incorrect because Azure Cosmos DB multi-region writes is used to support globally distributed applications that require active-active database writes; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL failover group is used to design regional SQL continuity with simplified application connection handling; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure SQL zone redundancy is used to protect relational databases from a zone failure within a region; that does not directly satisfy the requirement in this scenario.

 

Question 7

To scale reads or implement database-level regional failover, which Azure design option should be selected?

1. Azure Cosmos DB multi-region writes
2. Azure SQL zone redundancy
3. Azure Storage GZRS
4. Azure SQL active geo-replication

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure SQL active geo-replication maintains readable asynchronous secondaries for individual Azure SQL databases. It directly meets the requirement to scale reads or implement database-level regional failover.

Incorrect Answers

Answer A is incorrect because Azure Cosmos DB multi-region writes is used to support globally distributed applications that require active-active database writes; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL zone redundancy is used to protect relational databases from a zone failure within a region; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure Storage GZRS is used to provide object or file durability against both zone and regional failures; that does not directly satisfy the requirement in this scenario.

 

Question 8

For Read-access geo-zone-redundant storage (RA-GZRS), which statement is accurate?

1. Provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.
2. Adds read access to the secondary region for GZRS accounts.
3. Uses replicas across Availability Zones for supported service tiers.
4. Distributes cache nodes across Availability Zones in supported tiers and regions.

Correct Answer: B

 

Correct Answer

Answer B is correct because Read-access geo-zone-redundant storage (RA-GZRS) adds read access to the secondary region for GZRS accounts.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure SQL failover group, whose purpose is to design regional SQL continuity with simplified application connection handling.

Answer C is incorrect because that description belongs to Azure SQL zone redundancy, whose purpose is to protect relational databases from a zone failure within a region.

Answer D is incorrect because that description belongs to Azure Managed Redis zone redundancy, whose purpose is to reduce cache downtime from a zone failure.

 

Question 9

A Cosmos DB account must continue serving its application when its current region becomes unavailable. Which failover capability should the architect consider?

1. Azure SQL failover group
2. Azure Storage GZRS
3. Azure Cosmos DB automatic failover
4. Azure Managed Redis zone redundancy

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Cosmos DB automatic failover is designed to maintain application continuity during a regional Cosmos DB outage. Azure Cosmos DB automatic failover can promote another region when the current write region becomes unavailable in supported configurations.

Incorrect Answers

Answer A is incorrect because Azure SQL failover group can be useful in Azure architectures, but its primary role is to design regional SQL continuity with simplified application connection handling; it is not the best match for the stated priority.

Answer B is incorrect because Azure Storage GZRS can be useful in Azure architectures, but its primary role is to provide object or file durability against both zone and regional failures; it is not the best match for the stated priority.

Answer D is incorrect because Azure Managed Redis zone redundancy can be useful in Azure architectures, but its primary role is to reduce cache downtime from a zone failure; it is not the best match for the stated priority.

 

Question 10

Which Azure capability distributes cache nodes across Availability Zones in supported tiers and regions?

1. Azure Managed Redis zone redundancy
2. Azure SQL active geo-replication
3. PostgreSQL Flexible Server zone-redundant HA
4. Geo-distributed data architecture

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Managed Redis zone redundancy matches the described capability and is intended to reduce cache downtime from a zone failure.

Incorrect Answers

Answer B is incorrect because Azure SQL active geo-replication is intended to scale reads or implement database-level regional failover, which is a different architectural function.

Answer C is incorrect because PostgreSQL Flexible Server zone-redundant HA is intended to provide managed PostgreSQL continuity during a zone outage, which is a different architectural function.

Answer D is incorrect because Geo-distributed data architecture is intended to improve availability and latency for globally distributed data workloads, which is a different architectural function.

 

Question 11

To provide object or file durability against both zone and regional failures, which Azure design option should be selected?

1. Read-access geo-zone-redundant storage (RA-GZRS)
2. Azure SQL active geo-replication
3. Azure Storage GZRS
4. Geo-distributed data architecture

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Storage GZRS uses zone redundancy in the primary region and asynchronous replication to a secondary region. It directly meets the requirement to provide object or file durability against both zone and regional failures.

Incorrect Answers

Answer A is incorrect because Read-access geo-zone-redundant storage (RA-GZRS) is used to enable read continuity from the secondary region before a storage failover; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because Azure SQL active geo-replication is used to scale reads or implement database-level regional failover; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Geo-distributed data architecture is used to improve availability and latency for globally distributed data workloads; that does not directly satisfy the requirement in this scenario.

 

Question 12

For Geo-distributed data architecture, which statement is accurate?

1. Allows supported Cosmos DB accounts to accept writes in multiple regions.
2. Places appropriate data replicas near users and uses service-specific replication and consistency controls.
3. Uses replicas across Availability Zones for supported service tiers.
4. Provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.

Correct Answer: B

 

Correct Answer

Answer B is correct because Geo-distributed data architecture places appropriate data replicas near users and uses service-specific replication and consistency controls.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure Cosmos DB multi-region writes, whose purpose is to support globally distributed applications that require active-active database writes.

Answer C is incorrect because that description belongs to Azure SQL zone redundancy, whose purpose is to protect relational databases from a zone failure within a region.

Answer D is incorrect because that description belongs to Azure SQL failover group, whose purpose is to design regional SQL continuity with simplified application connection handling.

 

Question 13

An organization wants to enable read continuity from the secondary region before a storage failover. Which design choice most directly meets the requirement?

1. Azure Managed Redis zone redundancy
2. Read-access geo-zone-redundant storage (RA-GZRS)
3. Azure SQL zone redundancy
4. Azure SQL failover group

Correct Answer: B

 

Correct Answer

Answer B is correct because Read-access geo-zone-redundant storage (RA-GZRS) adds read access to the secondary region for GZRS accounts. It directly meets the requirement to enable read continuity from the secondary region before a storage failover.

Incorrect Answers

Answer A is incorrect because Azure Managed Redis zone redundancy is used to reduce cache downtime from a zone failure; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL zone redundancy is used to protect relational databases from a zone failure within a region; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure SQL failover group is used to design regional SQL continuity with simplified application connection handling; that does not directly satisfy the requirement in this scenario.

 

Question 14

An organization wants to protect relational databases from a zone failure within a region. Which design choice most directly meets the requirement?

1. Azure SQL zone redundancy
2. Azure Cosmos DB automatic failover
3. Read-access geo-zone-redundant storage (RA-GZRS)
4. PostgreSQL Flexible Server zone-redundant HA

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL zone redundancy uses replicas across Availability Zones for supported service tiers. It directly meets the requirement to protect relational databases from a zone failure within a region.

Incorrect Answers

Answer B is incorrect because Azure Cosmos DB automatic failover is used to maintain application continuity during a regional Cosmos DB outage; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Read-access geo-zone-redundant storage (RA-GZRS) is used to enable read continuity from the secondary region before a storage failover; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because PostgreSQL Flexible Server zone-redundant HA is used to provide managed PostgreSQL continuity during a zone outage; that does not directly satisfy the requirement in this scenario.

 

Question 15

Which Azure capability can promote another region when the current write region becomes unavailable in supported configurations?

1. Azure Cosmos DB automatic failover
2. Azure Managed Redis zone redundancy
3. Azure SQL failover group
4. Azure Storage GZRS

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Cosmos DB automatic failover matches the described capability and is intended to maintain application continuity during a regional Cosmos DB outage.

Incorrect Answers

Answer B is incorrect because Azure Managed Redis zone redundancy is intended to reduce cache downtime from a zone failure, which is a different architectural function.

Answer C is incorrect because Azure SQL failover group is intended to design regional SQL continuity with simplified application connection handling, which is a different architectural function.

Answer D is incorrect because Azure Storage GZRS is intended to provide object or file durability against both zone and regional failures, which is a different architectural function.

 

Question 16

Which Azure capability keeps a synchronized standby server in another zone for automatic failover in supported regions?

1. Azure Storage GZRS
2. Azure Managed Redis zone redundancy
3. Azure Cosmos DB multi-region writes
4. PostgreSQL Flexible Server zone-redundant HA

Correct Answer: D

 

Correct Answer

Answer D is correct because PostgreSQL Flexible Server zone-redundant HA matches the described capability and is intended to provide managed PostgreSQL continuity during a zone outage.

Incorrect Answers

Answer A is incorrect because Azure Storage GZRS is intended to provide object or file durability against both zone and regional failures, which is a different architectural function.

Answer B is incorrect because Azure Managed Redis zone redundancy is intended to reduce cache downtime from a zone failure, which is a different architectural function.

Answer C is incorrect because Azure Cosmos DB multi-region writes is intended to support globally distributed applications that require active-active database writes, which is a different architectural function.

 

Question 17

Which Azure capability maintains readable asynchronous secondaries for individual Azure SQL databases?

1. Azure SQL zone redundancy
2. Azure Cosmos DB multi-region writes
3. Azure SQL active geo-replication
4. Azure Storage GZRS

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL active geo-replication matches the described capability and is intended to scale reads or implement database-level regional failover.

Incorrect Answers

Answer A is incorrect because Azure SQL zone redundancy is intended to protect relational databases from a zone failure within a region, which is a different architectural function.

Answer B is incorrect because Azure Cosmos DB multi-region writes is intended to support globally distributed applications that require active-active database writes, which is a different architectural function.

Answer D is incorrect because Azure Storage GZRS is intended to provide object or file durability against both zone and regional failures, which is a different architectural function.

 

Question 18

To design regional SQL continuity with simplified application connection handling, which Azure design option should be selected?

1. Azure SQL active geo-replication
2. Azure Cosmos DB automatic failover
3. Azure SQL failover group
4. PostgreSQL Flexible Server zone-redundant HA

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL failover group is designed to design regional SQL continuity with simplified application connection handling. Azure SQL failover group provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.

Incorrect Answers

Answer A is incorrect because Azure SQL active geo-replication can be useful in Azure architectures, but its primary role is to scale reads or implement database-level regional failover; it is not the best match for the stated priority.

Answer B is incorrect because Azure Cosmos DB automatic failover can be useful in Azure architectures, but its primary role is to maintain application continuity during a regional Cosmos DB outage; it is not the best match for the stated priority.

Answer D is incorrect because PostgreSQL Flexible Server zone-redundant HA can be useful in Azure architectures, but its primary role is to provide managed PostgreSQL continuity during a zone outage; it is not the best match for the stated priority.

 

Question 19

For PostgreSQL Flexible Server zone-redundant HA, which statement is accurate?

1. Uses zone redundancy in the primary region and asynchronous replication to a secondary region.
2. Distributes cache nodes across Availability Zones in supported tiers and regions.
3. Allows supported Cosmos DB accounts to accept writes in multiple regions.
4. Keeps a synchronized standby server in another zone for automatic failover in supported regions.

Correct Answer: D

 

Correct Answer

Answer D is correct because PostgreSQL Flexible Server zone-redundant HA keeps a synchronized standby server in another zone for automatic failover in supported regions.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure Storage GZRS, whose purpose is to provide object or file durability against both zone and regional failures.

Answer B is incorrect because that description belongs to Azure Managed Redis zone redundancy, whose purpose is to reduce cache downtime from a zone failure.

Answer C is incorrect because that description belongs to Azure Cosmos DB multi-region writes, whose purpose is to support globally distributed applications that require active-active database writes.

 

Question 20

For Azure Cosmos DB automatic failover, which statement is accurate?

1. Uses zone redundancy in the primary region and asynchronous replication to a secondary region.
2. Provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.
3. Can promote another region when the current write region becomes unavailable in supported configurations.
4. Distributes cache nodes across Availability Zones in supported tiers and regions.

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Cosmos DB automatic failover can promote another region when the current write region becomes unavailable in supported configurations.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure Storage GZRS, whose purpose is to provide object or file durability against both zone and regional failures.

Answer B is incorrect because that description belongs to Azure SQL failover group, whose purpose is to design regional SQL continuity with simplified application connection handling.

Answer D is incorrect because that description belongs to Azure Managed Redis zone redundancy, whose purpose is to reduce cache downtime from a zone failure.

 

Question 21

For Azure Managed Redis zone redundancy, which statement is accurate?

1. Places appropriate data replicas near users and uses service-specific replication and consistency controls.
2. Maintains readable asynchronous secondaries for individual Azure SQL databases.
3. Distributes cache nodes across Availability Zones in supported tiers and regions.
4. Keeps a synchronized standby server in another zone for automatic failover in supported regions.

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Managed Redis zone redundancy distributes cache nodes across Availability Zones in supported tiers and regions.

Incorrect Answers

Answer A is incorrect because that description belongs to Geo-distributed data architecture, whose purpose is to improve availability and latency for globally distributed data workloads.

Answer B is incorrect because that description belongs to Azure SQL active geo-replication, whose purpose is to scale reads or implement database-level regional failover.

Answer D is incorrect because that description belongs to PostgreSQL Flexible Server zone-redundant HA, whose purpose is to provide managed PostgreSQL continuity during a zone outage.

 

Question 22

A high-availability design places a synchronized PostgreSQL Flexible Server standby in another Availability Zone. Which continuity objective does this arrangement support?

1. To reduce cache downtime from a zone failure.
2. To provide object or file durability against both zone and regional failures.
3. To support globally distributed applications that require active-active database writes.
4. To provide managed PostgreSQL continuity during a zone outage.

Correct Answer: D

 

Correct Answer

Answer D is correct because PostgreSQL Flexible Server zone-redundant HA keeps a synchronized standby server in another zone for automatic failover in supported regions.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure Managed Redis zone redundancy, not PostgreSQL Flexible Server zone-redundant HA.

Answer B is incorrect because that outcome is more directly associated with Azure Storage GZRS, not PostgreSQL Flexible Server zone-redundant HA.

Answer C is incorrect because that outcome is more directly associated with Azure Cosmos DB multi-region writes, not PostgreSQL Flexible Server zone-redundant HA.

 

Question 23

A storage continuity plan uses RA-GZRS. The primary region is unavailable, but the account has not failed over. Which objective is supported by the secondary endpoint?

1. To protect relational databases from a zone failure within a region.
2. To design regional SQL continuity with simplified application connection handling.
3. To reduce cache downtime from a zone failure.
4. To enable read continuity from the secondary region before a storage failover.

Correct Answer: D

 

Correct Answer

Answer D is correct because Read-access geo-zone-redundant storage (RA-GZRS) adds read access to the secondary region for GZRS accounts.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure SQL zone redundancy, not Read-access geo-zone-redundant storage (RA-GZRS).

Answer B is incorrect because that outcome is more directly associated with Azure SQL failover group, not Read-access geo-zone-redundant storage (RA-GZRS).

Answer C is incorrect because that outcome is more directly associated with Azure Managed Redis zone redundancy, not Read-access geo-zone-redundant storage (RA-GZRS).

 

Question 24

To provide managed PostgreSQL continuity during a zone outage, which Azure design option should be selected?

1. Azure Cosmos DB multi-region writes
2. Azure Storage GZRS
3. Azure Managed Redis zone redundancy
4. PostgreSQL Flexible Server zone-redundant HA

Correct Answer: D

 

Correct Answer

Answer D is correct because PostgreSQL Flexible Server zone-redundant HA is designed to provide managed PostgreSQL continuity during a zone outage. PostgreSQL Flexible Server zone-redundant HA keeps a synchronized standby server in another zone for automatic failover in supported regions.

Incorrect Answers

Answer A is incorrect because Azure Cosmos DB multi-region writes can be useful in Azure architectures, but its primary role is to support globally distributed applications that require active-active database writes; it is not the best match for the stated priority.

Answer B is incorrect because Azure Storage GZRS can be useful in Azure architectures, but its primary role is to provide object or file durability against both zone and regional failures; it is not the best match for the stated priority.

Answer C is incorrect because Azure Managed Redis zone redundancy can be useful in Azure architectures, but its primary role is to reduce cache downtime from a zone failure; it is not the best match for the stated priority.

 

Question 25

Which Azure capability places appropriate data replicas near users and uses service-specific replication and consistency controls?

1. Geo-distributed data architecture
2. Azure SQL failover group
3. Azure Cosmos DB multi-region writes
4. Azure SQL zone redundancy

Correct Answer: A

 

Correct Answer

Answer A is correct because Geo-distributed data architecture matches the described capability and is intended to improve availability and latency for globally distributed data workloads.

Incorrect Answers

Answer B is incorrect because Azure SQL failover group is intended to design regional SQL continuity with simplified application connection handling, which is a different architectural function.

Answer C is incorrect because Azure Cosmos DB multi-region writes is intended to support globally distributed applications that require active-active database writes, which is a different architectural function.

Answer D is incorrect because Azure SQL zone redundancy is intended to protect relational databases from a zone failure within a region, which is a different architectural function.

 

Question 26

For Azure SQL active geo-replication, which statement is accurate?

1. Maintains readable asynchronous secondaries for individual Azure SQL databases.
2. Uses replicas across Availability Zones for supported service tiers.
3. Allows supported Cosmos DB accounts to accept writes in multiple regions.
4. Uses zone redundancy in the primary region and asynchronous replication to a secondary region.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL active geo-replication maintains readable asynchronous secondaries for individual Azure SQL databases.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure SQL zone redundancy, whose purpose is to protect relational databases from a zone failure within a region.

Answer C is incorrect because that description belongs to Azure Cosmos DB multi-region writes, whose purpose is to support globally distributed applications that require active-active database writes.

Answer D is incorrect because that description belongs to Azure Storage GZRS, whose purpose is to provide object or file durability against both zone and regional failures.

 

Question 27

For Azure Storage GZRS, which statement is accurate?

1. Adds read access to the secondary region for GZRS accounts.
2. Uses zone redundancy in the primary region and asynchronous replication to a secondary region.
3. Places appropriate data replicas near users and uses service-specific replication and consistency controls.
4. Maintains readable asynchronous secondaries for individual Azure SQL databases.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure Storage GZRS uses zone redundancy in the primary region and asynchronous replication to a secondary region.

Incorrect Answers

Answer A is incorrect because that description belongs to Read-access geo-zone-redundant storage (RA-GZRS), whose purpose is to enable read continuity from the secondary region before a storage failover.

Answer C is incorrect because that description belongs to Geo-distributed data architecture, whose purpose is to improve availability and latency for globally distributed data workloads.

Answer D is incorrect because that description belongs to Azure SQL active geo-replication, whose purpose is to scale reads or implement database-level regional failover.

 

Question 28

A multi-database application needs stable listener endpoints and managed regional failover for Azure SQL. Which description correctly explains an Azure SQL failover group?

1. Provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.
2. Keeps a synchronized standby server in another zone for automatic failover in supported regions.
3. Maintains readable asynchronous secondaries for individual Azure SQL databases.
4. Can promote another region when the current write region becomes unavailable in supported configurations.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL failover group provides managed multi-region failover and stable listener endpoints for Azure SQL databases or managed instances in supported configurations.

Incorrect Answers

Answer B is incorrect because that description belongs to PostgreSQL Flexible Server zone-redundant HA, whose purpose is to provide managed PostgreSQL continuity during a zone outage.

Answer C is incorrect because that description belongs to Azure SQL active geo-replication, whose purpose is to scale reads or implement database-level regional failover.

Answer D is incorrect because that description belongs to Azure Cosmos DB automatic failover, whose purpose is to maintain application continuity during a regional Cosmos DB outage.

 

Question 29

An Azure SQL design includes active geo-replication. Which requirement would justify its readable secondary databases or database-level regional failover capability?

1. To provide object or file durability against both zone and regional failures.
2. To scale reads or implement database-level regional failover.
3. To protect relational databases from a zone failure within a region.
4. To support globally distributed applications that require active-active database writes.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL active geo-replication maintains readable asynchronous secondaries for individual Azure SQL databases.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure Storage GZRS, not Azure SQL active geo-replication.

Answer C is incorrect because that outcome is more directly associated with Azure SQL zone redundancy, not Azure SQL active geo-replication.

Answer D is incorrect because that outcome is more directly associated with Azure Cosmos DB multi-region writes, not Azure SQL active geo-replication.

 

Question 30

When considering Azure SQL zone redundancy, which requirement supports that choice?

1. To provide managed PostgreSQL continuity during a zone outage.
2. To protect relational databases from a zone failure within a region.
3. To enable read continuity from the secondary region before a storage failover.
4. To maintain application continuity during a regional Cosmos DB outage.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL zone redundancy uses replicas across Availability Zones for supported service tiers.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with PostgreSQL Flexible Server zone-redundant HA, not Azure SQL zone redundancy.

Answer C is incorrect because that outcome is more directly associated with Read-access geo-zone-redundant storage (RA-GZRS), not Azure SQL zone redundancy.

Answer D is incorrect because that outcome is more directly associated with Azure Cosmos DB automatic failover, not Azure SQL zone redundancy.