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
automatic failover without data loss if a datacenter fails - supported by Standard, Premium and Business critical so based on minimum price Standard should consider.
A - Business Critical - This pricing tier includes built-in high availability with zone-redundant replicas (if configured) and can support automatic failover within the region, which helps meet the requirement for automatic failover without data loss.
Business Critical is optimized for mission-critical workloads, offering both high availability and minimal data loss while providing strong performance.
This one is tough. While standard may seem like the obvious choice given the requirements, I feel that the question implies a level of urgency as far as being able to auto failover with no data loss. My gut says A, despite it costing more than standard.
Or you could just lookup the documentation...and find out the answer is indeed A:
https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-locally-redundant-availability
Standard tier doesn't have any replicas, so the automatic failover is impossible.
You need to choose BusinessCritical (vCore) or Premium (DTU) tier
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
TheMCT
Highly Voted 2 years, 3 months agoc80f499
Most Recent 5 months, 1 week agoPavan_Gupta
6 months, 4 weeks agobingomutant
8 months, 2 weeks agoigorclapa
1 year, 9 months agoDalamain
1 year, 2 months agoU_C
2 years, 2 months agosca88
1 year, 2 months ago