Examkin

Question

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

A company is planning to migrate a legacy Microsoft SQL Server database to Microsoft Azure. The database requires host-level access to the underlying operating system to run custom file-system scripts, and the database administrators must retain complete control over the schedule for applying operating system patches.

Which Azure database deployment option meets these requirements?

  1. SQL Server on Azure Virtual MachinesAnswer
  2. B
    Azure SQL Database
  3. C
    Azure Cosmos DB
  4. D
    Azure Database for PostgreSQL

Answer

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines is an Infrastructure as a Service (IaaS) offering. Under this model, Microsoft manages the physical infrastructure, while the customer is responsible for configuring the virtual machine, including the operating system, database software configurations, patching schedule, and custom scripts.

Step-by-Step Solution

1
Analyze the administrative requirements of the database workload.
The database needs host-level operating system access to run custom scripts and full control over the operating system patching schedule.
This determines whether a Platform as a Service (PaaS) or Infrastructure as a Service (IaaS) solution is required.
2
Evaluate the database services against the shared responsibility model.
PaaS databases like Azure SQL Database and Azure Database for PostgreSQL automate operating system management and restrict host-level access. SQL Server on Azure Virtual Machines (IaaS) leaves operating system configuration and patching control to the customer.
To satisfy the requirement of OS-level access and custom patching control, an IaaS deployment option must be chosen.

Key Concept

Shared responsibility and database deployment models in Azure
Estimated Time:1m 0s
Rate this question

Topics

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

More questions from this topic