Examkin

Soru

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

An enterprise is migrating its on-premises SQL Server-based human resources (HR) application to Azure. The application requires a relational database that supports strict schema constraints, ACID transactions, and SQL Server compatibility. The enterprise wants to minimize administrative overhead by ensuring that Microsoft automatically handles operating system updates and database patching. Which Azure service should the enterprise select?

  1. Azure SQL DatabaseCevap
  2. B
    Azure Cosmos DB
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure Database for PostgreSQL

Cevap

Azure SQL Database
Azure SQL Database is a fully managed relational database service (Platform as a Service) that provides SQL Server compatibility, strict schema enforcement, ACID compliance, and automatic operating system and database engine patching by Microsoft.

Adım Adım Çözüm

1
Identify the database model requirement from the scenario.
The scenario requires a relational database that supports traditional schemas, ACID transactions, and SQL Server compatibility.
This rules out non-relational (NoSQL) databases.
2
Identify the management and patching requirements.
The solution must be fully managed with Microsoft handling operating system and database patching, which points to a Platform as a Service (PaaS) database service.
This rules out Infrastructure as a Service (IaaS) database hosting where the customer manages the operating system.
3
Select the service that satisfies both the relational and fully managed requirements.
Azure SQL Database is a fully managed relational database service (PaaS) that meets all the criteria.
It matches the schema, compatibility, and management requirements.

Anahtar Kavram

Azure relational database services and their management models (PaaS vs. IaaS)
Tahmini Süre:1m 0s
Bu soruyu puanla

Konular

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

Bu konudan daha fazla soru