Databricks Certified Data Analyst Associate: DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

A. As an exact substitute with the same level of functionality

B. As a substitute with less functionality

C. As a complete replacement with additional functionality

D. As a complementary tool for professional-grade presentations

E. As a complementary tool for quick in-platform BI work

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?

A. The table's data was larger than 10 GB

B. The table did not have a location

C. The table was external

D. The table's data was smaller than 10 GB

E. The table was managed

A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.

Which of the following terms is used to describe this data augmentation?

A. Data testing

B. Ad-hoc improvements

C. Last-mile dashboarding

D. Last-mile ETL

E. Data enhancement