Question 1

At which step of the ETL process should you try to answer the question "What tools will be used to perform data analytic tests or procedures and why?"

Accepted Answer

A)  Step 1: Determine the purpose and scope of the data request. 
B)  Step 2: Obtain the data. 
C)  Step 3 or 4: Transformation. 
D)  Step 5: Loading the data for data analysis. 
A)  Step 1: Determine the purpose and scope of the data request. 
B)  Step 2: Obtain the data. 
C)  Step 3 or 4: Transformation. 
D)  Step 5: Loading the data for data analysis. B

Question 2

Assume that you have just completed the extraction process on a data set.As you begin validating the data for completeness and integrity,you notice an error.Describe the steps you might take to determine the source of an error.

Accepted Answer

Answers will vary! A potential answer might include:
If an error is found,depending on the size of the dataset,you may be able to easily find the missing or erroneous data by scanning it with your eyes.However,if the dataset is large,or if the error is difficult to find,it may be easiest to go back to the extraction and examine how the data was extracted,fix any errors in the SQL code,and re-run the extraction.

Question 3

The T in IMPACT Cycle represents transfer.

Accepted Answer

A) True 
 B)False  False

Question 4

If the extraction and transformation steps have been done correctly,the loading part of the ETL process should be the simplest step.

Accepted Answer

A) True 
 B)False

Question 5

Taylor is a new staff accountant for a fortune 100 company.After hearing that she just successfully completed an Accounting Data Analytics course,her boss said,"Get me a listing of all our deadbeat customer,so I can cut off their credit." After asking clarifying questions,Taylor was able to determine that root request was "Which customer,with a credit limit over $10,000,have more than $5,000 outstanding for more than 90 days at the prior quarter's end?" Use the ETL Techniques briefly describe the process Taylor with have to complete to answer her boss' question.(Assume that Taylor does not have direct access the data,data will export into an Excel file,and she will complete the analysis with an Excel Pivot Table.)

Accepted Answer

Answers will vary but should include som

Question 6

The purpose of loading 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 
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 7

Which of the following best exemplifies a way that data will need to be cleaned after extraction and validation?

Accepted Answer

A)  Remove headings and subtotals 
B)  Validate date/time fields 
C)  Remove trailing zeroes 
D)  Compare string limits for text fields 
A)  Remove headings and subtotals 
B)  Validate date/time fields 
C)  Remove trailing zeroes 
D)  Compare string limits for text fields

Question 8

When obtaining the data yourself,you should do all of the following before you begin except:

Accepted Answer

A)  Identify the tables that contain the information you need. 
B)  Identify which attributes specifically hold the information you need in each table. 
C)  Identify how those tables are related to each other. 
D)  Identify any errors or issues from the extraction. 
A)  Identify the tables that contain the information you need. 
B)  Identify which attributes specifically hold the information you need in each table. 
C)  Identify how those tables are related to each other. 
D)  Identify any errors or issues from the extraction.

Question 9

The E in IMPACT Cycle represents existence.

Accepted Answer

A) True 
 B)False

Question 10

All of the following are benefits of using a normalized relational database except:

Accepted Answer

A)  Completeness. 
B)  No redundancy. 
C)  Business rules are enforced. 
D)  Data is stored in one place. 
A)  Completeness. 
B)  No redundancy. 
C)  Business rules are enforced. 
D)  Data is stored in one place.

Question 11

A foreign key is an attribute that is required to exist in each table of a relational database and serves as the unique identifier for each record in a table.

Accepted Answer

A) True 
 B)False

Question 12

A data dictionary is paramount in helping data analysts do which of the following?

Accepted Answer

A)  Maintain databases. 
B)  Identify the data they need to use. 
C)  Communicating insights. 
D)  Track outcomes. 
A)  Maintain databases. 
B)  Identify the data they need to use. 
C)  Communicating insights. 
D)  Track outcomes.

Question 13

Comparing descriptive statistics for numeric fields within the 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 
A)  Validating the data for completeness 
B)  Validating the data for integrity 
C)  Cleaning the data 
D)  Obtaining the data

Question 14

All of the following are included in the five steps of the ETL process except:

Accepted Answer

A)  Determine the purpose and scope of the data request 
B)  Obtain the data 
C)  Validate the data for completeness and integrity 
D)  Scrub the data 
A)  Determine the purpose and scope of the data request 
B)  Obtain the data 
C)  Validate the data for completeness and integrity 
D)  Scrub the data

Question 15

Correcting inconsistencies across 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 
A)  Validating the data for completeness 
B)  Validating the data for integrity 
C)  Cleaning the data 
D)  Obtaining the data

Question 16

Formatting negative numbers is an example of cleaning the data.

Accepted Answer

A) True 
 B)False

Question 17

Once you have extracted the data of interest,it will need to be validated for completeness and existence.

Accepted Answer

A) True 
 B)False

Question 18

The purpose of extracting 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 
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 19

Define and compare a primary key,a foreign key,and non-key attribute.

Accepted Answer

Answers will vary!
• The purpose of the

Question 20

When using [EmployeeID] as the unique identifier of the Employee table,[EmployeeID] is an example of which of the following:

Accepted Answer

A)  Foreign key 
B)  Composite key 
C)  Primary key 
D)  Key attribute 
A)  Foreign key 
B)  Composite key 
C)  Primary key 
D)  Key attribute

At which step of the ETL process should you try to answer the question "What tools will be used to perform data analytic tests or procedures and why?"

Assume that you have just completed the extraction process on a data set.As you begin validating the data for completeness and integrity,you notice an error.Describe the steps you might take to determine the source of an error.

The T in IMPACT Cycle represents transfer.

If the extraction and transformation steps have been done correctly,the loading part of the ETL process should be the simplest step.

The purpose of loading data is:

Which of the following best exemplifies a way that data will need to be cleaned after extraction and validation?

When obtaining the data yourself,you should do all of the following before you begin except:

The E in IMPACT Cycle represents existence.

All of the following are benefits of using a normalized relational database except:

A foreign key is an attribute that is required to exist in each table of a relational database and serves as the unique identifier for each record in a table.

A data dictionary is paramount in helping data analysts do which of the following?

Comparing descriptive statistics for numeric fields within the data is an example of which of the following?

All of the following are included in the five steps of the ETL process except:

Correcting inconsistencies across data is an example of which of the following?

Formatting negative numbers is an example of cleaning the data.

Once you have extracted the data of interest,it will need to be validated for completeness and existence.

The purpose of extracting data is:

Define and compare a primary key,a foreign key,and non-key attribute.

When using [EmployeeID] as the unique identifier of the Employee table,[EmployeeID] is an example of which of the following:

Data Analytics in Accounting and Business

Modeling and Evaluation: Going From Defining Business Problems and Data Understanding to Analyzing Data and Answering Questions

Visualizations: Using Visualizations and Summaries to Share Results

The Modern Audit and Continuous Auditing

Audit Data Analytics

Generating Key Performance Indicators

Using Financial Statement Data

Filters

Exam 2: Data Preparation and Cleaning

At which step of the ETL process should you try to answer the question "What tools will be used to perform data analytic tests or procedures and why?"

Assume that you have just completed the extraction process on a data set.As you begin validating the data for completeness and integrity,you notice an error.Describe the steps you might take to determine the source of an error.

The T in IMPACT Cycle represents transfer.

If the extraction and transformation steps have been done correctly,the loading part of the ETL process should be the simplest step.

The purpose of loading data is:

Which of the following best exemplifies a way that data will need to be cleaned after extraction and validation?

When obtaining the data yourself,you should do all of the following before you begin except:

The E in IMPACT Cycle represents existence.

All of the following are benefits of using a normalized relational database except:

A foreign key is an attribute that is required to exist in each table of a relational database and serves as the unique identifier for each record in a table.

A data dictionary is paramount in helping data analysts do which of the following?

Comparing descriptive statistics for numeric fields within the data is an example of which of the following?

All of the following are included in the five steps of the ETL process except:

Correcting inconsistencies across data is an example of which of the following?

Formatting negative numbers is an example of cleaning the data.

Once you have extracted the data of interest,it will need to be validated for completeness and existence.

The purpose of extracting data is:

Define and compare a primary key,a foreign key,and non-key attribute.

When using [EmployeeID] as the unique identifier of the Employee table,[EmployeeID] is an example of which of the following:

Data Analytics in Accounting and Business

Modeling and Evaluation: Going From Defining Business Problems and Data Understanding to Analyzing Data and Answering Questions

Visualizations: Using Visualizations and Summaries to Share Results

The Modern Audit and Continuous Auditing

Audit Data Analytics

Generating Key Performance Indicators

Using Financial Statement Data

Filters