Question
Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?
- A. An organization wants to maintain consistency among the data in the database. Correct
- B. An organization requires data encryption.
- C. An organization wants to process complex data sets.
- D. An organization wants to store a large number of videos, photos, and documents.
Explanation
Relational databases enforce a schema, primary and foreign key constraints and ACID transactions, which keep data consistent across related tables. Encryption is available in both relational and non-relational systems, many non-relational systems handle complex or large data sets well, and large numbers of videos, photos and documents are better suited to object or document storage than to relational tables.
