Examkin

Question

Difficulty: Very hardAzure Database Services (Relational, Non-Relational, and Cosmos DB)

When utilizing Azure Cosmos DB with the API for NoSQL, developers can query JSON documents using structured query language (SQL) syntax, and the database service automatically enforces relational integrity constraints, such as foreign keys, across multiple containers.

Answer: Answer

Answer

False
The correct answer is False because Azure Cosmos DB is a non-relational database. The API for NoSQL allows querying JSON data using structured query language (SQL) syntax, but it does not support or enforce relational database constraints like foreign keys across different containers.

Step-by-Step Solution

1
Analyze the database service and query API specified in the statement: Azure Cosmos DB using the API for NoSQL.
Identify that Azure Cosmos DB is a non-relational (NoSQL) database engine, and the API for NoSQL acts as a document query interface using SQL-like syntax.
Understanding the underlying architecture of the service is required to evaluate its capabilities.
2
Evaluate the statement's claim that the database service automatically enforces relational integrity constraints (like foreign keys) across containers.
Recognize that NoSQL document databases do not enforce relational schema constraints or foreign keys across collections/containers.
This tests whether the query syntax capabilities are being conflated with schema constraint enforcement.
3
Determine the correct truth value of the statement.
Since the service does not enforce relational constraints across containers, the statement is false.
To complete the evaluation and state the final answer.

Key Concept

Azure Cosmos DB is a non-relational database service that supports SQL querying but does not enforce relational database schema constraints like foreign keys.
Rate this question

Topics

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

More questions from this topic