Answers
Asking the right questions involves questions that are
a. macro (big picture) oriented
b. measurable
c. mindful
d. motivated - CORRECT ANSWER✔✔b. measurable
A collection of structure, semi-structured, and unstructured data stored in a single location is
called a _______.
a. data lake
b. data warehouse
c. database
d. metadata - CORRECT ANSWER✔✔a. data lake
______ is a process of changing data into a format that another program can use.
a. visualizing
b. delimiting
c. transforming
d. cleaning - CORRECT ANSWER✔✔c. transforming
A delimiter is _______.
a. a data element that separates field values
b. a data element that identifies numeric values
,c. a data element that allows large text sizes
d. a data element used in the data dictionary - CORRECT ANSWER✔✔a. a data element that
separates field values
Using robotic process automation is best for tasks that are _________.
a. changing
b. repetitive
c. interesting
d. complex - CORRECT ANSWER✔✔b. repetitive
Following the creation of an ETL process, the following action should be performed.
a. update the data dictionary
b. transform the data
c. create structured data
d. remove commas - CORRECT ANSWER✔✔a. update the data dictionary
To answer the question of "What should be done" one would apply ___________.
a. prescriptive analytics
b. predictive analytics
c. descriptive analytics
d. diagnostic analytics - CORRECT ANSWER✔✔a. prescriptive analytics
According to the EY Foundation, over which data analytic techniques should accountants gain
mastery?
a. correlation, regression
b. cluster analysis, inferential statistics
c. querying trends, forecasting
, d. data mining, artificial intelligence - CORRECT ANSWER✔✔c. querying trends, forecasting
The process of translating complex data analyses into easier to understand terms is _______.
a. data visualization
b. data storytelling
c. data dashboard
d. statistical analysis - CORRECT ANSWER✔✔b. data storytelling
All of the following controls for online entry of a sales order would be useful except
a. check digit verification on the dollar amount of the order.
b. field check on the customer ID and dollar amount of the order.
c. concurrent update control.
d. validity check on the inventory item numbers. - CORRECT ANSWER✔✔a. check digit
verification on the dollar amount of the order.
A payroll clerk accidentally entered an employee's hours worked for the week as 380 instead of
38. The data entry control that would best prevent this error would be
a. batch total reconciliation.
b. a limit check.
c. Closed-loop verification
d. a check digit. - CORRECT ANSWER✔✔b. a limit check.
When opening an Excel file, Sonja received a message saying that the file is locked for editing.
This is happening because
a. concurrent update controls
b. there is no problem. Sonja is editing the file
c. Sonja opened the file as read-only.