Question

Difficulty: EasyShared Responsibility Model

A training provider migrates its online student registry database from SQL Server running on an Azure Virtual Machine to an Azure SQL Database instance.

Following this migration, which responsibility shifts entirely from the customer to Microsoft?

  1. A
    Configuring database user login permissions and managing data access control
  2. B
    Ensuring the physical security and hardware maintenance of the hosting datacenters
  3. Managing and installing updates for the underlying database server operating systemAnswer
  4. D
    Managing the client applications and endpoint devices that connect to the database

Answer

Managing and installing updates for the underlying database server operating system
Under the Azure Shared Responsibility Model, when transitioning from an Infrastructure as a Service (IaaS) resource like an Azure Virtual Machine to a Platform as a Service (PaaS) resource like Azure SQL Database, the responsibility for managing, patching, and maintaining the underlying operating system and virtual machine hardware shifts from the customer to Microsoft. The customer no longer has access to or responsibility for the operating system.

Step-by-Step Solution

1
Identify the cloud service models before and after the migration.
The initial environment (SQL Server on an Azure Virtual Machine) is an Infrastructure as a Service (IaaS) model. The target environment (Azure SQL Database) is a Platform as a Service (PaaS) model.
Defining the boundaries of IaaS and PaaS determines how responsibilities are distributed.
2
Compare operating system management responsibilities between IaaS and PaaS.
In IaaS, the customer manages the operating system. In PaaS, the cloud provider (Microsoft) handles the operating system maintenance, configuration, and patching.
This identifies the specific operational task that shifts to the provider during the migration.

Key Concept

Shared Responsibility Model IaaS to PaaS boundary
Estimated Time:45s
Rate this question