A legal services firm is deploying a new application on Azure that uses a relational database. The design must accommodate the following requirements:
- The database must support cross-database queries and SQL Server Agent.
- The database must be highly available and resilient to zone outages.
- Administrative effort for managing the underlying operating system must be eliminated.
Which relational database solution and configuration should you recommend?
- AAzure SQL Database single database configured with zone-redundant storage
- BSQL Server on Azure Virtual Machines configured with zone-redundant storage
- Azure SQL Database Managed Instance configured with zone-redundant storageAnswer
- DAzure SQL Database Managed Instance configured with locally redundant storage
Answer
Azure SQL Database Managed Instance configured with zone-redundant storage
The correct option is Azure SQL Database Managed Instance configured with zone-redundant storage because it supports instance-level features such as SQL Server Agent and cross-database queries, requires no operating system management, and is resilient to availability zone failures through zone-redundant replication.
Step-by-Step Solution
Key Concept
Azure SQL relational deployment selection based on legacy compatibility features, high availability, and operational overhead boundaries.
Estimated Time:2m 0s