Question 1

Choose from the following list of responsibilities for management accountants.

Accepted Answer

A)  Managing financial accounting information systems 
B)  Preparing and analyzing financial statements 
C)  Cost management and reporting 
D)  Attending to tax audit issues 
A)  Managing financial accounting information systems 
B)  Preparing and analyzing financial statements 
C)  Cost management and reporting 
D)  Attending to tax audit issues

Question 2

How can a database be scaled vertically?

Accepted Answer

A)  A database can be scaled vertically by removing capacity from the existing machine. 
B)  A database can be scaled vertically by consolidating the database onto a single machine. 
C)  A database can be scaled vertically by adding more capacity to the existing machine. 
D)  A database can be scaled vertically by spreading the database across multiple machines that work together to manage the database. 
A)  A database can be scaled vertically by removing capacity from the existing machine. 
B)  A database can be scaled vertically by consolidating the database onto a single machine. 
C)  A database can be scaled vertically by adding more capacity to the existing machine. 
D)  A database can be scaled vertically by spreading the database across multiple machines that work together to manage the database.

Question 3

A Database Management System (DBMS) includes a user interface. Choose the best term to describe a user interface.

Accepted Answer

A)  A user interface is a screen where a user logs in and interacts with the computer system. 
B)  A user interface is a program that loads data into the databases. 
C)  A user interface is a screen where a user can monitor database performance. 
D)  A user interface is a program for optimizing database performance. 
A)  A user interface is a screen where a user logs in and interacts with the computer system. 
B)  A user interface is a program that loads data into the databases. 
C)  A user interface is a screen where a user can monitor database performance. 
D)  A user interface is a program for optimizing database performance.

Question 4

An internal auditor has been asked to calculate an allowance for doubtful accounts. Which category of data analysis would this type of work be categorized as?

Accepted Answer

A)  Descriptive 
B)  Diagnostic 
C)  Predictive 
D)  Prescriptive 
A)  Descriptive 
B)  Diagnostic 
C)  Predictive 
D)  Prescriptive

Question 5

Choose the term that best describes dynamic data.

Accepted Answer

A)  Dynamic data may change after it is recorded. 
B)  Dynamic data is very difficult to record. 
C)  Dynamic data does not change once it is created. 
D)  Dynamic data is like a book. 
A)  Dynamic data may change after it is recorded. 
B)  Dynamic data is very difficult to record. 
C)  Dynamic data does not change once it is created. 
D)  Dynamic data is like a book.

Question 6

Choose from the following list of responsibilities for tax accountants.

Accepted Answer

A)  Managing financial accounting information systems 
B)  Preparing financial statements to minimize tax returns 
C)  Performance measurement and analysis 
D)  Attending to tax audit issues 
A)  Managing financial accounting information systems 
B)  Preparing financial statements to minimize tax returns 
C)  Performance measurement and analysis 
D)  Attending to tax audit issues

Question 7

Arrange the hierarchy of data elements in their correct order.

Accepted Answer

A)  Databases, Fields, Files, Bytes, Bits and Records 
B)  Bytes, Bits, Records, Fields, Files and Databases 
C)  Records, Files, Databases, Bits, Bytes and Fields 
D)  Databases, Files, Records, Fields, Bytes and Bits 
A)  Databases, Fields, Files, Bytes, Bits and Records 
B)  Bytes, Bits, Records, Fields, Files and Databases 
C)  Records, Files, Databases, Bits, Bytes and Fields 
D)  Databases, Files, Records, Fields, Bytes and Bits

Question 8

Which of the following is one of the five characteristics of big data?

Accepted Answer

A)  Vacancy 
B)  Variety 
C)  Vastness 
D)  Vitality 
A)  Vacancy 
B)  Variety 
C)  Vastness 
D)  Vitality

Question 9

Choose from the following list of responsibilities for financial accountants.

Accepted Answer

A)  Managing geographic information systems 
B)  Preparing and analyzing financial statements 
C)  Ignoring compliance with regulatory requirements 
D)  Preparing and analyzing game statistics 
A)  Managing geographic information systems 
B)  Preparing and analyzing financial statements 
C)  Ignoring compliance with regulatory requirements 
D)  Preparing and analyzing game statistics

Question 10

Choose the most common type of database that you are likely to encounter.

Accepted Answer

A)  Hierarchical 
B)  Relational 
C)  Cloud 
D)  Object Oriented 
A)  Hierarchical 
B)  Relational 
C)  Cloud 
D)  Object Oriented

Question 11

Properly arrange the following data elements that comprise an IT system in their proper hierarchy from largest to smallest.
• Bits
• Files
• Records
• Bytes
• Fields
• Databases

Accepted Answer

Proper Hierarchy:
•

Question 12

Choose from the following list the best definition of confirmation bias.

Accepted Answer

A)  Asking advice from a cross sample of people 
B)  Asking advice only from people who share our world view 
C)  Asking advice only from people who don't share our world view 
D)  Asking advice from everyone 
A)  Asking advice from a cross sample of people 
B)  Asking advice only from people who share our world view 
C)  Asking advice only from people who don't share our world view 
D)  Asking advice from everyone

Question 13

What led to the increase of unstructured data?

Accepted Answer

A)  The use of static data 
B)  The birth of Web 2.0 
C)  The use of dynamic data 
D)  The use of databases 
A)  The use of static data 
B)  The birth of Web 2.0 
C)  The use of dynamic data 
D)  The use of databases

Question 14

Discuss the five characteristics of big data. Provide an example for each.

Accepted Answer

The five characteristics of big data are

Question 15

Data in its raw format, before it is cleaned, aggregated, or filtered, is stored in a

Accepted Answer

A)  data lake. 
B)  data warehouse. 
C)  production database. 
D)  test database. 
A)  data lake. 
B)  data warehouse. 
C)  production database. 
D)  test database.

Question 16

Large companies implement data lakes to store all of their data. Therefore, data lakes use a(n) ________ structure.

Accepted Answer

A)  fixed 
B)  agile 
C)  anchored 
D)  nimble 
A)  fixed 
B)  agile 
C)  anchored 
D)  nimble

Question 17

Choose from the following list of responsibilities for external auditors, internal auditors, and fraud examiners.

Accepted Answer

A)  Advising business leaders on best practices and regulatory requirements 
B)  Dismissing risks, patterns and trends in processes and data 
C)  Performing audit tests to decrease assurance over selected data 
D)  Learning state-of-the-art practices to advise external clients 
A)  Advising business leaders on best practices and regulatory requirements 
B)  Dismissing risks, patterns and trends in processes and data 
C)  Performing audit tests to decrease assurance over selected data 
D)  Learning state-of-the-art practices to advise external clients

Question 18

An example of unstructured data is

Accepted Answer

A)  addresses. 
B)  last names. 
C)  PDF files. 
D)  telephone numbers. 
A)  addresses. 
B)  last names. 
C)  PDF files. 
D)  telephone numbers.

Question 19

Choose from the following list the appropriate area in which tax accountants focus.

Accepted Answer

A)  Managing financial accounting information systems 
B)  Cost management and reporting 
C)  Ensuring compliance with regulatory requirements 
D)  Collecting and paying sales taxes 
A)  Managing financial accounting information systems 
B)  Cost management and reporting 
C)  Ensuring compliance with regulatory requirements 
D)  Collecting and paying sales taxes

Question 20

Data warehouses are designed specifically for

Accepted Answer

A)  speed. 
B)  all of the data in a company. 
C)  reporting and data analysis. 
D)  storage. 
A)  speed. 
B)  all of the data in a company. 
C)  reporting and data analysis. 
D)  storage.

Choose from the following list of responsibilities for management accountants.

How can a database be scaled vertically?

A Database Management System (DBMS) includes a user interface. Choose the best term to describe a user interface.

An internal auditor has been asked to calculate an allowance for doubtful accounts. Which category of data analysis would this type of work be categorized as?

Choose the term that best describes dynamic data.

Choose from the following list of responsibilities for tax accountants.

Arrange the hierarchy of data elements in their correct order.

Which of the following is one of the five characteristics of big data?

Choose from the following list of responsibilities for financial accountants.

Choose the most common type of database that you are likely to encounter.

Properly arrange the following data elements that comprise an IT system in their proper hierarchy from largest to smallest. • Bits • Files • Records • Bytes • Fields • Databases

Choose from the following list the best definition of confirmation bias.

What led to the increase of unstructured data?

Discuss the five characteristics of big data. Provide an example for each.

Data in its raw format, before it is cleaned, aggregated, or filtered, is stored in a

Large companies implement data lakes to store all of their data. Therefore, data lakes use a(n) ________ structure.

Choose from the following list of responsibilities for external auditors, internal auditors, and fraud examiners.

An example of unstructured data is

Choose from the following list the appropriate area in which tax accountants focus.

Data warehouses are designed specifically for

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Systems and Database Design

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters

Exam 5: Data Storage and Analysis

Choose from the following list of responsibilities for management accountants.

How can a database be scaled vertically?

A Database Management System (DBMS) includes a user interface. Choose the best term to describe a user interface.

An internal auditor has been asked to calculate an allowance for doubtful accounts. Which category of data analysis would this type of work be categorized as?

Choose the term that best describes dynamic data.

Choose from the following list of responsibilities for tax accountants.

Arrange the hierarchy of data elements in their correct order.

Which of the following is one of the five characteristics of big data?

Choose from the following list of responsibilities for financial accountants.

Choose the most common type of database that you are likely to encounter.

Properly arrange the following data elements that comprise an IT system in their proper hierarchy from largest to smallest. • Bits • Files • Records • Bytes • Fields • Databases

Choose from the following list the best definition of confirmation bias.

What led to the increase of unstructured data?

Discuss the five characteristics of big data. Provide an example for each.

Data in its raw format, before it is cleaned, aggregated, or filtered, is stored in a

Large companies implement data lakes to store all of their data. Therefore, data lakes use a(n) ________ structure.

Choose from the following list of responsibilities for external auditors, internal auditors, and fraud examiners.

An example of unstructured data is

Choose from the following list the appropriate area in which tax accountants focus.

Data warehouses are designed specifically for

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Systems and Database Design

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters