Question 1

Unlike the IMPACT cycle,requesting data is not an iterative process.

Accepted Answer

A) True 
 B)False

Question 2

The purpose of transforming data is:

Accepted Answer

A)  To validate the data for completeness and integrity 
B)  To load the data into the appropriate tool for analysis 
C)  To identify and obtain the data from the appropriate source 
D)  To identify which approach to data analytics should be used

Question 3

In order to obtain the right data,it is important to have a firm grasp of what data is available and how it is stored.

Accepted Answer

A) True 
 B)False

Question 4

Removing headings or subtotals from data is an example of which of the following?

Accepted Answer

A)  Validating the data for completeness 
B)  Validating the data for integrity 
C)  Cleaning the data 
D)  Obtaining the data

Question 5

Data normalization can reduce data redundancy and improve data integrity.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  Systems Query Language. 
B)  Systems Question Language. 
C)  Structured Question Language. 
D)  Structured Query Language.

Question 7

Which of the following best describes the purpose of relational databases?

Accepted Answer

A)  To ensure that business rules are enforced 
B)  To increase information redundancy in the organization 
C)  To provide business information to data analysts 
D)  To support business processes across the organization

Question 8

A composite primary key is made up of the three or more primary keys in the tables that it is linking.

Accepted Answer

A) True 
 B)False

Question 9

________ is the metadata that describes each attribute in a database.

Accepted Answer

A)  Relational database 
B)  Data dictionary 
C)  Descriptive attributes 
D)  Flat file

Question 10

Assume that you will be up for a promotion next month and you'd like to analyze a recently acquired database to show off your data analytic skills.After identifying the goal of your data analysis,using the first step of the IMPACT cycle,what steps would you take if you have direct access to the database?

Accepted Answer

The answer of Assume that you will be up for...

Question 11

Mastering the data can also be described via the ETL process.The ETL process stands for:

Accepted Answer

A)  Extract, total, and load data. 
B)  Extract, transform, and load data. 
C)  Enter, transform, and load data. 
D)  Enter, total, and load data.

Question 12

A template can make communication easier between data requestor and provider.

Accepted Answer

A) True 
 B)False

Question 13

Chapter 2 describes,the various ways in which data can be stored for differing purposes.Describe the two ways data can be organized and the purpose for each organizational structure.

Accepted Answer

The answer of Chapter 2 describes,the various ways in which...

Question 14

Mastering the data requires a firm understanding of what data is available to you and where it is stored,as well as being skilled in the process of extracting,transforming,and loading (ETL).

Accepted Answer

A) True 
 B)False

Question 15

Which of the following best describes the purpose of a primary key?

Accepted Answer

A)  To ensure that each row in the table is unique 
B)  To create the relationship between two tables 
C)  To provide business information, but are not required to build a database 
D)  To support business processes across the organization

Exam 2: Data Preparation and Cleaning

Unlike the IMPACT cycle,requesting data is not an iterative process.

The purpose of transforming data is:

In order to obtain the right data,it is important to have a firm grasp of what data is available and how it is stored.

Removing headings or subtotals from data is an example of which of the following?

Data normalization can reduce data redundancy and improve data integrity.

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

Which of the following best describes the purpose of relational databases?

A composite primary key is made up of the three or more primary keys in the tables that it is linking.

________ is the metadata that describes each attribute in a database.

Mastering the data can also be described via the ETL process.The ETL process stands for:

A template can make communication easier between data requestor and provider.

Chapter 2 describes,the various ways in which data can be stored for differing purposes.Describe the two ways data can be organized and the purpose for each organizational structure.

Mastering the data requires a firm understanding of what data is available to you and where it is stored,as well as being skilled in the process of extracting,transforming,and loading (ETL).

Which of the following best describes the purpose of a primary key?