Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?

Question

Options

• AAn organization wants to maintain consistency among the data in the database.
• BAn organization requires data encryption.
• CAn organization wants to process complex data sets.
• DAn organization wants to store a large number of videos, photos, and documents.

• A
  94% (34)
• C
  3% (1)
• D
  3% (1)

Explanation

Relational databases (RDBMS) are specifically designed to maintain data consistency through ACID properties (Atomicity, Consistency, Isolation, Durability), enforced schemas, and referential integrity constraints (foreign keys). When an organization requires that data remain consistent and accurate across related tables - such as in financial or transactional systems - a relational database is the correct choice. Non-relational (NoSQL) databases trade strict consistency for scalability and flexibility. Data encryption (B) is available in both types. Processing complex data sets (C) is often a strength of NoSQL systems like document or graph databases. Storing large volumes of unstructured binary files like videos and photos (D) is a use case suited to object/blob storage or NoSQL databases, not relational ones.

No community discussion yet for this question.