After running DESCRIBE EXTENDED accounts.customers;, the following was returned: Now, a data analyst runs the following command: DROP accounts.customers; Which of the following describes the result of running this command?
A.
Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.
B.
Running SELECT * FROM accounts.customers will return all rows in the table.
C.
All files with the .customers extension are deleted.
D.
The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
E.
The accounts.customers table is removed from the metastore, but the underlying data files are untouched.
Since this is an external aka unmanaged table, dropping the table only deletes the metadata. The data itself is untouched. This is assuming that "table" is missing from "drop table" due to a transcription error. Now, if the question is written on the test as it is here, then the answer would be B, since the DROP TABLE statement is incorrect and the table would not have been dropped.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
THC1138
3 months, 3 weeks agomarkiz
4 months, 2 weeks agoADVIT
6 months ago