https://www.crackyourinterview.com/quiz

SelectCategory

SelectQuestionNo

A data analyst is attempting to drop a table mytable (View:-77)
A data analyst is attempting to drop a table my_table. The analyst 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?

Choose the correct answer from below list

The table's data was larger than 10 GB

The table did not have a location

The table was external

The table's data was smaller than 10 GB

The table was managed

Some Other Questions

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A data analyst has recently joined a new team that uses Databricks SQL

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

Data professionals with varying titles use the Databricks SQL service

A data analyst wants to create a dashboard with three main sections