Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A retail corporation is designing a new inventory tracking system in Azure. The database layer must meet the following requirements:

* Allow queries that span multiple databases using standard three-part naming.
* Automate administrative tasks such as operating system updates and database backups.
* Provide a built-in high availability SLA without requiring manual cluster configuration.
* Support running scheduled maintenance jobs using the SQL Server Agent.

Which Azure SQL service should you recommend?

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

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance is the correct choice because it combines the benefits of a fully managed Platform as a Service (PaaS) with high compatibility with the SQL Server database engine. It natively supports SQL Server Agent and cross-database queries using three-part naming, while automating operating system updates, backups, and high availability.

Step-by-Step Solution

1
Identify the key application requirements
The requirements include SQL Server Agent, native cross-database queries (three-part naming), automated OS updates/backups, and built-in high availability.
This establishes the criteria for evaluating the Azure SQL deployment options.
2
Filter deployment options by support for SQL Server Agent and cross-database queries
Azure SQL Database (single database and elastic pools) are eliminated because they do not natively support SQL Server Agent or cross-database queries using three-part naming. Azure SQL Managed Instance and SQL Server on Azure VMs remain.
Both requirements are critical feature dependencies that must be natively supported.
3
Evaluate the remaining options against the administrative and SLA requirements
SQL Server on Azure VMs requires manual OS updates and manual HA cluster setup. Azure SQL Managed Instance is a PaaS service that automates patching, backups, and provides built-in high availability.
Choosing a fully managed PaaS solution satisfies the requirement to automate updates and minimize cluster management effort.

Key Concept

Selecting the appropriate Azure SQL deployment option based on compatibility requirements and management overhead.
Estimated Time:1m 30s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic