exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 107 discussion

Actual exam question from Microsoft's AZ-305
Question #: 107
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 Business Critical
  • B. Azure SQL Database Hyperscale
  • C. Azure SQL Managed Instance Business Critical
  • D. Azure SQL Database Standard
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
InvalidNickname
Highly Voted 1 year, 4 months ago
Choice should be : 1) SQL DB Premium 2) SQL DB Serverless 3) SQL DB Business Critical
upvoted 12 times
AndPorks
11 months, 4 weeks ago
Exatamente
upvoted 2 times
...
ssmit
11 months, 3 weeks ago
You got 2 business critial. The SQL DB is a cheaper version and require less administration then the SQL Manged Instance.
upvoted 1 times
...
...
kpcert
Most Recent 2 months, 1 week ago
Selected Answer: A
A. Azure SQL Database Business Critical
upvoted 1 times
...
LGWJ12
8 months ago
Selected Answer: A
1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical Premium < Serverless < Business Critical < HyperScale
upvoted 1 times
...
katonab
8 months, 1 week ago
Selected Answer: A
Correct: A. SQL DB Business Critical yepp, not the first question of sort...
upvoted 1 times
...
ziggy1117
11 months, 4 weeks ago
Choice should be : 1) SQL DB Premium 2) SQL DB Serverless / General Purpose 3) SQL DB Business Critical
upvoted 2 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
Loading ...