Examkin

Question

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

A company plans to migrate a legacy SQL Server database to Azure. The database relies on third-party, OS-level security agents and requires custom configurations to the underlying operating system that are not supported in fully managed services. Which Azure database option should the company select to meet these requirements?

  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 is an Infrastructure as a Service (IaaS) offering. This model grants the customer full administrative access to the underlying operating system and database engine, which is necessary to install third-party security agents and apply custom OS configurations.

Step-by-Step Solution

1
Analyze the application requirements.
The legacy SQL Server database requires operating system-level access to host third-party security agents and apply custom configurations.
This establishes the level of control needed over the underlying infrastructure.
2
Compare Azure SQL deployment models based on administrative control.
Fully managed Platform as a Service (PaaS) offerings like Azure SQL Database and Azure SQL Managed Instance abstract the operating system, whereas Infrastructure as a Service (IaaS) via SQL Server on Azure Virtual Machines provides full OS access.
This determines which cloud service model satisfies the constraint of having OS-level access.

Key Concept

The primary differentiator between IaaS and PaaS database offerings in Azure is the level of administrative control over the operating system and database engine configurations.
Rate this question

Topics

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

More questions from this topic