1. Which of the following best describes the profiling approach to data analytics?

A. An attempt to predict a relationship between two data items.

B. An attempt to discover associations between individuals based on transactions involving them.

C. An attempt to reduce the amount of information that needs to be considered to focus on the most critical items.

D. An attempt to characterize the typical behavior of an individual, group or population by generating summary statistics about the data.

2. Which of the following best describes the goal of developing an analytics mindset:

A. perform basic analysis to understand the quality of the underlying data and its ability to address the business question

B. comprehend the process needed to clean and prepare the data before analysis

C. recognize when and how data analytics can address business questions

D. recognize what is meant by data quality, be it completeness, reliability or validity

3. The objective of data extraction is:

A. To identify and obtain the data from the appropriate source

B. To validate the data for completeness and integrity

C. To identify which approach to data analytics should be used

D. To load the data into the appropriate tool for analysis

4. Relational databases help to reduce redundant data. Which of the following is NOT a reason to reduce redundant data?

A. It is expensive

B. It is easier to perform analysis in spreadsheets

C. It takes up unnecessary space

D. It increases the risk of data-entry errors

5. There are a variety of methods that you could take to retrieve the data, including SQL. What does SQL stand for?

A. Systems Query Language.

B. Systems Question Language.

C. Structured Question Language.

D. Structured Query Language.

6. The objective of data transformation is:

A. To load the data into the appropriate tool for analysis

B. To identify and obtain the data from the appropriate source

C. To identify which approach to data analytics should be used

D. To validate the data for completeness and integrity