100% Free Databricks Databricks-Certified-Data-Analyst-Associate Practice Test Questions

Question 1

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 : Delta Lake

B : Databricks Notebooks

C : Tableau

D : Databricks Machine Learning

E : Databricks SQL

Answer: E

Question 2

Which of the following statements describes descriptive statistics?

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 underlyingdistribution 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 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 : Delta Lake

B : Databricks Notebooks

C : Tableau

D : Databricks Machine Learning

E : Databricks SQL

Answer: E

Question 4

In which of the following situations should a data analyst use higher-order functions?

A : When custom logic needs to be applied to simple, unnested data

B : When custom logic needs to be converted to Python-native code

C : When custom logic needs to be applied at scale to array data objects

D : When built-in functions are taking too long to perform tasks

E : When built-in functions need to run through the Catalyst Optimizer

Answer: C

Question 5