AIS Final UPDATED Exam Questions and
CORRECT Answers
Understanding what big data means helps to know what types of questions can be fruitfully
examined using data. Big data differs from regular data in four ways, often called the "four
V's." Which of the following is not one of the four V's?
A. Velocity
B. Validity
C. Veracity
D. Variety - Correct Answer- B. Validity
Asking the right questions is the first step of an analytics mindset. Which of the following is
not part of the analytics mindset as defined by the accounting firm EY?
A. Interpret and share the results with stakeholders
B. Apply appropriate data analytic techniques
C. Exercise professional skepticism when using data
D. Extract, transform, and load relevant data - Correct Answer- C.,Exercise professional
skepticism when using data
Good questions should be "SMART." Which of the SMART objectives suggests that a
question should relate to the objectives of the organization or the situation under
consideration?
A. Measurable
,B. Specific
C. Achievable
D. Relevant - Correct Answer- D. Relevant
What is the definition of a question that is measurable?
A. A question that should be able to be answered and the answer should cause a decision
maker to act.
B. A question that is direct and focused to produce a meaningful answer.
C. A question that is amenable to data analysis: the inputs are measurable with data.
D. A question that has a defined time horizon for answering. - Correct Answer- C. A question
that is amenable to data analysis: the inputs are measurable with data.
Cindy, the controller at the organization, asks David, an accounts receivable clerk, "We want
to be able to collect all cash from customers who make purchases. Which customers were
more than 30 days late paying for their merchandise?" This question does the worst at
accomplishing which of the following SMART objectives?
A. Measurable
B. Specific
C. Relevant
D. Timely - Correct Answer- D. Timely
Check each example of structured data in the list below.
,A. HTML website data saved on the company's website
B. Photographs of all employees saved in the human resource database
C. Phone numbers of employees saved in a database
D. Customer addresses saved in a customer relation database - Correct Answer- C. Phone
numbers of employees saved in a database
D. Customer addresses saved in a customer relation database
Chunhua has been building financial forecasting models for the company for several years.
For each model, she saves all the data that could possibly be used in the model, even if she
doesn't use all the data in her finished model. She does not document anything about the
different items she has saved. When her intern, Minsuh pulls the data, she cannot understand
what all the fields mean. How would Minsuh most accurately describe the data?
A. The data has become a data swamp
B. The data is now dark data
C. The data contains metadata
D. The data is not part of the data warehouse - Correct Answer- A. The data has become a
data swamp
A data owner sends you an e-mail with a file to prepare for analysis. The file contains data
from multiple database tables all merged into a single file. There are multiple fields in the file
each separated by a "~" symbol. For fields that contain large amounts of text, the file contains
a "+" at the beginning and end of the text field. Indicate which of the following best describes
(1) the type of file the data owner sent, (2), what the "+" is called, and (3) what the "~" is
called.
, A. Flat file, delimiter, text qualifier
B. Relational database file, text qualifier, delimiter
C. Flat file, text qualifier, delimiter
D. Relational database file, delimiter, text qualifier - Correct Answer- C. Flat file, text
qualifier, delimiter
Check each item listed below that is part of the process for transforming data.
A. Validate data quality and verify data meets data requirements
B. Standardize, structure, and clean the data
C. Document the transformation process
D. Understand the data and the desired outcome - Correct Answer- A. Validate data quality
and verify data meets data requirements
B. Standardize, structure, and clean the data
C. Document the transformation process
D. Understand the data and the desired outcome
What do the letters in the acronym ETL stand for?
A. Enrich, Transform, and Load
B. Extract, Transcribe, and Launch
CORRECT Answers
Understanding what big data means helps to know what types of questions can be fruitfully
examined using data. Big data differs from regular data in four ways, often called the "four
V's." Which of the following is not one of the four V's?
A. Velocity
B. Validity
C. Veracity
D. Variety - Correct Answer- B. Validity
Asking the right questions is the first step of an analytics mindset. Which of the following is
not part of the analytics mindset as defined by the accounting firm EY?
A. Interpret and share the results with stakeholders
B. Apply appropriate data analytic techniques
C. Exercise professional skepticism when using data
D. Extract, transform, and load relevant data - Correct Answer- C.,Exercise professional
skepticism when using data
Good questions should be "SMART." Which of the SMART objectives suggests that a
question should relate to the objectives of the organization or the situation under
consideration?
A. Measurable
,B. Specific
C. Achievable
D. Relevant - Correct Answer- D. Relevant
What is the definition of a question that is measurable?
A. A question that should be able to be answered and the answer should cause a decision
maker to act.
B. A question that is direct and focused to produce a meaningful answer.
C. A question that is amenable to data analysis: the inputs are measurable with data.
D. A question that has a defined time horizon for answering. - Correct Answer- C. A question
that is amenable to data analysis: the inputs are measurable with data.
Cindy, the controller at the organization, asks David, an accounts receivable clerk, "We want
to be able to collect all cash from customers who make purchases. Which customers were
more than 30 days late paying for their merchandise?" This question does the worst at
accomplishing which of the following SMART objectives?
A. Measurable
B. Specific
C. Relevant
D. Timely - Correct Answer- D. Timely
Check each example of structured data in the list below.
,A. HTML website data saved on the company's website
B. Photographs of all employees saved in the human resource database
C. Phone numbers of employees saved in a database
D. Customer addresses saved in a customer relation database - Correct Answer- C. Phone
numbers of employees saved in a database
D. Customer addresses saved in a customer relation database
Chunhua has been building financial forecasting models for the company for several years.
For each model, she saves all the data that could possibly be used in the model, even if she
doesn't use all the data in her finished model. She does not document anything about the
different items she has saved. When her intern, Minsuh pulls the data, she cannot understand
what all the fields mean. How would Minsuh most accurately describe the data?
A. The data has become a data swamp
B. The data is now dark data
C. The data contains metadata
D. The data is not part of the data warehouse - Correct Answer- A. The data has become a
data swamp
A data owner sends you an e-mail with a file to prepare for analysis. The file contains data
from multiple database tables all merged into a single file. There are multiple fields in the file
each separated by a "~" symbol. For fields that contain large amounts of text, the file contains
a "+" at the beginning and end of the text field. Indicate which of the following best describes
(1) the type of file the data owner sent, (2), what the "+" is called, and (3) what the "~" is
called.
, A. Flat file, delimiter, text qualifier
B. Relational database file, text qualifier, delimiter
C. Flat file, text qualifier, delimiter
D. Relational database file, delimiter, text qualifier - Correct Answer- C. Flat file, text
qualifier, delimiter
Check each item listed below that is part of the process for transforming data.
A. Validate data quality and verify data meets data requirements
B. Standardize, structure, and clean the data
C. Document the transformation process
D. Understand the data and the desired outcome - Correct Answer- A. Validate data quality
and verify data meets data requirements
B. Standardize, structure, and clean the data
C. Document the transformation process
D. Understand the data and the desired outcome
What do the letters in the acronym ETL stand for?
A. Enrich, Transform, and Load
B. Extract, Transcribe, and Launch
