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…

Question

Options

• AAzure SQL Database Premium
• BAzure SQL Database serverless
• CAzure SQL Database managed instance Business Critical
• DAzure SQL Database Standard

• A
  72% (26)
• B
  6% (2)
• C
  17% (6)
• D
  6% (2)

Explanation

By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone redundant configuration in the Premium or Business Critical service tiers does not create additional database redundancy, you can enable it at no extra cost. By selecting a zone redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing Premium or Business Critical databases or pools to the zone redundant configuration. There are several versions of this question with different incorrect answer options. Other incorrect answers you may see on the exam include: - Azure SQL Database Hyperscale - Azure SQL Database Basic - Azure SQL Database managed instance General Purpose https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

No community discussion yet for this question.