Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

New Release Databricks-Certified-Data-Analyst-Associate Data Analyst Questions

Databricks Certified Data Analyst Associate Exam Questions and Answers

Question 9

The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run:

After runningSELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.

After logging back in two days later, what is the status of thestakeholders.eur_customersview?

Options:

A.

The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.

B.

The view has been dropped.

C.

The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.

D.

The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.

E.

The view has been converted into a table.

Question 10

A data analyst has been asked to produce a visualization that shows the flow of users through a website.

Which of the following is used for visualizing this type of flow?

Options:

A.

Heatmap

B.

IChoropleth

C.

Word Cloud

D.

Pivot Table

E.

Sankey

Question 11

A data analyst has created a Query in Databricks SQL, and now wants to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.

Which step will the data analyst need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

Options:

A.

Copy the Query and create one data visualization per query.

B.

Add two separate visualizations to the dashboard based on the same Query.

C.

Decide on a single data visualization to add to the dashboard.

D.

Alter the Query to return two separate sets of results.

Question 12

Data professionals with varying responsibilities use the Databricks Lakehouse Platform Which role in the Databricks Lakehouse Platform use Databricks SQL as their primary service?

Options:

A.

Data scientist

B.

Data engineer

C.

Platform architect

D.

Business analyst