Have you failed a job interview?
Send us your job interview questions and get correct answers.

You plan to deploy a highly available Azure SQL Database that can failover between replicas without any data loss. The database must remain available when the zone goes down. How will you solve this?

Experience Level: Senior
Tags: Azure CloudAzure SQL Database

Answer

Use Azure SQL Database Business Critical.

Business Critical service tier is designed for applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), fast recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database.
Related Azure Cloud job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
Azure SQL Database
Azure SQL Database

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself