Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A retail company plans to migrate two on-premises SQL Server workloads to Azure. The migration requirements are as follows:

* Workload A: Runs an inventory application that requires cross-database queries across three databases and uses SQL Server Agent for automated maintenance tasks. The solution must minimize database administration effort.
* Workload B: Runs a customer feedback application that experiences highly unpredictable traffic patterns, with long periods of inactivity. Compute costs must be minimized during inactive periods, and the data must remain resilient against a local datacenter outage.

Which two Azure SQL options should you recommend?

  1. Azure SQL Managed Instance for Workload AAnswer
  2. Azure SQL Database Serverless for Workload BAnswer
  3. C
    Azure SQL Database single database for Workload A
  4. D
    Azure SQL Database Serverless with Locally Redundant Storage (LRS) for Workload B

Answer

Azure SQL Managed Instance for Workload A and Azure SQL Database Serverless for Workload B
Azure SQL Managed Instance is chosen for Workload A because it natively supports SQL Server Agent and cross-database queries, which are missing from Azure SQL Database single database, and reduces VM patching and management tasks. Azure SQL Database Serverless is chosen for Workload B because it provides an auto-pause feature that saves compute costs during inactive periods, and it can be deployed with zone redundancy to survive a local datacenter outage.

Step-by-Step Solution

1
Evaluate Workload A requirements: SQL Agent, cross-database queries, and minimized administrative effort.
Azure SQL Managed Instance is selected because it natively supports SQL Agent and cross-database queries, unlike Azure SQL Database single database, and has less administrative overhead than SQL Server on Azure VMs.
Managed Instance provides full PaaS benefits with near 100% compatibility with on-premises SQL Server features.
2
Evaluate Workload B requirements: unpredictable traffic, compute cost minimization during inactive periods, and resilience against local datacenter outages.
Azure SQL Database Serverless with Zone-Redundant Storage (ZRS) or Geo-Redundant Storage (GRS) is selected. Locally Redundant Storage (LRS) is ruled out.
Serverless tier supports auto-pausing to save on compute costs during idle periods, while LRS does not survive a datacenter-level failure.

Key Concept

Selecting appropriate Azure SQL deployment models based on operational features (SQL Agent, cross-database queries), scaling patterns (Serverless auto-pausing), and high availability requirements.
Estimated Time:2m 0s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic