Question 1

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?

Options :

A : Separate endpoints for each section

B : Separate queries for each section

C : Markdown-based text boxes

D : Direct text written into the dashboard in editing mode

E : Separate color palettes for each section

Answer: C

Question 2

Which of the following statements describes descriptive statistics?

Options :

A : A branch of statistics that uses summary statistics to quantitatively describe and summarize data

B : A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.

C : A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values

D : A branch of statistics that uses summary statistics to categorically describe and summarize data

E : A branch of statistics that uses quantitative variables that must take on an uncountable set of values.

Answer: A

Question 3

A data analyst runs the following command:

SELECT age, country

FROM my_table

WHERE age >= 75 AND country = 'canada';

Which of the following tables represents the output of the above command?

Options :

A :

B :

C :

D :

E :

Answer: E

Question 4

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?

Options :

A : Delta Lake

B : Databricks Notebooks

C : Tableau

D : Databricks Machine Learning

E : Databricks SQL

Answer: E

Question 5

Which statement describes descriptive statistics?

Options :

A : A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.

B : A branch of statistics that uses summary statistics to categorically describe and summarize data.

C : A branch of statistics that uses summary statistics to quantitatively describe and summarize data.

D : A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.

Answer: C

Free Databricks-Certified-Data-Analyst-Associate Mock Exam – Practice Online Confidently

Buying Options: