Certified Data Analyst AssociateDemo

By Databricks · Question Mode

QuestionQ135

Managing Data

A data analyst has a managed table table_name in database database_name. They now want to remove the table from the database along with all data files associated with it. All other tables in the database must remain.

Which of the following commands can the analyst use to 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;
Explanation

DROP TABLE database_name.table_name drops only the specified qualified table, leaving the containing database and its other tables intact. For a managed table, the platform manages deletion of the table’s underlying data files (in Unity Catalog, deletion follows its configured recovery lifecycle).

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!