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?

Question

Exhibit

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.

• A
  3% (1)
• B
  3% (1)
• C
  93% (27)

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.

No community discussion yet for this question.