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?
in Standard (D) you can use geo-replication or failover groups. In both cases replication is ASYNCHRONOUS, which means data loss is possible.
Premium (A) has zone-redundancy with synchronous replication between zones. No Data loss if one zone (data center) is suddenly down.
'A' minimizes data loss during failover. 'D' on the other hand Failover times are generally longer due to the time required to promote a secondary replica
Min is Premium with Zone redundancy for protection against data center failures.
Geo-replication is available for all tiers but with possible data loss. So I think A.
Question repeated 3 times with different answers. Correct answer Premium or Business critical.
https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-locally-redundant-availability
Standard doesn't support geo-replication
https://azure.microsoft.com/en-us/updates/general-availability-sql-database-basic-standard-and-premium-service-tiers/
No need of Geo-replication as the question is about just a datacenter outage not a zone-outage.
In Standard put the DB into an Availability Group. More administrative effort but cheaper solution
I vote for D
Correct answer is D:
o minimize costs, you can choose the Standard pricing tier for both the primary and secondary replicas. This tier provides geo-replication support for a single secondary replica and is designed for applications with moderate usage patterns.
Yes, the answer is D:
Option A: Azure SQL Database Premium supports geo-replication but is the most expensive pricing tier.
Option B: Azure SQL Database serverless is a cost-effective option but does not support geo-replication.
Option C: Azure SQL Database Basic does not support geo-replication.
Option D: Azure SQL Database Standard supports geo-replication and is a cost-effective option.
Therefore, the recommended deployment option and pricing tier for this scenario is Azure SQL Database Standard.
upvoted 5 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.
voodoo_sh
5 months agoOga_DBA
7 months agobingomutant
8 months, 2 weeks ago2f5c7cd
8 months, 2 weeks agoecocloudformacion1
8 months, 2 weeks agosca88
1 year, 2 months agoBen999
1 year, 2 months agoSr18
12 months agojddc
1 year, 8 months agoacsoma
1 year, 8 months agolupdba
1 year, 10 months agoTheMCT
2 years, 3 months agoU_C
2 years, 2 months ago