A Delta Lake table was created with the databricks video

Full Certification Question

A Delta Lake table was created with the below query: CREATE TABLE prod . sales_by_store AS ( SELECT * FROM prod . sales a INNER JOIN prod . store b ON a . store_id = b . store_id ) Consider the following query: DROP TABLE prod.sales_by_store If this statement is executed by a workspace admin, which result will occur?