Data analytics and security Questions and Answer 2024
Understand 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 Vs. which of the following is not one of the four V's? ** Answ** Validilty
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 ** Answ**
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? ** Answ** relevant
What is the definition of a question that is measurable? ** Answ** A question that is
amenable to data analysis: the inputs are measurable with data.
Check each example of structured date in the list below ** Answ** Phone numbers,
customer addresses
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. ** Answ** Flat file, text qualifier, delimiter
Check each items listed below that is part of the process for transforming data **
Answ** 1. Understand the data and the desired out come
2. Standardize, structure, and clean the data
3. Validate data quality and verify data meets data requirements
4. Document the transformation process
You are given an extract of one field from a database. The girl has the value "11815 N.
Diamond Dr." which type of data is contained in this field? ** Answ** Structured data
An analytic what answers the question, what might happen in the future is best
described as which of the following ** Answ** Predictive analytics
Ami told created a dashboard showing key metrics about the accounts payable process
at her organization. The dashboard showed various metrics including: the total number
of vendors, the amounts saved by paying vendors only early, and the number of late
payments to endors. Which of the following is best describes the type of analytics in the
dashboard ** Answ** Descriptive Analytics
Contact for help with assignments and revision materials
, An analytic that answers the question, "why did this happen" is best described as which
of the following ** Answ** Diagnostic analytic
At a local supermarket, a data analyst used video data of the parking lots to identify the
times when customer carts are most often left out in the parking lot. The analyst then
designed the scheduling program to schedule more employee baggers to work during
the time when shopping carts are left outside. The data analyst used what type of
analytics in this scenario? ** Answ** Prescriptive analytics
Check the likely benefits of using robotic process automation among the four options
below ** Answ** RPA performs tasks faster than a human.
RPA will make fewer mistakes for rules based tasks than a human.
When accountants build bots to help them with the tasks of their jobs, what description
best examples the type bot they would build ** Answ** A computer program that is
designed to perform a specific task
Computer software that can be programmed to automatically perform tasks across
applications just as humans do is called ** Answ** RPA software
If analytics are performed well, it is certain that ** Answ** None of these are
necessarily certain.
__________ is the process of changing data into format that another program can use
** Answ** Transforming
A collection of structure, semi-structure, and unstructured date stored in a single
location is called a ** Answ** Data lake
A delimiter is ** Answ** a data element that separates field values
Using RPA is best for tasks that are ** Answ** Repetitive
To answer the of "what should be done," one would apply ** Answ** Prescriptive
analytics
According to the EY foundation, over which data analytic techniques should
accountants gain mastery? ** Answ** Querying, trends, forecasting
A company has collected performance data (machine movements, units produced,
quality measures) from a production machine for several months. Each day the
company has increased speed by 0.05 percent. The company plans on building a model
to estimate the machine's quality measures assuming an additional 2% increase in
machine speed. Which type of analytic will be performed? ** Answ** Predictive
analytics
Contact for help with assignments and revision materials
Understand 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 Vs. which of the following is not one of the four V's? ** Answ** Validilty
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 ** Answ**
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? ** Answ** relevant
What is the definition of a question that is measurable? ** Answ** A question that is
amenable to data analysis: the inputs are measurable with data.
Check each example of structured date in the list below ** Answ** Phone numbers,
customer addresses
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. ** Answ** Flat file, text qualifier, delimiter
Check each items listed below that is part of the process for transforming data **
Answ** 1. Understand the data and the desired out come
2. Standardize, structure, and clean the data
3. Validate data quality and verify data meets data requirements
4. Document the transformation process
You are given an extract of one field from a database. The girl has the value "11815 N.
Diamond Dr." which type of data is contained in this field? ** Answ** Structured data
An analytic what answers the question, what might happen in the future is best
described as which of the following ** Answ** Predictive analytics
Ami told created a dashboard showing key metrics about the accounts payable process
at her organization. The dashboard showed various metrics including: the total number
of vendors, the amounts saved by paying vendors only early, and the number of late
payments to endors. Which of the following is best describes the type of analytics in the
dashboard ** Answ** Descriptive Analytics
Contact for help with assignments and revision materials
, An analytic that answers the question, "why did this happen" is best described as which
of the following ** Answ** Diagnostic analytic
At a local supermarket, a data analyst used video data of the parking lots to identify the
times when customer carts are most often left out in the parking lot. The analyst then
designed the scheduling program to schedule more employee baggers to work during
the time when shopping carts are left outside. The data analyst used what type of
analytics in this scenario? ** Answ** Prescriptive analytics
Check the likely benefits of using robotic process automation among the four options
below ** Answ** RPA performs tasks faster than a human.
RPA will make fewer mistakes for rules based tasks than a human.
When accountants build bots to help them with the tasks of their jobs, what description
best examples the type bot they would build ** Answ** A computer program that is
designed to perform a specific task
Computer software that can be programmed to automatically perform tasks across
applications just as humans do is called ** Answ** RPA software
If analytics are performed well, it is certain that ** Answ** None of these are
necessarily certain.
__________ is the process of changing data into format that another program can use
** Answ** Transforming
A collection of structure, semi-structure, and unstructured date stored in a single
location is called a ** Answ** Data lake
A delimiter is ** Answ** a data element that separates field values
Using RPA is best for tasks that are ** Answ** Repetitive
To answer the of "what should be done," one would apply ** Answ** Prescriptive
analytics
According to the EY foundation, over which data analytic techniques should
accountants gain mastery? ** Answ** Querying, trends, forecasting
A company has collected performance data (machine movements, units produced,
quality measures) from a production machine for several months. Each day the
company has increased speed by 0.05 percent. The company plans on building a model
to estimate the machine's quality measures assuming an additional 2% increase in
machine speed. Which type of analytic will be performed? ** Answ** Predictive
analytics
Contact for help with assignments and revision materials
