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 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 3

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

Question 4

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 5

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

Options :

A : When the variable is of the categorical type

B : When the variable is of the boolean type

C : When the variable contains no outliers

D : When the variable contains a lot of extreme outliers

Answer: D

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

Buying Options: