Examkin

Question

Difficulty: HardRelational Data Storage Solutions

A financial services provider is planning to transition a localized underwriting database to Microsoft Azure. The database deployment must satisfy the following constraints:

* Support the execution of complex SQL Server Integration Services (SSIS) packages scheduled via SQL Server Agent.
* Permit the execution of cross-database queries across two distinct schemas within the same relational engine.
* Ensure direct connectivity via virtual network (VNet) delegation for private communication.
* Reduce administrative overhead associated with operating system patching and storage management.

Which database solution should you recommend?

  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 satisfies all defined constraints. It is a fully managed PaaS solution that eliminates operating system patching overhead. It supports SQL Server Agent, cross-database queries within the same instance, and native virtual network (VNet) delegation, which aligns perfectly with the requirements.

Step-by-Step Solution

1
Analyze the application compatibility requirements.
The requirements for SQL Server Agent and cross-database queries rule out Azure SQL Database single database and elastic pools.
Azure SQL Database single database and elastic pools do not support SQL Server Agent or three-part name cross-database queries natively.
2
Evaluate the administrative overhead constraints.
The requirement to reduce administrative overhead for OS patching and storage management rules out SQL Server on Azure Virtual Machines.
SQL Server on Azure VMs is an IaaS service, leaving the responsibility of OS and SQL Server patching to the administrator.
3
Verify networking requirements for the remaining option.
Azure SQL Managed Instance supports native VNet delegation, ensuring private communication.
Azure SQL Managed Instance is designed for secure, private VNet injection.

Key Concept

Azure SQL service selection based on SQL Server feature compatibility, administrative overhead, and network security constraints.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic