Databricks-Certified-Data-Analyst-Associate by Databricks Actual Free Exam Q&As

Question 1

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

A. It can be used to connect to third party Bl cools. B. It can be used to make visualizations that can be shared with stakeholders. C. It can be used to produce dashboards that allow data exploration. D. It can be used to view metadata and data, as well as view/change permissions. E. It can be used to run UPDATE queries to update any tables in a database.

Discussion 0

Correct Answer: D Vote an answer

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

Question 2

A data analyst has been asked to count the number of customers in each region and has written the following query:

If there is a mistake in the query, which of the following describes the mistake?

A. The query is using count('). which will count all the customers in the customers table, no matter the region. B. The query is missing a GROUP BY region clause. C. There are no mistakes in the query. D. The query is using ORDER BY. which is not allowed in an aggregation. E. The query is selecting region but region should only occur in the ORDER BY clause.

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?

A. It is easy to migrate existing SQL queries to Databricks SQL B. It has increased customization capabilities C. It is more compatible with Spark's interpreters D. It is more performant than other SQL dialects E. It allows for the use of Photon's computation optimizations

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

In which circumstance will there be a substantial difference between the variable's mean and median values?

A. When the variable contains a lot of extreme outliers B. When the variable contains no outliers C. When the variable is of the boolean type D. When the variable is of the categorical type

Discussion 0

Correct Answer: A Vote an answer

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

Question 5

Which of the following approaches can be used to ingest data directly from cloud-based object storage?

A. Create an external table while specifying the DBFS storage path to FROM B. Create an external table while specifying the object storage path to FROM C. Create an external table while specifying the DBFS storage path to PATH D. It is not possible to directly ingest data from cloud-based object storage E. Create an external table while specifying the object storage path to LOCATION

Discussion 0

Correct Answer: E Vote an answer

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

Question 6

A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations and multiple counters. What must be completed before adding the data visualizations and counters to the dashboard?

A. A markdown-based tile must be added to the top of the dashboard displaying the dashboard's name. B. A SQL warehouse (formerly known as SQL endpoint) must be turned on and selected. C. The dashboard owner must also be the owner of the queries, data visualizations, and counters. D. All data visualizations and counters must be created using Queries.

Discussion 0

Correct Answer: D Vote an answer

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

Question 7

An analyst writes a query that contains a query parameter. They then add an area chart visualization to the query. While adding the area chart visualization to a dashboard, the analyst chooses "Dashboard Parameter" for the query parameter associated with the area chart.
Which of the following statements is true?

A. The area chart will convert to a Dashboard Parameter. B. The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use. C. The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards. D. The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter. E. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.

Discussion 0

Correct Answer: D Vote an answer

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

Databricks Certified Data Analyst Associate - Databricks-Certified-Data-Analyst-Associate Exam Practice Test