Question 11 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Question 11 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Question

HOTSPOT -

To complete the sentence, select the appropriate option in the answer area.

Hot Area:

Explanations

Disadvantages of non-relational databases include: Data Consistency " non-relational databases do not perform ACID transactions.

Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

Incorrect Answers:

Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.

Use Cloud storage (no relational database) for geographically distributed writes.

https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77