Data Lake vs Delta Lake and ACID | Dataford Interview Questions

Explain the difference between a data lake and Delta Lake, including Delta tables and ACID properties with examples.

Use the supplied PostgreSQL tables to produce a query-backed comparison. Include examples showing how committed Delta table operations differ from ordinary data lake assets, and explain the relevant ACID properties.

Output

One row per lake asset, with asset_name, storage_model, acid_properties, committed_transactions, and committed_rows.
Include assets without committed transactions, order by asset_name ascending, and exclude uncommitted operations.

Schema

lake_assets

Column	Type	Description
asset_idPK	INT	Unique lake asset identifier
asset_name	VARCHAR(100)	Logical name of the lake asset
file_format	VARCHAR(20)	Underlying storage format
is_delta_table	BOOLEAN	Whether the asset is managed as a Delta table

delta_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
asset_id	INT	Referenced lake asset
operation	VARCHAR(20)	Operation recorded in the transaction log
is_committed	BOOLEAN	Whether the operation was committed
rows_affected	INT	Number of rows affected by the operation

Your question is Data Lake vs Delta Lake and ACID. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem