An analyst is explaining the company’s financial systems and reporting tools to a new coworker. Which of the following data quality dimensions are the most important? (Select three).

A. Data formatting

B. Data accuracy

C. Data maturity

D. Data field

E. Data completeness

F. Data consistency

G. Data diversity

H. Data deletion

Given the following data table:

Which of the following are appropriate reasons to undertake data cleansing? (Select two).

A. Non-parametric data

B. Missing data

C. Duplicate data

D. Invalid data

E. Redundant data

F. Normalized data

When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.

What term describes this action?

A. Filtering.

B. Normalization.

C. Transposition.

D. Aggregation.

Which of the following best describes how discrete data differs from continuous data?

A. Discrete data cannot create a sloped line.

B. Discrete data can only be a finite number of values.

C. Discrete data can have decimal points.

D. Discrete data applies only to numbers.

Given a product sales table, which of the following aggregate functions are suitable for retrieving the total quantity sold by each employee? (Select two).

A. MAX

B. SELECT

C. HAVING

D. GROUP BY

E. ORDER BY

F. SUM

A company notifies its employees that emails will be automatically moved to a cloud-based server in 180 days. Which of the following describes this concept?

A. Data deletion

B. Data processing

C. Data retention

D. Data constraints

Which of the following data analysis tools increases the efficiency of data visualizations?

A. SQL

B. Microsoft Excel

C. SAS

D. RapidMiner

A data set has the following values:

Which of the following is the best reason for cleansing the data?

A. Invalid data

B. Redundant data

C. Data outliers

D. Missing data

Given the diagram below:

Which of the following types of sampling is depicted in the image?

A. Stratified

B. Random

C. Cluster

D. Systematic

A data analyst must fulfil a request for information that is needed weekly and should be automatically emailed to a specific set of users. Which of the following types of reports should the analyst recommend?

A. A self-service report

B. A research report

C. An ad hoc report

D. An operational report

An analyst is reporting on the average income for a county and is reviewing the following data:

Which of the following is the reason the analyst would need to cleanse the data in this data set?

A. Data completeness

B. Data outliers

C. Duplicate data

D. Missing values

A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

A. Systematic sampling

B. Convenience sampling

C. Stratified sampling

D. Random sampling