ACG 4401 CHAPTER 5 QUIZ QUESTIONS WITH CORRECT ANSWERS LATEST UPDATE 2026
Unstructured data internal or external to the organization is usually gathered and stored in which of
the following?
A) Data dictionary
B) Data Lake
C) Data Mart
D) Data Warehouse - Answers B
Which of the following items would be the best primary key for a table containing information about
customers?
A) Customer ID
B) Customer full name
C) Customer phone number
D) Customer email address - Answers A
Which of the following characters would be the best delimiter (the delimiter is listed between the
quotes)?
A) ","
B) "@"
C) "|"
D) All of the above - Answers C
An online sales company designed a program to evaluate customer purchases. After each purchase,
the program analyzes which product the customer is most likely to buy next and e-mails the customer
a coupon for a discount on this new product. What type of analytic is this an example of?
A) Descriptive analytics
B) Diagnostic Analytics
C) Predictive Analytics
D) Prescriptive Analytics - Answers D
When sharing the results of an analysis, which of the following is NOT a key principle to follow?
A) Simplify the presentation of data
B) Present the visualization in a timely manner
C) Ethically represent the data
D) Emphasize what is important - Answers B
Which of the steps of an analytics mindset is the most difficult to automate?
A) Ask the right questions
B) Extract, Transform, and Load relevant data
C) Apply appropriate data analytics techniques
D) Interpret and share the results with stakeholder - Answers A
All of the following characteristics of data are important in distinguishing big data from regular data
EXCEPT:
A) Velocity
B) Variety
C) Visualization
D) Volume - Answers C
You are given an extract of one field from a database. The field has the value "11815 N. Diamond Dr."
Which type of data is contained in this field?
A) Structured Data
B) Unstructured data
C) Semi-structed data
D) None of the above - Answers A
Programming a computer program to automatically perform a task previously performed by a human
is an example of which of the following?
A) Warehousing Data
B) The ETL process
C) Establishing SMART objectives
D) Robotic process automation - Answers D
Good questions for data adhere to all of the following principles EXCEPT:
A) Accurate
Unstructured data internal or external to the organization is usually gathered and stored in which of
the following?
A) Data dictionary
B) Data Lake
C) Data Mart
D) Data Warehouse - Answers B
Which of the following items would be the best primary key for a table containing information about
customers?
A) Customer ID
B) Customer full name
C) Customer phone number
D) Customer email address - Answers A
Which of the following characters would be the best delimiter (the delimiter is listed between the
quotes)?
A) ","
B) "@"
C) "|"
D) All of the above - Answers C
An online sales company designed a program to evaluate customer purchases. After each purchase,
the program analyzes which product the customer is most likely to buy next and e-mails the customer
a coupon for a discount on this new product. What type of analytic is this an example of?
A) Descriptive analytics
B) Diagnostic Analytics
C) Predictive Analytics
D) Prescriptive Analytics - Answers D
When sharing the results of an analysis, which of the following is NOT a key principle to follow?
A) Simplify the presentation of data
B) Present the visualization in a timely manner
C) Ethically represent the data
D) Emphasize what is important - Answers B
Which of the steps of an analytics mindset is the most difficult to automate?
A) Ask the right questions
B) Extract, Transform, and Load relevant data
C) Apply appropriate data analytics techniques
D) Interpret and share the results with stakeholder - Answers A
All of the following characteristics of data are important in distinguishing big data from regular data
EXCEPT:
A) Velocity
B) Variety
C) Visualization
D) Volume - Answers C
You are given an extract of one field from a database. The field has the value "11815 N. Diamond Dr."
Which type of data is contained in this field?
A) Structured Data
B) Unstructured data
C) Semi-structed data
D) None of the above - Answers A
Programming a computer program to automatically perform a task previously performed by a human
is an example of which of the following?
A) Warehousing Data
B) The ETL process
C) Establishing SMART objectives
D) Robotic process automation - Answers D
Good questions for data adhere to all of the following principles EXCEPT:
A) Accurate
