Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning to migrate two relational database workloads to Azure. The workloads have the following requirements:

* Workload 1: A legacy database that relies on SQL Server Agent jobs, cross-database queries, and Common Language Runtime (CLR). The database administrators want to eliminate OS-level maintenance and automated backup infrastructure management.
* Workload 2: A new application database with highly variable, unpredictable read/write traffic that must automatically pause compute billing during inactive periods to minimize costs.

Which two Azure SQL options should you recommend? (Select two.)

  1. Azure SQL Managed Instance for Workload 1Answer
  2. Azure SQL Database (Serverless tier) for Workload 2Answer
  3. C
    Azure SQL Database (single database) for Workload 1
  4. D
    SQL Server on Azure Virtual Machines for Workload 2

Answer

Azure SQL Managed Instance for Workload 1 and Azure SQL Database (Serverless tier) for Workload 2
Azure SQL Managed Instance provides the instance-level capabilities (SQL Server Agent, cross-database queries, and CLR) required for Workload 1 without the administrative overhead of VM management. Azure SQL Database Serverless automatically scales and pauses compute during idle times, meeting the requirements of Workload 2.

Step-by-Step Solution

1
Evaluate legacy database compatibility and operational requirements for Workload 1.
The workload requires SQL Server Agent, cross-database queries, and CLR, along with zero OS patching and backup management overhead. Azure SQL Managed Instance supports these instance-level features while acting as a fully managed PaaS solution.
Choosing the correct PaaS database tier requires matching compatibility requirements to the features supported by each service level.
2
Evaluate scaling and cost optimization requirements for Workload 2.
The database has highly variable and unpredictable traffic and must pause compute billing when inactive. Azure SQL Database (Serverless tier) automatically scales compute resources and supports an auto-pause behavior that stops billing during idle periods.
Serverless computes optimize resource usage and cost for applications with intermittent, unpredictable usage patterns.
3
Select the correct combination of options.
Recommend Azure SQL Managed Instance for Workload 1 and Azure SQL Database (Serverless tier) for Workload 2.
This combination uniquely satisfies the technical capabilities, operational limits, and cost constraints for both database workloads.

Key Concept

Selecting Azure SQL deployment models and tiers based on application feature compatibility (SQL Agent, CLR, cross-database queries) and cost/scaling requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic