Examkin

Question

Difficulty: EasyAzure 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 DatabaseAnswer
  2. B
    Azure Cosmos DB
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure App Service

Answer

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.

Step-by-Step Solution

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.

Key Concept

Relational databases in Azure
Rate this question

Topics

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

More questions from this topic