<< Prev Question Next Question >>

Question 13/22

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (22q)
Question 1: A data analysis team has noticed that their Databricks SQL q...
Question 2: A single Job runs two notebooks as two separate tasks. A dat...
Question 3: A data engineer wants to create a new table containing the n...
Question 4: A data engineer only wants to execute the final block of a P...
Question 5: Which of the following describes when to use the CREATE STRE...
Question 6: Which of the following benefits of using the Databricks Lake...
Question 7: A data engineering team has two tables. The first table marc...
Question 8: A data engineer has configured a Structured Streaming job to...
Question 9: A data engineer needs to determine whether to use the built-...
Question 10: A new data engineering team has been assigned to work on a p...
Question 11: An engineering manager wants to monitor the performance of a...
Question 12: Which of the following code blocks will remove the rows wher...
Question 13: A data engineer is attempting to drop a Spark SQL table my_t...
Question 14: Which of the following Structured Streaming queries is perfo...
Question 15: A data engineer wants to create a data entity from a couple ...
Question 16: A data analyst has created a Delta table sales that is used ...
Question 17: A data engineer has been using a Databricks SQL dashboard to...
Question 18: Which of the following is hosted completely in the control p...
Question 19: A data engineer needs to create a table in Databricks using ...
Question 20: Which of the following describes a scenario in which a data ...
Question 21: Which of the following tools is used by Auto Loader process ...
Question 22: Which of the following benefits is provided by the array fun...