CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #66
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #66: Real Exam Question with Answer & Explanation
The correct answer is C: The table will be removed from the catalog and the data will be deleted.. When a table is dropped in Delta Lake, the table is removed from the catalog and the data is deleted. This is because Delta Lake is a transactional storage layer that provides ACID guarantees. When a table is dropped, the transaction log is updated to reflect the deletion of the
Question
A Delta Lake table was created with the below query: Consider the following query: DROP TABLE prod.sales_by_store If this statement is executed by a workspace admin, which result will occur?
Options
- ANothing will occur until a COMMIT command is executed.
- BThe table will be removed from the catalog but the data will remain in storage.
- CThe table will be removed from the catalog and the data will be deleted.
- DAn error will occur because Delta Lake prevents the deletion of production data.
- EData will be marked as deleted but still recoverable with Time Travel.
Explanation
When a table is dropped in Delta Lake, the table is removed from the catalog and the data is deleted. This is because Delta Lake is a transactional storage layer that provides ACID guarantees. When a table is dropped, the transaction log is updated to reflect the deletion of the table and the data is deleted from the underlying storage.
Topics
Community Discussion
No community discussion yet for this question.