A company is designing a transaction auditing system that requires strict relational schemas, foreign key constraints, and complex multi-table SQL queries. The database administrator proposes using Azure Cosmos DB with the API for NoSQL to meet these requirements. Which statement correctly evaluates this proposal?
- The proposal is incorrect because Azure Cosmos DB is a non-relational database designed for semi-structured data; its API for NoSQL queries JSON documents and does not support traditional relational database constraints and joins.Cevap
- BThe proposal is correct because the API for NoSQL allows Azure Cosmos DB to function as a traditional relational database that fully supports relational schemas, foreign keys, and multi-table joins.
- CThe proposal is incorrect because Azure Cosmos DB is an Infrastructure as a Service (IaaS) solution, requiring the company to manually configure and patch the operating system to support relational features.
- DThe proposal is incorrect because Azure Cosmos DB is a Software as a Service (SaaS) application, which prevents developers from defining custom database tables or querying them with SQL.
Cevap
The proposal is incorrect because Azure Cosmos DB is a non-relational database designed for semi-structured data; its API for NoSQL queries JSON documents and does not support traditional relational database constraints and joins.
The correct answer is correct because Azure Cosmos DB is fundamentally a non-relational database. The API for NoSQL provides a familiar SQL-like syntax to query semi-structured JSON document files, but it does not support relational constraints, foreign keys, or traditional relational multi-table JOIN operations.
Adım Adım Çözüm
Anahtar Kavram
Azure Cosmos DB is a NoSQL (non-relational) database service, and its API for NoSQL is used for querying JSON document structures, not for enforcing traditional relational database constraints.