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

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

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 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 business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person. Which of the following code blocks will accomplish this task?

Options :

A :

B :

C :

D :

E :

Answer: D

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

Buying Options: