
Ultimate access to all questions.
Answer-first summary for fast verification
Answer: A data lakehouse supports ACID-compliant transactions.
## Explanation **Correct Answer: B** **Why ACID-compliant transactions improve data quality:** 1. **ACID Properties:** - **Atomicity:** Ensures that transactions are all-or-nothing operations - **Consistency:** Guarantees that data remains in a consistent state before and after transactions - **Isolation:** Prevents concurrent transactions from interfering with each other - **Durability:** Ensures committed transactions persist even in case of system failures 2. **Traditional Data Lake Limitations:** - Traditional data lakes lack ACID compliance, leading to potential data corruption - Multiple concurrent writes can result in data inconsistencies - No guarantee of data integrity during ETL/ELT processes 3. **Data Lakehouse Advantages:** - ACID transactions ensure reliable data updates and modifications - Prevents partial writes and maintains data consistency - Enables reliable concurrent data processing - Supports reliable data versioning and time travel capabilities **Why other options are not correct:** - **A:** Storage solutions for structured/unstructured data is a feature but doesn't inherently improve data quality - **C:** SQL query capability improves accessibility but not necessarily data quality - **D:** Open formats improve interoperability but not data quality - **E:** ML/AI capabilities are workload features, not data quality improvements ACID compliance directly addresses data quality issues by ensuring data integrity, consistency, and reliability during data operations, which is a key differentiator from traditional data lakes.
Author: Keng Suppaseth
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
A
A data lakehouse provides storage solutions for structured and unstructured data.
B
A data lakehouse supports ACID-compliant transactions.
C
A data lakehouse allows the use of SQL queries to examine data.
D
A data lakehouse stores data in open formats.
E
A data lakehouse enables machine learning and artificial intelligence workloads.
No comments yet.