Question 15

A data engineer in a Unity Catalog-enabled workspace creates two tables in the `prod.silver` schema: ```sql -- Table 1: storage location chosen by Unity Catalog CREATE TABLE prod.silver.orders_managed (id BIGINT, total DECIMAL(10,2)); -- Table 2: data files live in customer-owned cloud storage CREATE TABLE prod.silver.orders_external (id BIGINT, total DECIMAL(10,2)) USING DELTA LOCATION 'abfss://[email protected]/orders/'; ``` Later, both tables are dropped: ```sql DROP TABLE prod.silver.orders_managed; DROP TABLE prod.silver.orders_external; ``` What is the result for the underlying data files of each table immediately after the `DROP TABLE` statements run?

• ABoth tables' data files are deleted immediately, because `DROP TABLE` always removes the underlying storage in Unity Catalog.
• BFor `orders_managed`, the metadata is removed and the data is marked for deletion but can be recovered with `UNDROP` for 7 days; for `orders_external`, the metadata is removed but the underlying data files remain in place.
• CNeither table's data is removed; `DROP TABLE` only removes metadata for managed and external tables alike, and files for both must be deleted manually.
• DFor `orders_managed`, the files remain in cloud storage; for `orders_external`, the files are deleted immediately because the engineer specified the `LOCATION`.
• E`DROP TABLE` fails on `orders_external` because external tables can only be removed with `DROP EXTERNAL TABLE`.