ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 4 question 100 discussion

Actual exam question from Microsoft's AZ-305
Question #: 100
Topic #: 4
[All AZ-305 Questions]

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 Standard
  • B. Azure SQL Managed Instance General Purpose
  • C. Azure SQL Database Serverless
  • D. Azure SQL Database Premium
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by P8r at April 19, 2023, 4:19 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
P8r
Highly Voted 2 years ago
Selected Answer: D
In order of preference: Premium > Serverless > Business Critical
upvoted 28 times
reddyreddy
1 year, 7 months ago
thank u
upvoted 1 times
...
...
eoicp
Highly Voted 1 year, 11 months ago
I think it's serverless. Servers the requirement AT less cost
upvoted 6 times
...
moadabdou
Most Recent 9 months, 4 weeks ago
Selected Answer: D
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
upvoted 2 times
...
techtest848
1 year, 2 months ago
Selected Answer: C
I believe the order or preference for this question is Serverless, Premium and Business Critical (from least expensive to Most expensive)
upvoted 2 times
...
joesatriani
1 year, 7 months ago
Selected Answer: D
1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 1 times
...
pxo1000
2 years ago
Selected Answer: C
Please explain how Premium is a better answer here than serverless? If serverless supports zone availability, it can failover without any data loss
upvoted 6 times
resser19
1 year, 11 months ago
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.
upvoted 1 times
resser19
1 year, 11 months ago
This response from Google Bard.
upvoted 1 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago