Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A logistics company plans to migrate an on-premises SQL Server database system to Azure. The migration must meet the following requirements:

* Support scheduled data aggregation jobs using SQL Server Agent.
* Enable cross-database queries using three-part names across multiple databases on the same instance.
* Ensure the database is natively deployed within a private virtual network subnet with no public endpoints.
* Minimize administrative effort for managing operating system patching and physical storage.

Which database solution should you recommend?

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

Answer

Azure SQL Database Managed Instance
Azure SQL Database Managed Instance is the correct choice because it is a fully managed (PaaS) relational database service that supports SQL Server Agent, native virtual network integration, and cross-database queries. This fulfills all technical requirements while minimizing the administrative overhead associated with managing the underlying operating system and hardware.

Step-by-Step Solution

1
Analyze compatibility requirements
SQL Server Agent and native cross-database queries with three-part names require either SQL Server on Azure Virtual Machines or Azure SQL Database Managed Instance.
Azure SQL Database (single database or elastic pools) does not natively support SQL Server Agent or standard three-part cross-database queries.
2
Evaluate network isolation requirements
Both Azure SQL Database Managed Instance and SQL Server on Azure VMs support native deployment into a private virtual network subnet.
This requirement rules out standard Azure SQL Database deployments that rely on public endpoints unless private endpoints are configured, but Managed Instance natively deploys into a delegated subnet.
3
Assess administrative effort limits
Azure SQL Database Managed Instance is a platform-as-a-service (PaaS) offering, whereas SQL Server on Azure VMs is infrastructure-as-a-service (IaaS).
Because the scenario specifies minimizing administrative effort for OS patching and physical storage, Managed Instance is the best fit as a PaaS option.

Key Concept

Relational Data Storage Solutions selection based on feature compatibility and administrative effort
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic