Databricks Certified Data Analyst Associate Exam (Databricks-Certified-Data-Analyst-Associate) Free Practice Test

Question 1

Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering.
Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?

A. SQL analyst

B. Business analyst

C. Business intelligence analyst

D. Data analyst

E. Data engineer

Correct Answer: E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

In which of the following situations will the mean value and median value of variable be meaningfully different?

A. When the variable contains a lot of extreme outliers

B. When the variable contains no outliers

C. When the variable is of the categorical type

D. When the variable contains no missing values

E. When the variable is of the boolean type

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

A. Tableau

B. Delta Lake

C. Databricks Notebooks

D. Databricks SQL

E. Databricks Machine Learning

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Which of the following benefits of using Databricks SQL is provided by Data Explorer?

A. It can be used to view metadata and data, as well as view/change permissions.

B. It can be used to produce dashboards that allow data exploration.

C. It can be used to make visualizations that can be shared with stakeholders.

D. It can be used to connect to third party Bl cools.

E. It can be used to run UPDATE queries to update any tables in a database.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

The result of the query should look like this:

Which of the following queries will accomplish this task?
A)

B)

C)

A. Option D

B. Option C

C. Option A

D. Option B

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect.
Which statement about Query History is incorrect?

A. It can be used to troubleshoot slow running queries.

B. It can be used to debug queries.

C. It can be used to view the query plan of queries that have run.

D. It can be used to automate query execution on multiple warehouses (formerly endpoints).

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard.
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

A. Markdown-based text boxes

B. Direct text written into the dashboard in editing mode

C. Separate queries for each section

D. Separate endpoints for each section

E. Separate color palettes for each section

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Databricks Certified Data Analyst Associate (Databricks-Certified-Data-Analyst-Associate) Free Practice Test