Examkin

Question

Difficulty: MediumPlatform as a Service (PaaS)

A logistics company is migrating its package tracking database to Azure SQL Database, which is a Platform as a Service (PaaS) offering. Under the Azure shared responsibility model, which of the following tasks is the customer responsible for managing?

  1. A
    Applying operating system security patches to the database server
  2. B
    Maintaining the physical servers and storage hardware in the Azure data center
  3. Configuring database firewall rules and managing user access permissionsAnswer
  4. D
    Providing the ready-to-use logistics software interface for end-users

Answer

Configuring database firewall rules and managing user access permissions
In a PaaS database offering such as Azure SQL Database, the customer is responsible for managing the data stored in the database, configuring database-level firewall rules, and managing user access permissions. Microsoft handles the physical hosting infrastructure, the virtualization layer, the operating system, and the database engine updates.

Step-by-Step Solution

1
Identify the service model of the deployed service (Azure SQL Database).
Azure SQL Database is a Platform as a Service (PaaS) database solution.
PaaS abstracts the operating system and database engine management from the customer.
2
Analyze the division of responsibilities for a PaaS database deployment.
Microsoft manages physical security, hardware, operating system patching, and database engine updates. The customer manages application data, database schemas, access controls, and firewall rules.
This conforms to the Azure shared responsibility model.
3
Evaluate the options against the customer's responsibilities in PaaS.
Configuring database firewall rules and managing user access permissions is a customer responsibility, whereas OS patching and physical hardware maintenance are handled by Microsoft, and a complete ready-to-use end-user interface describes SaaS.
This identifies the correct choice.

Key Concept

Shared Responsibility Model for PaaS Database Deployments

Alternative Method

Analyzing the scenario using a responsibility matrix can help quickly eliminate options: physical infrastructure and OS patching are always Microsoft's responsibility in PaaS, while end-user software delivery is SaaS.
Estimated Time:1m 0s
Rate this question

Topics

Platform as a Service (PaaS)

More questions from this topic