Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 73 discussion

Actual exam question from Microsoft's AZ-305

Question #: 73
Topic #: 4

You need to design a highly available Azure SQL database that meets the following requirements:

• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.

Which deployment option should you use?

A. Azure SQL Database Business Critical
B. Azure SQL Managed Instance Business Critical
C. Azure SQL Database Standard
D. Azure SQL Managed Instance General Purpose

Show Suggested Answer

Suggested Answer: A 🗳️

by ServerBrain at Jan. 5, 2023, 3:59 p.m.

Comments

Submit Cancel

[Removed]

7 months, 3 weeks ago

Selected Answer: A

A is correct

upvoted 2 times

...

Lazylinux

1 year, 2 months ago

Selected Answer: A

A is correct Business Critical (Highest availability and performance): Offers business applications the highest resilience to failures by using several high availability secondary replicas, and provides the highest I/O performance. The Business Critical service tier is designed for applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), faster recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database. Availability => Three replicas, one read-scale replica and zone-redundant high availability (HA)

upvoted 2 times

...

OrangeSG

1 year, 8 months ago

Selected Answer: A

C is wrong option because Azure SQL Database Standard do not have Zone-redundant availability. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability Zone-redundant availability is available to databases in the General Purpose, Premium, Business Critical and Hyperscale service tiers of the vCore purchasing model, and not the Basic and Standard service tiers of the DTU-based purchasing model. Zone-redundant availability ensures Recovery Point Objective (RPO) which indicates the amount of data loss is zero.

upvoted 2 times

...

zellck

2 years, 4 months ago

Same as Question 84. https://www.examtopics.com/discussions/microsoft/view/99751-exam-az-305-topic-4-question-84-discussion

upvoted 3 times

...

zellck

2 years, 4 months ago

Selected Answer: A

A is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Business Critical service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.

upvoted 4 times

zellck

2 years, 4 months ago

https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-zone-redundant-availability By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone-redundant configuration in the Premium or Business Critical service tiers doesn't create additional database redundancy, you can enable it at no extra cost. By selecting a zone-redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic.

upvoted 2 times

...

CloudK

2 years, 4 months ago

Selected Answer: A

From: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is currently in preview for SQL Managed Instance, and ONLY available for the Business Critical service tier. I think that for a production service it is correct to use a service that is not in preview, so the correct answer should be "A"

upvoted 1 times

...

Mangocurry

2 years, 4 months ago

Selected Answer: C

I think this should be C, General Purpose with ZRS.

upvoted 2 times

Mangocurry

2 years, 4 months ago

Actually this is wrong. Standard falls under DTU based purchasing model and does not support ZRS. Standard != General Purpose

upvoted 3 times

...

zellck

2 years, 4 months ago

Azure SQL DB Standard tier only supports LRS. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#basic-standard-and-general-purpose-service-tier-locally-redundant-availability

upvoted 1 times

...

clueless888

2 years, 5 months ago

From what I heave read GeneralPurpose(aka Standard) supports ZRS There are three architectural models that are used in Azure SQL Database: • General Purpose/Standard • Business Critical/Premium • Hyperscale https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 4 times

Lu5ck

2 years, 4 months ago

MI GP does but not available world wide yet thus the safest choice is as stated.

upvoted 1 times

...

yeanlingmedal71

2 years, 5 months ago

Selected Answer: A

Duplicate

upvoted 2 times

...

RandomNickname

2 years, 5 months ago

Selected Answer: A

For no data-loss and as per mVic A is correct.

upvoted 1 times

...

mVic

2 years, 5 months ago

Selected Answer: A

for these questions where zone-redundancy is required, there are only these options: -General Purpose -Premium -Business Critical https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 2 times

...

ServerBrain

2 years, 5 months ago

Selected Answer: A

Correct, In the absence of Azure SQL Database Premium

upvoted 2 times

...