Examkin

Question

Difficulty: HardAzure Database Services (Relational, Non-Relational, and Cosmos DB)

A retail corporation wants to move its local inventory management database to the cloud. The system is built on a relational database structure and relies on internal SQL Server Agent jobs to update stock levels every hour. The corporation wants to eliminate the administrative burden of operating system maintenance and automated security patching. However, they need to keep the instance-level capabilities of their database engine without refactoring the application.

Which Azure service meets these database requirements?

  1. Azure SQL Managed InstanceAnswer
  2. B
    Azure SQL Database
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure Cosmos DB

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance is correct because it is a fully managed PaaS database service designed to migrate on-premises SQL Server databases with minimal refactoring. It automatically handles operating system patching and maintenance while supporting instance-level features such as SQL Server Agent.

Step-by-Step Solution

1
Analyze the management requirement
The customer wants to eliminate operating system maintenance and automated security patching, which points to a Platform as a Service (PaaS) model rather than Infrastructure as a Service (IaaS).
This rules out SQL Server on Azure Virtual Machines, which requires the customer to manage and patch the operating system.
2
Analyze the database feature requirement
The database requires instance-level SQL Server features, specifically SQL Server Agent jobs, without application refactoring.
This rules out Azure SQL Database, which is a database-scoped PaaS service and does not natively support SQL Server Agent jobs at the instance level. It also rules out Azure Cosmos DB, which is a NoSQL service.
3
Select the service that satisfies both requirements
Azure SQL Managed Instance provides a fully managed PaaS environment (no OS patching) while supporting instance-level SQL Server features like SQL Server Agent.
It offers the benefits of a fully managed PaaS service combined with high SQL Server instance-level compatibility.

Key Concept

Azure Database Services (Relational, Non-Relational, and Cosmos DB)
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic