Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning a new deployment of a relational database for a corporate application. The database solution must satisfy the following requirements:
* Support the execution of SQL Server Agent jobs and native cross-database queries.
* Provide a fully managed platform to minimize administrative overhead for operating system and database patching.
* Guarantee that in the event of a regional outage, database failover to a secondary region is automated with a single connection endpoint.

Which database solution and configuration should the company select?

  1. A
    Azure SQL Database single database configured with active geo-replication
  2. B
    SQL Server on Azure Virtual Machines configured with an Always On availability group
  3. Azure SQL Database Managed Instance configured with an auto-failover groupAnswer
  4. D
    Azure SQL Database Managed Instance configured with active geo-replication

Answer

Azure SQL Database Managed Instance configured with an auto-failover group
The correct solution uses Azure SQL Database Managed Instance configured with an auto-failover group. Managed Instance is a fully managed service that supports SQL Server Agent and cross-database queries. Auto-failover groups enable automatic failover to a secondary region and provide a single read-write listener endpoint.

Step-by-Step Solution

1
Analyze database feature requirements
Azure SQL Database Managed Instance and SQL Server on Azure VMs support SQL Server Agent and cross-database queries, while Azure SQL Database single database does not.
To narrow down candidate services based on features.
2
Analyze administrative overhead requirements
Azure SQL Database Managed Instance is a fully managed PaaS solution, whereas SQL Server on Azure VMs is IaaS and requires manual patching.
To satisfy the requirement of minimizing administrative patching overhead.
3
Analyze high availability and disaster recovery requirements
Auto-failover groups provide automatic failover and a single listener endpoint, whereas active geo-replication requires manual failover.
To satisfy the requirement of automatic failover with a single connection endpoint.

Key Concept

Relational database service selection and high availability design in Azure
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic