Question 1

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

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

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 4

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 5

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

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

Buying Options: