Examkin

Soru

Zorluk: ZorRelational 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 InstanceCevap
  4. D
    SQL Server on Azure Virtual Machines

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

Azure SQL service selection based on SQL Server feature compatibility, administrative overhead, and network security constraints.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru