Examkin

Question

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

A company plans to migrate a database to Azure. The company's IT compliance policy requires their administrators to maintain full control over the database configuration and have direct access to the underlying operating system to perform patching. Which Azure deployment option should they choose?

  1. A
    Azure SQL Database
  2. B
    Azure Cosmos DB
  3. SQL Server on Azure Virtual MachinesAnswer
  4. D
    Azure SQL Managed Instance

Answer

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines represents an Infrastructure as a Service (IaaS) database deployment. Under IaaS, the customer retains administrative control over the virtual machine, which includes the responsibility to perform operating system patching and fully configure the database engine.

Step-by-Step Solution

1
Analyze the management requirements.
The company requires full control over the database configuration and direct access to perform operating system patching.
This requirement indicates an Infrastructure as a Service (IaaS) model rather than a Platform as a Service (PaaS) model.
2
Evaluate the database options against the IaaS model.
SQL Server on Azure Virtual Machines is an IaaS option, whereas Azure SQL Database, Azure SQL Managed Instance, and Azure Cosmos DB are PaaS options where Microsoft handles OS patching.
To maintain OS-level patching control, the customer must select the virtual machine hosting option.

Key Concept

Operating system and management responsibilities for Azure SQL Database options (IaaS vs PaaS)
Rate this question

Topics

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

More questions from this topic