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?
- AAzure SQL Database single database configured with active geo-replication
- BSQL Server on Azure Virtual Machines configured with an Always On availability group
- Azure SQL Database Managed Instance configured with an auto-failover groupCevap
- DAzure SQL Database Managed Instance configured with active geo-replication
Cevap
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.
Adım Adım Çözüm
Anahtar Kavram
Relational database service selection and high availability design in Azure