exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 85 discussion

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

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
Tplenty
Highly Voted 1 year ago
The answer is either Azure SQL Database Premium or Azure SQL Database Business Critical
upvoted 7 times
williamjcg
8 months, 3 weeks ago
Don't forget about Hyperscale haha. Premium - Hyperscale - Business Critical
upvoted 3 times
...
...
SeMo0o0o0o
Most Recent 3 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
c7d45f4
1 year, 2 months ago
Selected Answer: B
the answer is Premium so B
upvoted 1 times
...
lombri
1 year, 7 months ago
Selected Answer: B
In Premium, Business Critical, and Hyperscale service tiers, SQL Database supports the use of read-only replicas to offload read-only query workloads, using the ApplicationIntent=ReadOnly parameter in the connection string. The question to ask for costs must be minimized. So the answer is Premium
upvoted 4 times
...
lombri
1 year, 7 months ago
In Premium, Business Critical, and Hyperscale service tiers, SQL Database supports the use of read-only replicas to offload read-only query workloads, using the ApplicationIntent=ReadOnly parameter in the connection string. The question to ask for costs must be minimized. So the answer is Premium
upvoted 1 times
...
Alessandro365
1 year, 9 months ago
Selected Answer: B
B is the correct answer
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 ...