Question 1

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

Options :

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 2

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 3

A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication. Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?

Options :

A :

CREATE TABLE table_silver AS SELECT DISTINCT * FROM table_bronze;

B :

CREATE TABLE table_silver AS INSERT * FROM table_bronze;

C :

CREATE TABLE table_silver AS MERGE DEDUPLICATE * FROM table_bronze;

D :

INSERT INTO TABLE table_silver SELECT * FROM table_bronze;

E :

INSERT OVERWRITE TABLE table_silver SELECT * FROM table_bronze;

Answer: A

Question 4

A data analyst creates a Databricks SQL Query where the result set has the following schema: region STRING number_of_customer INT When the analyst clicks on the "Add visualization" button on the SQL Editor page, which of the following types of visualizations will be selected by default?

Options :

A : Violin Chart

B : Line Chart

C : Bar Chart

D : Histogram

E : There is no default. The user must choose a visualization type.

Answer: C

Question 5

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

Higher Test Marks with Free Online Databricks-Certified-Data-Analyst-Associate Exam Practice

Buying Options: