Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning to migrate an on-premises database environment to Azure. The environment consists of two databases that perform frequent cross-database queries. The migration must satisfy the following requirements:
- Minimize the administrative overhead of managing the underlying operating system and virtual machines.
- Support the execution of existing SQL Server Agent jobs.
- Support cross-database queries between the two databases.
- Ensure the databases are accessible via a private IP address within a virtual network.

Which two Azure SQL options can satisfy these requirements? (Select two.)

  1. Azure SQL Managed Instance General PurposeAnswer
  2. Azure SQL Managed Instance Business CriticalAnswer
  3. C
    Azure SQL Database single database
  4. D
    Azure SQL Database elastic pool
  5. E
    SQL Server on Azure Virtual Machines

Answer

The correct options are Azure SQL Managed Instance General Purpose and Azure SQL Managed Instance Business Critical.
Azure SQL Managed Instance (both General Purpose and Business Critical tiers) provides near 100% compatibility with the latest SQL Server database engine. It includes a built-in SQL Server Agent, supports cross-database queries using three-part names, and is natively deployed within a subnet of an Azure Virtual Network (VNet) to secure access via a private IP address. As a fully managed PaaS solution, it eliminates the administrative overhead of managing the operating system and virtual machine infrastructure.

Step-by-Step Solution

1
Evaluate the management overhead requirement.
SQL Server on Azure Virtual Machines is identified as an Infrastructure-as-a-Service (IaaS) solution requiring OS management, making it unsuitable.
The scenario requires minimizing administrative overhead of the operating system and VMs.
2
Evaluate feature compatibility for SQL Server Agent and cross-database queries.
Azure SQL Database (single database and elastic pool) does not support these native SQL features, whereas Azure SQL Managed Instance supports both.
The database needs to preserve SQL Server Agent jobs and support cross-database queries.
3
Identify the service tiers that satisfy all requirements.
Both the General Purpose and Business Critical service tiers of Azure SQL Managed Instance provide the required native feature set and managed environment.
Service tiers within Managed Instance share the same core database engine compatibility features.

Key Concept

Selecting the appropriate Azure SQL deployment option based on compatibility requirements and management overhead.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic