A media streaming company is planning to migrate its on-premises backend relational databases to Azure. The migration involves two systems:
* System 1: A legacy content management system that relies on SQL Server Agent for scheduling metadata updates, requires SQL Server Common Language Runtime (CLR) integration, and requires cross-database transactions.
* System 2: An on-demand user analytics database that experiences highly unpredictable traffic spikes but is completely idle during off-peak hours. This database must remain highly available even if an entire Azure Availability Zone within the region experiences an outage.
Which two database configurations should you include in the design to meet these requirements? (Select two.)
- Azure SQL Managed Instance for System 1Cevap
- Azure SQL Database Serverless with zone-redundant configuration for System 2Cevap
- CAzure SQL Database (single database) for System 1
- DAzure SQL Database Serverless with locally redundant storage (LRS) for System 2
- ESQL Server on Azure Virtual Machines with Standard HDD storage for System 1 transaction logs
Cevap
The correct design includes Azure SQL Managed Instance for System 1 and Azure SQL Database Serverless with zone-redundant configuration for System 2.
The correct options are the recommendations for Azure SQL Managed Instance and Azure SQL Database Serverless with zone-redundancy. Azure SQL Managed Instance is designed for migrating on-premises SQL Server instances with minimal changes, supporting instance-level features like SQL Server Agent and CLR. Azure SQL Database Serverless satisfies the requirement to auto-scale and pause during inactive periods to minimize costs, and configuring it with zone-redundancy ensures high availability across zone failures.
Adım Adım Çözüm
Anahtar Kavram
Relational database tier selection and high availability design in Azure.