Which technology is commonly used to configure high availability for SQL Server on Azure VMs?

Azure SQL Database auto-failover groups

A company runs a global application that stores JSON documents in Azure Cosmos DB. The application must be able to read and write from multiple regions and remain available if one region fails. The solution must provide automatic failover and a defined consistency level. What should you configure?

Use Azure Table Storage with geo-redundant storage

Enable multi-region writes and configure automatic failover with a consistency level of session

Use Azure Cache for Redis with geo-replication

Enable single-region writes with a manual failover

What is the purpose of active geo-replication in Azure SQL Database?

To create a readable secondary database in another region for disaster recovery

To create a read-only copy in the same region for load balancing

To automatically fail over to a secondary database without manual intervention

What is the primary function of Azure Load Balancer?

To distribute incoming network traffic across multiple virtual machines

To protect virtual machines from hardware failures

To provide DNS-based routing to different Azure regions

To automatically scale virtual machines based on CPU usage

What is the primary purpose of an Azure Availability Set?

To provide a private IP address for each virtual machine

To distribute virtual machines across multiple Azure regions

To protect virtual machines from datacenter failures by placing them in different fault domains

To automatically scale virtual machines based on CPU usage

Azure Solutions Architect Expert

Domain 3Objective 2

Design for High Availability AZ-305 Practice Questions (Page 4)

Part of the Design business continuity solutions domain, which makes up ~13% of our current practice bank. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~7–10 in this domain), expect 4–5 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

11concepts

Questions 16–20

16foundation · easy
Which technology is commonly used to configure high availability for SQL Server on Azure VMs?
Select an answer first
17application · medium
A company runs a global application that stores JSON documents in Azure Cosmos DB. The application must be able to read and write from multiple regions and remain available if one region fails. The solution must provide automatic failover and a defined consistency level. What should you configure?
Select an answer first
18foundation · easy
What is the purpose of active geo-replication in Azure SQL Database?
Select an answer first
19foundation · easy
What is the primary function of Azure Load Balancer?
Select an answer first
20foundation · easy
What is the primary purpose of an Azure Availability Set?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to AZ-305

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “AZ-305” is a trademark of its owner, used for identification only.