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

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.
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.

View Answer

Answer: A

Explanation:

A scenario in which a database administrator would use a relational database rather than a non-relational database is when an organization wants to maintain consistency among the data in the database. A relational database is a type of database that organizes data into tables with predefined columns and rows, and enforces rules and constraints to ensure data integrity and accuracy. A relational database also supports transactions, which are sets of operations that must be executed as a whole or not at all, to prevent data corruption or inconsistency. The other options are either not exclusive to relational databases or not relevant to the choice of database type. For example, data encryption can be applied to both relational and non-relational databases, processing complex data sets may require specialized tools or techniques that are not dependent on the database type, and storing a large number of videos, photos, and documents may be better suited for a non-relational database that can handle unstructured or semi-structured data.

Reference: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify and apply database structure types.