Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Data Analyst Databricks-Certified-Data-Analyst-Associate Syllabus Exam Questions Answers

Databricks Certified Data Analyst Associate Exam Questions and Answers

Question 5

How can a data analyst determine if query results were pulled from the cache?

Options:

A.

Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.

B.

Go to the Alerts tab and check the Cache Status alert.

C.

Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.

D.

Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.

E.

Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.

Question 6

Delta Lake stores table data as a series of data files, but it also stores a lot of other information.

Which of the following is stored alongside data files when using Delta Lake?

Options:

A.

None of these

B.

Table metadata, data summary visualizations, and owner account information

C.

Table metadata

D.

Data summary visualizations

E.

Owner account information

Question 7

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.

Which of the following terms is used to describe this type of work?

Options:

A.

Data blending

B.

Last-mile

C.

Data testing

D.

Last-mile ETL

E.

Data enhancement

Question 8

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?

Options:

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;