Question 1

Which of the following best describes the purpose of a foreign 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 
D)  To support business processes across the organization 
A)  To ensure that each row in the table is unique 
B)  To create the relationship between two tables 
C)  To provide business information 
D)  To support business processes across the organization

Question 2

Which of the following best describes the purpose of a non-key attribute?

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 
D)  To support business processes across the organization 
A)  To ensure that each row in the table is unique 
B)  To create the relationship between two tables 
C)  To provide business information 
D)  To support business processes across the organization

Question 3

Comparing the number of records that were extracted to the number of records in the source database is an example of validating the data for integrity.

Accepted Answer

A) True 
 B)False

Question 4

A flat file is a means of storing data in one place,such as in an Excel spreadsheet,as opposed to storing the data in multiple tables,such as in a relational database.

Accepted Answer

A) True 
 B)False

Question 5

After obtaining the data and determining the purpose and scope of the data request,the next step is to validate the data.

Accepted Answer

A) True 
 B)False

Question 6

Much like the IMPACT cycle,requesting data is often an iterative process.

Accepted Answer

A) True 
 B)False

Question 7

A foreign key is an attribute that exists in relational databases in order to carry out the relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 8

A primary 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 9

Validating date/time 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 10

Formatting negative numbers in 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 11

At which step of the ETL process should you try to answer the question "What other information will impact the nature,timing and extent of the data analysis?"

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.

Question 12

At which step of the ETL process should you try to answer the question "Where are the data located in the financial or other related systems?"

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.

Question 13

Descriptive attributes are attributes that exist in relational databases that are neither primary nor foreign keys.

Accepted Answer

A) True 
 B)False

Question 14

All of the following are Audit Data Standards (ADS)developed by the American Institute of Certified Accountants except:

Accepted Answer

A)  Investments subledger standards 
B)  General Ledger standards 
C)  Procure-to-Pay subledger standards 
D)  Order-to-Cash subledger standards 
A)  Investments subledger standards 
B)  General Ledger standards 
C)  Procure-to-Pay subledger standards 
D)  Order-to-Cash subledger standards

Question 15

Comparing the number of records 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 16

The L in IMPACT Cycle represents loading.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is most likely to be the primary key in an Employee table?

Accepted Answer

A)  Employee ID 
B)  Employee Social Security Number 
C)  Employee Name 
D)  Employee Type 
A)  Employee ID 
B)  Employee Social Security Number 
C)  Employee Name 
D)  Employee Type

Question 18

A data dictionary is paramount in helping database administrators 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 19

Removing leading zeroes and non-printable characters from 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 20

At which step of the ETL process should you try to answer the question "What business problem will the data address?"

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.

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

Which of the following best describes the purpose of a non-key attribute?

Comparing the number of records that were extracted to the number of records in the source database is an example of validating the data for integrity.

A flat file is a means of storing data in one place,such as in an Excel spreadsheet,as opposed to storing the data in multiple tables,such as in a relational database.

After obtaining the data and determining the purpose and scope of the data request,the next step is to validate the data.

Much like the IMPACT cycle,requesting data is often an iterative process.

A foreign key is an attribute that exists in relational databases in order to carry out the relationship between two tables.

A primary 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.

Validating date/time fields within the data is an example of which of the following?

Formatting negative numbers in the data is an example of which of the following?

At which step of the ETL process should you try to answer the question "What other information will impact the nature,timing and extent of the data analysis?"

At which step of the ETL process should you try to answer the question "Where are the data located in the financial or other related systems?"

Descriptive attributes are attributes that exist in relational databases that are neither primary nor foreign keys.

All of the following are Audit Data Standards (ADS)developed by the American Institute of Certified Accountants except:

Comparing the number of records within the data is an example of which of the following?

The L in IMPACT Cycle represents loading.

Which of the following is most likely to be the primary key in an Employee table?

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

Removing leading zeroes and non-printable characters from the data is an example of which of the following?

At which step of the ETL process should you try to answer the question "What business problem will the data address?"

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

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

Which of the following best describes the purpose of a non-key attribute?

Comparing the number of records that were extracted to the number of records in the source database is an example of validating the data for integrity.

A flat file is a means of storing data in one place,such as in an Excel spreadsheet,as opposed to storing the data in multiple tables,such as in a relational database.

After obtaining the data and determining the purpose and scope of the data request,the next step is to validate the data.

Much like the IMPACT cycle,requesting data is often an iterative process.

A foreign key is an attribute that exists in relational databases in order to carry out the relationship between two tables.

A primary 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.

Validating date/time fields within the data is an example of which of the following?

Formatting negative numbers in the data is an example of which of the following?

At which step of the ETL process should you try to answer the question "What other information will impact the nature,timing and extent of the data analysis?"

At which step of the ETL process should you try to answer the question "Where are the data located in the financial or other related systems?"

Descriptive attributes are attributes that exist in relational databases that are neither primary nor foreign keys.

All of the following are Audit Data Standards (ADS)developed by the American Institute of Certified Accountants except:

Comparing the number of records within the data is an example of which of the following?

The L in IMPACT Cycle represents loading.

Which of the following is most likely to be the primary key in an Employee table?

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

Removing leading zeroes and non-printable characters from the data is an example of which of the following?

At which step of the ETL process should you try to answer the question "What business problem will the data address?"

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