exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 6 question 33 discussion

Actual exam question from Microsoft's DP-300
Question #: 33
Topic #: 6
[All DP-300 Questions]

You have an Azure SQL database named DB1.

You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.

Which deployment option and pricing tier should you configure?

  • A. Azure SQL Database Premium
  • B. Azure SQL Database serverless
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Hyperscale
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
bingomutant
6 months, 4 weeks ago
A - The best option for automatic failover without data loss is typically one that supports business continuity features like active geo-replication or auto-failover groups, which require Premium or Business Critical tiers. Among the given options: The correct option would be: A. Azure SQL Database Premium
upvoted 1 times
...
TheMCT
2 years, 1 month ago
Selected Answer: A
Correct answer is A: To ensure automatic failover without data loss if a datacenter fails, you should choose the Business Critical deployment option and the Premium pricing tier for the Azure SQL database named DB1. The Business Critical deployment option provides a 99.995% availability SLA, and the Premium pricing tier includes features such as advanced security, high availability, and business continuity. This option also offers the ability to use a failover group with multiple readable secondary replicas.
upvoted 4 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago