Examkin

Question

Difficulty: Very hardRelational Data Storage Solutions

An enterprise logistics organization plans to migrate its legacy on-premises supply chain management system to Microsoft Azure. The system's relational database layer consists of multiple databases that have the following characteristics and requirements:

* Regular execution of SQL Server Agent jobs that initiate SQL Server Integration Services (SSIS) packages stored in the database.
* Cross-database queries using three-part and four-part names to join transactional and historical shipping data.
* Execution of SQL Common Language Runtime (CLR) integration with strict security assemblies for custom telemetry calculations.
* Strict network isolation requiring the database to reside inside a dedicated Azure Virtual Network subnet with no public internet routing.
* Minimization of administrative effort for patching the operating system and managing database backups.

Which Azure SQL deployment option should you recommend to meet all requirements?

  1. Azure SQL Managed InstanceAnswer
  2. B
    SQL Server on Azure Virtual Machines
  3. C
    Azure SQL Database Elastic Pool
  4. D
    Azure SQL Database single database

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance is the correct recommendation because it provides near 100% compatibility with the on-premises SQL Server database engine. It supports SQL Server Agent, cross-database queries, and CLR integration. Because it is a platform as a service (PaaS) deployment, Azure automates operating system updates, patches, and database backups. Furthermore, Managed Instance is deployed natively into an Azure Virtual Network subnet, satisfying the network security and isolation requirements.

Step-by-Step Solution

1
Analyze database engine requirements.
SQL Server Agent, SQL CLR, and native cross-database queries with three-part or four-part names require an instance-level deployment or VM.
Azure SQL Database single database and Elastic Pools do not support instance-level features like SQL Agent and native cross-database queries using multi-part names.
2
Evaluate network isolation requirements.
Both Azure SQL Managed Instance and SQL Server on Azure VMs natively support deployment inside a private Virtual Network (VNet) subnet.
This excludes public endpoints and meets the strict network isolation criteria.
3
Compare administrative overhead constraints.
Azure SQL Managed Instance is a PaaS service that automates OS patching and database backups, whereas SQL Server on Azure VMs is an IaaS service that leaves OS patching and database management to the customer.
Azure SQL Managed Instance meets all database feature, network, and administrative overhead requirements.

Key Concept

Selecting the optimal Azure SQL deployment based on legacy database engine features and management overhead.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic