Soru

Zorluk: OrtaAzure Database Services (Relational, Non-Relational, and Cosmos DB)

A software development team is building a custom employee tracking system. They need a database that supports traditional relational schemas, structured query language (SQL), and ACID transactions. Additionally, the team requires that Microsoft automatically manages all operating system patching and database engine updates so they can focus purely on application development. Which Azure service meets these requirements?

  1. Azure SQL DatabaseCevap
  2. B
    SQL Server on Azure Virtual Machines
  3. C
    Azure Cosmos DB
  4. D
    Dynamics 365

Cevap

Azure SQL Database
Azure SQL Database is a fully managed relational database engine (PaaS) that handles upgrading, patching, backups, and monitoring without user involvement, making it the correct fit for the required relational schema and automatic patching.

Adım Adım Çözüm

1
Analyze the database schema and query requirements.
The solution requires traditional relational schemas, SQL, and ACID transactions. This points to a relational database service.
Eliminating non-relational database services such as NoSQL alternatives.
2
Analyze the management and patching requirements.
The customer wants Microsoft to automatically manage the operating system patching and database software updates.
This points to a Platform as a Service (PaaS) offering and eliminates Infrastructure as a Service (IaaS) options like Virtual Machines where the customer is responsible for OS patching.
3
Select the service that is a fully managed PaaS relational database.
Azure SQL Database is a fully managed PaaS relational database that matches all specified criteria.
Ensures the correct balance of relational database features and cloud management responsibilities.

Anahtar Kavram

Azure relational database services and PaaS shared responsibility
Bu soruyu puanla