Examkin

Question

Difficulty: EasyRelational Data Storage Solutions

A medical group is planning to migrate a local relational database to the cloud. The database contains several legacy features, including SQL Server Agent jobs and cross-database queries across two databases. You need to recommend a fully managed database solution that minimizes management overhead while supporting these features. Which Azure SQL deployment option should you select?

  1. A
    Azure SQL Database (Single Database)
  2. B
    Azure SQL Database Elastic Pool
  3. Azure SQL Managed InstanceAnswer
  4. D
    SQL Server on Azure Virtual Machines

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance provides near-100% compatibility with the SQL Server database engine, including support for SQL Server Agent and cross-database queries. Because it is a fully managed platform-as-a-service (PaaS), it also minimizes administrative overhead by automating patching, backups, and high availability.

Step-by-Step Solution

1
Identify the legacy database feature requirements.
The requirements are support for SQL Server Agent and cross-database queries.
These are instance-level features of SQL Server.
2
Filter Azure SQL options based on support for these legacy features.
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines support both SQL Server Agent and cross-database queries.
Azure SQL Database (Single Database or Elastic Pools) does not support these instance-level features natively.
3
Filter remaining options based on management overhead and platform type.
Azure SQL Managed Instance is chosen because it is a fully managed PaaS solution.
SQL Server on Azure Virtual Machines is an IaaS solution that requires significant administrative effort for OS patching, SQL updates, and backup management.

Key Concept

Selecting the correct Azure SQL service based on compatibility with instance-level features and administrative management overhead.
Estimated Time:45s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic