WGU D522 EXAM / DATA ANALYTICS
FOR ACCOUNTANTS 1 / WGU D522 DATA
ANALYTICS FOR ACCOUNTANTS 1
OBJECTIVE ASSESSMENT (OA) ACTUAL
EXAM 2026/2027 COMPLETE ACCURATE
EXAM APPROVED QUESTIONS AND
CORRECT VERIFIED ANSWERS (DETAILED
ANSWERS) LATEST UPDATED VERSION
1. Which type of business management software combines programs from all
parts of a business, such as finance, accounting, manufacturing, and human
resources, into one single system?
A) Customer Relationship Management (CRM)
B) Enterprise Resource Planning (ERP)
C) Supply Chain Management (SCM)
D) Business Intelligence (BI)
Correct Answer: B
Rationale: Enterprise Resource Planning (ERP) systems integrate various business
functions—including finance, accounting, manufacturing, HR, and supply chain—
into a single, unified system.
,2. A relational database contains two tables—a Supplier table and a Purchase
Order table. The Supplier table has two columns—Supplier ID and Supplier
Name. The Purchase Order table has three columns—PO Number, Supplier ID,
and Employee ID. What is true about the tables in this case?
A) The Supplier ID column in the Supplier table is a foreign key
B) The Supplier ID column in the Purchase Order table is a foreign key
C) The PO Number column is a foreign key
D) There are no foreign keys in this database
Correct Answer: B
Rationale: A foreign key is a column in one table that refers to the primary key of
another table. In the Purchase Order table, Supplier ID references the Supplier ID in
the Supplier table, making it a foreign key.
3. A software development company's financial analyst is required to provide
strategic inputs to management and has therefore requested data from the
product development team. What is true of such a data request by the financial
analyst?
A) The product development team can provide data in any format
B) The financial analyst would have to specify the format in which the data must be
delivered
C) The financial analyst cannot request data from other departments
D) The data request does not need to specify the data needed
Correct Answer: B
,Rationale: For effective data analysis, the requester must clearly specify the
required data format, structure, and fields to ensure the data is usable for the
intended purpose.
4. A financial analyst at a tech company is working with a dataset that contains
the profit margins for each of the company's products sold in the last three
years. All transactions are filed in an Excel spreadsheet with columns
indicating details such as the product name and transaction date. What is the
fastest way for the analyst to create a table that shows the monthly profit
margins for each product?
A) By using VLOOKUP functions
B) By using PivotTables
C) By writing a VBA macro
D) By manually calculating each month
Correct Answer: B
Rationale: PivotTables are the fastest and most efficient way to summarize,
analyze, and aggregate large datasets in Excel.
5. An apparel manufacturing company recently assigned its finance manager
with a time series forecasting exercise on its sales and inventory costs. The
source database has the historical figures by date going back the last five
years. The finance manager finds that the dataset they extracted contains
nonprintable characters. What is a potential reason for this?
, A) The file was corrupted during download
B) The database contains dates or numbers stored as text
C) The data was encrypted
D) The dataset is too old
Correct Answer: B
Rationale: Nonprintable characters often appear when databases store dates,
numbers, or other values as text with hidden formatting characters.
6. An electric utilities service provider operating in three states has a large
relational database that contains information on its customers. The company
wants to use customer data for a new marketing analysis. What is the primary
ethical concern?
A) The data is too large to analyze
B) Customers did not give consent for this particular use of data
C) The data is not structured properly
D) The analysis would be too expensive
Correct Answer: B
Rationale: Data ethics requires that organizations obtain proper consent from
individuals before using their personal data for purposes beyond what was
originally disclosed.
7. A pharmaceutical company is analyzing a large dataset to gain insights into
customer behavior. However, the dataset only contains information on
FOR ACCOUNTANTS 1 / WGU D522 DATA
ANALYTICS FOR ACCOUNTANTS 1
OBJECTIVE ASSESSMENT (OA) ACTUAL
EXAM 2026/2027 COMPLETE ACCURATE
EXAM APPROVED QUESTIONS AND
CORRECT VERIFIED ANSWERS (DETAILED
ANSWERS) LATEST UPDATED VERSION
1. Which type of business management software combines programs from all
parts of a business, such as finance, accounting, manufacturing, and human
resources, into one single system?
A) Customer Relationship Management (CRM)
B) Enterprise Resource Planning (ERP)
C) Supply Chain Management (SCM)
D) Business Intelligence (BI)
Correct Answer: B
Rationale: Enterprise Resource Planning (ERP) systems integrate various business
functions—including finance, accounting, manufacturing, HR, and supply chain—
into a single, unified system.
,2. A relational database contains two tables—a Supplier table and a Purchase
Order table. The Supplier table has two columns—Supplier ID and Supplier
Name. The Purchase Order table has three columns—PO Number, Supplier ID,
and Employee ID. What is true about the tables in this case?
A) The Supplier ID column in the Supplier table is a foreign key
B) The Supplier ID column in the Purchase Order table is a foreign key
C) The PO Number column is a foreign key
D) There are no foreign keys in this database
Correct Answer: B
Rationale: A foreign key is a column in one table that refers to the primary key of
another table. In the Purchase Order table, Supplier ID references the Supplier ID in
the Supplier table, making it a foreign key.
3. A software development company's financial analyst is required to provide
strategic inputs to management and has therefore requested data from the
product development team. What is true of such a data request by the financial
analyst?
A) The product development team can provide data in any format
B) The financial analyst would have to specify the format in which the data must be
delivered
C) The financial analyst cannot request data from other departments
D) The data request does not need to specify the data needed
Correct Answer: B
,Rationale: For effective data analysis, the requester must clearly specify the
required data format, structure, and fields to ensure the data is usable for the
intended purpose.
4. A financial analyst at a tech company is working with a dataset that contains
the profit margins for each of the company's products sold in the last three
years. All transactions are filed in an Excel spreadsheet with columns
indicating details such as the product name and transaction date. What is the
fastest way for the analyst to create a table that shows the monthly profit
margins for each product?
A) By using VLOOKUP functions
B) By using PivotTables
C) By writing a VBA macro
D) By manually calculating each month
Correct Answer: B
Rationale: PivotTables are the fastest and most efficient way to summarize,
analyze, and aggregate large datasets in Excel.
5. An apparel manufacturing company recently assigned its finance manager
with a time series forecasting exercise on its sales and inventory costs. The
source database has the historical figures by date going back the last five
years. The finance manager finds that the dataset they extracted contains
nonprintable characters. What is a potential reason for this?
, A) The file was corrupted during download
B) The database contains dates or numbers stored as text
C) The data was encrypted
D) The dataset is too old
Correct Answer: B
Rationale: Nonprintable characters often appear when databases store dates,
numbers, or other values as text with hidden formatting characters.
6. An electric utilities service provider operating in three states has a large
relational database that contains information on its customers. The company
wants to use customer data for a new marketing analysis. What is the primary
ethical concern?
A) The data is too large to analyze
B) Customers did not give consent for this particular use of data
C) The data is not structured properly
D) The analysis would be too expensive
Correct Answer: B
Rationale: Data ethics requires that organizations obtain proper consent from
individuals before using their personal data for purposes beyond what was
originally disclosed.
7. A pharmaceutical company is analyzing a large dataset to gain insights into
customer behavior. However, the dataset only contains information on
