CPA Data Analytics 3

Question 1

What does ETL stand for in data analytics pipelines?

Accepted Answer

Extract, Transform, Load

Answer

ETL stands for Extract, Transform, Load — the three-phase process of pulling data from sources, reshaping it, and loading it into a target system.

Question 2

A data analyst wants to identify which rows in a pandas DataFrame contain null values. Which method should they use?

Accepted Answer

df.isnull()

Answer

df.isnull() returns a boolean DataFrame of the same shape where True indicates a missing (null) value.

Question 3

In statistics, what does a p-value less than 0.05 typically indicate?

Accepted Answer

The result is statistically significant at the 5% level

Answer

A p-value < 0.05 means there is less than a 5% probability of observing the result (or more extreme) if the null hypothesis were true, so we reject it.

Question 4

Which SQL keyword is used to remove duplicate rows from a query result?

Accepted Answer

DISTINCT

Answer

The DISTINCT keyword in a SELECT statement eliminates duplicate rows, returning only unique combinations of the selected columns.

Question 5

What type of data is represented by the Python list ['red', 'blue', 'green', 'red']?

Accepted Answer

Nominal categorical data

Answer

Colors are nominal categorical data — they represent distinct categories with no inherent order or numerical meaning.

(CPA) Certified Associate Programmer Practice Test

(CPA) Certified Associate Programmer Practice Test

CPA Data Analytics 3