Soru

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

A financial organization needs a fully managed database for its new billing application. The database must enforce strict relational constraints, including foreign keys and transaction boundaries. Additionally, the IT team wants to avoid any responsibility for operating system patching or database engine updates. Which Azure service should the organization select?

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

Cevap

Azure SQL Database is the correct choice because it is a relational database service that automatically handles patching and database management.
Azure SQL Database is a fully managed relational database service (PaaS) that handles operating system patching, backups, and database updates automatically while supporting traditional relational database features like foreign keys and transaction boundaries.

Adım Adım Çözüm

1
Analyze the workload requirement for relational constraints.
The application requires strict relational constraints like foreign keys and transaction boundaries, pointing to a relational database service.
This rules out non-relational database services such as NoSQL solutions.
2
Analyze the administrative requirements regarding patching and updates.
The IT team wants Microsoft to manage operating system patching and database updates, which requires a Platform as a Service (PaaS) model.
This rules out Infrastructure as a Service (IaaS) options like SQL Server on Azure Virtual Machines, where the customer is responsible for patching.
3
Select the service that satisfies both relational constraints and PaaS patching management.
Azure SQL Database provides a relational PaaS database engine with automatic patching.
It matches all specified criteria.

Anahtar Kavram

Selecting the appropriate Azure database service based on relational requirements and cloud service model management responsibilities.
Tahmini Süre:1m 0s
Bu soruyu puanla