AZ-305 Exam QuestionsBrowse all questions from this exam
Go to Exam

AZ-305 Exam - Question 234

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?

Show Answer
Correct Answer: D

To meet the required conditions of failover without data loss, availability during a zone outage, and cost minimization, Azure SQL Database Premium is the appropriate option. It is designed for high availability with built-in zone-redundant replicas ensuring that the failover process incurs no data loss. Additionally, it offers enhanced performance and reliability which aligns with the requirements specified.

Discussion

6 comments
Sign in to comment
P8rOption: D
Apr 19, 2023

In order of preference: Premium > Serverless > Business Critical

reddyreddy
Sep 19, 2023

thank u

pxo1000Option: C
Apr 29, 2023

Please explain how Premium is a better answer here than serverless? If serverless supports zone availability, it can failover without any data loss

resser19
May 31, 2023

Here are some factors to consider when choosing between Azure Database Serverless and Premium: Database size: If your database is small, Azure Database Serverless is the most cost-effective option. Database usage: If your database is used infrequently, Azure Database Serverless is the most cost-effective option. Database requirements: If your database has specific requirements, such as high availability or disaster recovery, Azure Database Premium may be the best option. Ultimately, the best way to choose between Azure Database Serverless and Premium is to consider your specific needs and requirements.

resser19
May 31, 2023

This response from Google Bard.

eoicpOption: C
May 16, 2023

I think it's serverless. Servers the requirement AT less cost

techtest848Option: C
Feb 19, 2024

I believe the order or preference for this question is Serverless, Premium and Business Critical (from least expensive to Most expensive)

joesatrianiOption: D
Sep 25, 2023

1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

moadabdouOption: D
Jul 13, 2024

There are *16* variations of this question. Each of them offering different possible answers. The answer priority is as follows. If it exists then choose it. If it doesn't, proceeded to the next priority. Sometimes both appear in the same question, so make sure to select the higher priority. 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical