Question

Difficulty: EasyShared Responsibility Model

A logistics company plans to migrate a database from Microsoft SQL Server running on an Azure Virtual Machine (IaaS) to Azure SQL Database (PaaS). Which two responsibilities will shift from the company to Microsoft after this migration?

  1. Operating system patching and updatesAnswer
  2. Database engine software maintenance and patchingAnswer
  3. C
    Configuring database user access and permissions
  4. D
    Physical security of the datacenter hosting the database servers

Answer

The responsibilities for operating system patching and updates, and database engine software maintenance and patching, shift from the customer to Microsoft.
Migrating from Azure Virtual Machines (IaaS) to Azure SQL Database (PaaS) reduces the customer's administrative overhead. Microsoft takes over responsibility for managing and patching the operating system, as well as installing, configuring, and updating the database engine software.

Step-by-Step Solution

1
Analyze the source and target service models in the scenario.
The source model is Infrastructure as a Service (IaaS) because it uses Azure Virtual Machines. The target model is Platform as a Service (PaaS) because it uses Azure SQL Database.
Understanding the service models is necessary to compare the distribution of responsibilities.
2
Determine which management layers shift from customer ownership to Microsoft ownership.
In IaaS, the customer manages the operating system, middleware, and database application. In PaaS, Microsoft manages the operating system, middleware, and database engine runtime.
This identifies the responsibilities that transition to the cloud provider.
3
Evaluate the options against the identified shifting responsibilities.
Operating system patching and database engine maintenance shift to Microsoft. User access management remains the customer's responsibility in both models. Physical security is already Microsoft's responsibility in both models, so it does not shift.
This filters the correct selections from the incorrect distractors.

Key Concept

Shared Responsibility Model
Rate this question