DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #64
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
The correct answer is B. A data lakehouse supports ACID-compliant transactions. A traditional data lake stores raw data without enforcing consistency rules, which can lead to partial writes, duplicate records, and corrupted data. ACID (Atomicity, Consistency, Isolation, Durability) transactions guarantee that data operations either complete fully or not at…
Question
Options
- AA data lakehouse provides storage solutions for structured and unstructured data.
- BA data lakehouse supports ACID-compliant transactions.
- CA data lakehouse allows the use of SQL queries to examine data.
- DA data lakehouse stores data in open formats.
- EA data lakehouse enables machine learning and artificial Intelligence workloads.
How the community answered
(24 responses)- B96% (23)
- E4% (1)
Explanation
A traditional data lake stores raw data without enforcing consistency rules, which can lead to partial writes, duplicate records, and corrupted data. ACID (Atomicity, Consistency, Isolation, Durability) transactions guarantee that data operations either complete fully or not at all, preventing partial updates and ensuring data remains consistent. This directly improves data quality. The other options (storing structured/unstructured data, SQL support, open formats, ML/AI workloads) are valid lakehouse features, but they are about capability or flexibility - not data quality enforcement.
Topics
Community Discussion
No community discussion yet for this question.