CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #48
CERTIFIED-DATA-ANALYST-ASSOCIATE Question #48: Real Exam Question with Answer & Explanation
The correct answer is A: ACID transactions. ACID transactions are the key differentiator Delta Lake adds on top of traditional data lakes - they guarantee atomicity, consistency, isolation, and durability for read/write operations, something plain data lakes (typically backed by S3/ADLS) do not natively support. Why the di
Question
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
Options
- AACID transactions
- BFlexible schemas
- CData deletion
- DScalable storage
- EOpen-source formats
Explanation
ACID transactions are the key differentiator Delta Lake adds on top of traditional data lakes - they guarantee atomicity, consistency, isolation, and durability for read/write operations, something plain data lakes (typically backed by S3/ADLS) do not natively support.
Why the distractors are wrong:
- B (Flexible schemas): Both data lakes and lakehouses support flexible/schema-on-read approaches; this is not unique to Delta Lake.
- C (Data deletion): Traditional data lakes can delete data (it's just files); Delta Lake makes it reliable and consistent, but raw deletion capability isn't the advantage - ACID guarantees around it are.
- D (Scalable storage): Scalable storage is a core feature of all data lake solutions (e.g., S3, ADLS, GCS) - Delta Lake doesn't improve on this.
- E (Open-source formats): Delta Lake uses Parquet under the hood, but open-source formats (Parquet, ORC, Avro) are already common in standard data lakes.
Memory tip: Think of Delta Lake as adding a database engine layer on top of a data lake. The one thing databases have that vanilla data lakes don't is ACID - that's always the answer when asked what Delta Lake adds.
Community Discussion
No community discussion yet for this question.