Question 1

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 2

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 3

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 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 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 : IBar Chart

D : Histogram

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

Answer: C

Confidently Practice Online with Free Databricks-Certified-Data-Analyst-Associate Exam Cram

Buying Options: