Databricks Certified Data Analyst - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineer has a managed table named table_name in a database named database_name. They want to delete this table and all of its underlying data files. The other tables in the database must remain unaffected.
Which command will successfully complete this task without causing an error?
A
DROP DATABASE database_name;_
B
DROP TABLE database_name.table_name;
C
DELETE TABLE database_name.table_name;
D
DELETE TABLE table_name FROM database_name;
E
DROP TABLE table_name FROM database_name;