An organization needs to store daily transactional data such as customer records and purchase history. The data follows a consistent schema and is cross-referenced. Which type of service should the organization use?
C. Relational database
A relational database is the best choice for transactional data that:
Follows a consistent schema (structured data).
Is cross-referenced, meaning relationships between tables are required (e.g., customer records linked to purchase history).
Supports ACID (Atomicity, Consistency, Isolation, Durability) properties, which are essential for ensuring data integrity in transactional systems.
Why not the other options?
A. Non-relational database:
These are best suited for unstructured or semi-structured data and high scalability needs (e.g., IoT, social media data). They do not handle complex relationships or structured schemas as well as relational databases.
B. Data warehouse:
A data warehouse is optimized for analytical workloads, such as querying and reporting on historical data, not for handling daily transactional data.
D. Data lake:
A data lake is designed to store large volumes of raw, unstructured, or semi-structured data. It lacks the structured schema and ACID compliance required for transactional systems.
upvoted 1 times
...
...
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.
joshnort
2 weeks, 2 days agojoshnort
2 weeks, 2 days ago