DP-300 Question #368: Real Exam Question with Answer & Explanation

Question

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?

Options

• AAzure SQL Database Premium
• BAzure SQL Database serverless
• CAzure SQL Database managed instance General Purpose
• DAzure SQL Database Hyperscale

Explanation

To enable automatic failover without data loss and minimize costs for an Azure SQL Database, the Premium tier is the most suitable option.

Common mistakes.

• B. Azure SQL Database serverless is a compute tier primarily focused on cost optimization for intermittent workloads by pausing and resuming, not inherently guaranteeing automatic failover without data loss across datacenters for high availability.
• C. Azure SQL Database managed instance General Purpose tier offers a separate deployment model with a lower cost and single replica for high availability, which may incur some data loss during failover to a new replica if a datacenter fails.
• D. Azure SQL Database Hyperscale is a service tier optimized for very large databases with high scalability and fast restore times, but its primary focus is not automatic datacenter-level failover without data loss as a core HA mechanism, and it can be more expensive than Premium.

Concept tested. Azure SQL Database high availability tiers and cost optimization

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql

No community discussion yet for this question.