
Ultimate access to all questions.
A Delta Lake table named store_wise_sales was created in the test schema using the following SQL statement:
CREATE TABLE test.store_wise_sales AS (
SELECT *
FROM test.sales a
INNER JOIN test.store b
ON a.store_id = b.store_id
);
CREATE TABLE test.store_wise_sales AS (
SELECT *
FROM test.sales a
INNER JOIN test.store b
ON a.store_id = b.store_id
);
If a workspace administrator executes the command DROP TABLE test.store_wise_sales, what will be the outcome?*
A
No action will take place until a COMMIT command is explicitly executed.
B
The table will be removed from the catalog, but the underlying data files will persist in storage.
C
The table will be deleted from the catalog, and the associated data files will be permanently removed from storage.
D
An error will occur because Delta Lake prevents the deletion of tables containing production data.
E
The data will be marked as deleted in the transaction log but will still be retrievable using Delta Lake Time Travel.