Suggested Answer:
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. Reference: https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77
c. transactional writes
Explanation:
a. changes to relationships between entities
Incorrect. Although relational databases support relationships between entities, they are not necessarily optimized for scenarios that frequently change these relationships.
b. geographically distributed writes
Incorrect. Relational databases are typically not ideal for geographically distributed writes due to latency and consistency issues. NoSQL databases, like those supporting multi-master configurations, are often better suited for this purpose.
c. transactional writes
Correct. Relational databases are well-suited for handling high volumes of transactional writes due to their ACID (Atomicity, Consistency, Isolation, Durability) compliance, ensuring data consistency and integrity.
d. writes that have varying data structures
Incorrect. Relational databases are typically schema-based, meaning they require a fixed schema and are not flexible for handling writes with varying data structures. NoSQL databases are more suitable for such scenarios.
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Armandoo
Highly Voted 3 years, 10 months agoranimswami
Highly Voted 3 years, 11 months agoman5484
Most Recent 5 months, 1 week agoAGTraining
1 year, 1 month agotrashbox
1 year, 5 months agoMannyJZ
1 year, 8 months agoVNR25
1 year, 9 months agoHRKK
1 year, 9 months agoPhyoPluto
2 years, 1 month agochiiiweiii
2 years, 1 month agoKing_Lam
2 years, 2 months agoDavisonye
2 years, 7 months agoEltooth
2 years, 9 months agoheenak55
3 years agoRichMelbourne
3 years agoAZ5cert
3 years agoRajeshAzure
3 years, 1 month ago