WGU D552 Data Analytics for Accountants
Final Assessment Bank (150 Questions)
1. An accountant is examining a dataset of vendor payments. Which of the following
best describes "structured data" in this context?
a) Email correspondence with vendors
b) PDF copies of signed contracts
c) A table with columns: Vendor ID, Date, Amount
d) Voicemail recordings of payment authorizations
Correct Answer: c
2. Which type of analytics answers the question, "What happened?"
a) Diagnostic
b) Descriptive
c) Predictive
d) Prescriptive
Correct Answer: b
,3. An accountant uses regression to predict next quarter’s sales based on historical
trends. This is an example of:
a) Descriptive analytics
b) Diagnostic analytics
c) Predictive analytics
d) Prescriptive analytics
Correct Answer: c
4. Which of the following is an example of a key performance indicator (KPI) for
accounts payable?
a) Inventory turnover ratio
b) Days payable outstanding (DPO)
c) Gross profit margin
d) Quick ratio
Correct Answer: b
5. A data dictionary in an accounting data analytics project should include:
a) Only the field names
b) Field names, data types, descriptions, and source
c) Actual data values for the first 100 rows
d) SQL queries used to generate the data
Correct Answer: b
6. What is the primary purpose of data normalization in accounting databases?
a) Increase data redundancy
,b) Reduce data duplication and improve integrity
c) Encrypt all sensitive financial fields
d) Convert all numbers to percentages
Correct Answer: b
7. Which of the following is a fact table likely to contain in a star schema for sales?
a) Customer name, address, phone
b) Product description and unit price
c) Date, Product ID, Customer ID, Sales Amount
d) Fiscal calendar hierarchy
Correct Answer: c
8. An accountant discovers negative inventory quantities in the ERP system. This is
most likely a:
a) Data type inconsistency
b) Data validity issue
c) Data completeness issue
d) Data governance success
Correct Answer: b
9. Which tool is specifically designed for extracting, transforming, and loading (ETL)
data for analytics?
a) Excel pivot tables
b) Tableau
, c) Power Query (in Power BI/Excel)
d) PowerPoint
Correct Answer: c
10. In the IMPACT cycle for data analytics, the "C" stands for:
a) Compute
b) Communicate
c) Correlate
d) Calculate
Correct Answer: b
11. An accountant wants to test whether the mean monthly expense differs between
two departments. Which statistical test is appropriate?
a) Chi-square test
b) One-way ANOVA
c) Two-sample t-test
d) Pearson correlation
Correct Answer: c
12. A p-value of 0.03 in an audit test means:
a) There is a 3% chance the null hypothesis is true
b) There is a 3% chance of observing the data if the null is true
c) The null hypothesis is definitely false
d) The result is not statistically significant at α=0.05
Final Assessment Bank (150 Questions)
1. An accountant is examining a dataset of vendor payments. Which of the following
best describes "structured data" in this context?
a) Email correspondence with vendors
b) PDF copies of signed contracts
c) A table with columns: Vendor ID, Date, Amount
d) Voicemail recordings of payment authorizations
Correct Answer: c
2. Which type of analytics answers the question, "What happened?"
a) Diagnostic
b) Descriptive
c) Predictive
d) Prescriptive
Correct Answer: b
,3. An accountant uses regression to predict next quarter’s sales based on historical
trends. This is an example of:
a) Descriptive analytics
b) Diagnostic analytics
c) Predictive analytics
d) Prescriptive analytics
Correct Answer: c
4. Which of the following is an example of a key performance indicator (KPI) for
accounts payable?
a) Inventory turnover ratio
b) Days payable outstanding (DPO)
c) Gross profit margin
d) Quick ratio
Correct Answer: b
5. A data dictionary in an accounting data analytics project should include:
a) Only the field names
b) Field names, data types, descriptions, and source
c) Actual data values for the first 100 rows
d) SQL queries used to generate the data
Correct Answer: b
6. What is the primary purpose of data normalization in accounting databases?
a) Increase data redundancy
,b) Reduce data duplication and improve integrity
c) Encrypt all sensitive financial fields
d) Convert all numbers to percentages
Correct Answer: b
7. Which of the following is a fact table likely to contain in a star schema for sales?
a) Customer name, address, phone
b) Product description and unit price
c) Date, Product ID, Customer ID, Sales Amount
d) Fiscal calendar hierarchy
Correct Answer: c
8. An accountant discovers negative inventory quantities in the ERP system. This is
most likely a:
a) Data type inconsistency
b) Data validity issue
c) Data completeness issue
d) Data governance success
Correct Answer: b
9. Which tool is specifically designed for extracting, transforming, and loading (ETL)
data for analytics?
a) Excel pivot tables
b) Tableau
, c) Power Query (in Power BI/Excel)
d) PowerPoint
Correct Answer: c
10. In the IMPACT cycle for data analytics, the "C" stands for:
a) Compute
b) Communicate
c) Correlate
d) Calculate
Correct Answer: b
11. An accountant wants to test whether the mean monthly expense differs between
two departments. Which statistical test is appropriate?
a) Chi-square test
b) One-way ANOVA
c) Two-sample t-test
d) Pearson correlation
Correct Answer: c
12. A p-value of 0.03 in an audit test means:
a) There is a 3% chance the null hypothesis is true
b) There is a 3% chance of observing the data if the null is true
c) The null hypothesis is definitely false
d) The result is not statistically significant at α=0.05
