An organization is planning to migrate two on-premises SQL Server workloads to Azure. You need to design a relational database solution that minimizes administrative overhead. The workloads have the following requirements:
* Workload 1: Requires SQL Server Agent to run scheduled jobs, uses CLR features, and requires cross-database queries.
* Workload 2: Has highly unpredictable traffic with long periods of inactivity. It requires automatic scaling of compute resources based on demand.
Which two Azure SQL options should you recommend to support these workloads? (Select two.)
- Azure SQL Managed Instance for Workload 1Answer
- Azure SQL Database (Serverless) for Workload 2Answer
- CAzure SQL Database (Elastic Pool) for Workload 1
- DSQL Server on Azure Virtual Machines for Workload 1
Answer
Azure SQL Managed Instance for Workload 1 and Azure SQL Database (Serverless) for Workload 2
The correct options are the ones recommending Azure SQL Managed Instance for Workload 1 and Azure SQL Database (Serverless) for Workload 2. Azure SQL Managed Instance is a PaaS database service that supports instance-level features like SQL Server Agent and native cross-database queries, which are required for Workload 1. Azure SQL Database (Serverless) automatically scales compute based on workload demand and pauses the database during inactive periods, matching the requirements of Workload 2 while minimizing administrative overhead and cost.
Step-by-Step Solution
Key Concept
Selecting the appropriate Azure SQL deployment option and tier based on feature compatibility (SQL Agent, CLR, cross-db queries), scaling needs, and administrative overhead constraints.
Estimated Time:1m 30s