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?
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?
To ensure automatic failover without data loss in the event of a datacenter failure while minimizing costs, Azure SQL Database Standard is the most appropriate choice. This tier supports geo-replication, which allows for a secondary replica that can take over in case the primary datacenter fails. Unlike the Premium tier, the Standard tier is more cost-effective and suitable for applications with moderate usage patterns. Azure SQL Database Basic and serverless options do not provide the necessary features to support automatic failover and thus do not meet the requirements.
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.
Should be D
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
Azure SQL Database Standard supports geo-replication and is a cost-effective option.
A. Geo-replication does not support auto failover and an Availability Group is more expensive.
A is more costly compare to D, so answer is D