Soru

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

A company needs to store transaction records for a financial ledger. The data must be stored in tables with fixed schemas, and the system must enforce referential integrity using foreign keys.

Which Azure database service is best suited for these relational requirements?

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

Cevap

Azure SQL Database
Azure SQL Database is the correct choice because it is a fully managed relational database engine (PaaS) that supports relational schemas, tables, and foreign keys while automating infrastructure management tasks like patching and backups.

Adım Adım Çözüm

1
Analyze the requirements in the scenario.
The requirements demand storing relational data with fixed schemas and foreign key constraints.
This helps identify whether a relational or non-relational database service is needed.
2
Evaluate the database options based on the relational requirements.
Azure SQL Database natively supports relational schemas and constraints, while Azure Cosmos DB is a NoSQL service.
Choosing the correct model type is necessary to meet the application's structure needs.

Anahtar Kavram

Relational databases in Azure
Bu soruyu puanla