Databricks Exam Databricks-Certified-Data-Analyst-Associate Topic 10 Question 5 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Analyst-Associate exam

Question #: 5
Topic #: 10

[All Databricks-Certified-Data-Analyst-Associate Questions]

A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.

Which of the following commands can the analyst use to complete the task without producing an error?

ADROP DATABASE database_name;

BDROP TABLE database_name.table_name;

CDELETE TABLE database_name.table_name;

DDELETE TABLE table_name FROM database_name;

EDROP TABLE table_name FROM database_name;

Show Suggested Answer

Suggested Answer: B

The DROP TABLE command removes a table from the metastore and deletes the associated data files. The syntax for this command is DROP TABLE [IF EXISTS] [database_name.]table_name;. The optional IF EXISTS clause prevents an error if the table does not exist. The optional database_name. prefix specifies the database where the table resides. If not specified, the current database is used. Therefore, the correct command to remove the table table_name from the database database_name and all of the data files associated with it is DROP TABLE database_name.table_name;. The other commands are either invalid syntax or would produce undesired results.Reference:Databricks - DROP TABLE

by Larae at Jan 26, 2024, 02:44 PM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Data-Analyst-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!