Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company plans to migrate two on-premises SQL Server databases to Azure. The databases have the following requirements:

* Database 1: Supports a legacy human resources application that requires SQL Server Agent, Common Language Runtime (CLR) integration, and cross-database queries.
* Database 2: Supports a lightweight web API that has highly unpredictable traffic patterns, requiring automatic scaling of compute resources and a cost model where compute is billed per second of active usage.

The migration strategy must minimize administrative overhead for managing operating systems and database software updates.

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

  1. Azure SQL Managed Instance for Database 1Answer
  2. Azure SQL Database serverless for Database 2Answer
  3. C
    SQL Server on Azure Virtual Machines for Database 1
  4. D
    Azure SQL Database single database for Database 1

Answer

Azure SQL Managed Instance for Database 1 and Azure SQL Database serverless for Database 2
Recommending Azure SQL Managed Instance for the legacy HR database is correct because it supports the required instance-level features (SQL Server Agent, CLR, cross-database queries) while acting as a fully managed PaaS service that automates software updates and patching. Recommending Azure SQL Database serverless for the web API is correct because it dynamically scales compute based on workload demand and offers per-second billing, which aligns with unpredictable traffic patterns and reduces idle costs.

Step-by-Step Solution

1
Evaluate the database engine feature requirements for Database 1.
Database 1 requires SQL Server Agent, CLR integration, and cross-database queries. These are instance-level SQL features.
Identifying these requirements eliminates Azure SQL Database single database, which does not support these instance-level legacy features.
2
Apply the administrative constraint to the deployment options for Database 1.
Azure SQL Managed Instance is chosen over SQL Server on Azure Virtual Machines.
The scenario requires minimizing administration overhead for operating systems and software updates. Azure VMs (IaaS) require manual OS and SQL patching, while Managed Instance (PaaS) manages updates automatically.
3
Evaluate the workload characteristics and billing requirements for Database 2.
Database 2 requires automatic compute scaling and per-second billing due to unpredictable traffic.
Azure SQL Database serverless provides automatic scaling of compute and charges for CPU and memory used per second, making it the most cost-effective solution.

Key Concept

Selecting appropriate Azure SQL services based on legacy feature requirements, administrative constraints, and workload behavior.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic