WGU D552 DATA ANALYTICS FOR ACCOUNTANTS
Final Examination – 150 Questions with Answer Rationales
Domain 1: Foundations of Data Analytics for Accountants
(Questions 1–30)
1. Which type of analytics answers the question, "Why did it happen?"
a) Descriptive
b) Diagnostic
c) Predictive
d) Prescriptive
Correct Answer: b
2. An accountant uses a scatter plot to examine the relationship between advertising
spend and sales revenue. This is an example of:
a) Descriptive analytics
b) Diagnostic analytics
c) Predictive analytics
d) Prescriptive analytics
Correct Answer: b
,3. Which of the following is an example of structured data?
a) A PDF copy of a signed contract
b) An email thread about invoice approval
c) A database table of general ledger entries
d) A voicemail recording of a payment authorization
Correct Answer: c
4. A data dictionary in an accounting analytics project should include:
a) Only the field names
b) Field names, data types, descriptions, and data source
c) Actual data values for the first 100 rows
d) SQL queries used to generate the data
Correct Answer: b
5. What is the primary purpose of data normalization in accounting databases?
a) Increase data redundancy
b) Reduce data duplication and improve integrity
c) Encrypt sensitive financial fields
d) Convert all numbers to percentages
Correct Answer: b
,6. In the IMPACT cycle for data analytics, the "M" stands for:
a) Manipulate
b) Master the data
c) Measure
d) Model
Correct Answer: b
7. Which of the following is a key performance indicator (KPI) for accounts receivable?
a) Days sales outstanding (DSO)
b) Inventory turnover ratio
c) Debt-to-equity ratio
d) Gross profit margin
Correct Answer: a
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. 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
11. 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 Examination – 150 Questions with Answer Rationales
Domain 1: Foundations of Data Analytics for Accountants
(Questions 1–30)
1. Which type of analytics answers the question, "Why did it happen?"
a) Descriptive
b) Diagnostic
c) Predictive
d) Prescriptive
Correct Answer: b
2. An accountant uses a scatter plot to examine the relationship between advertising
spend and sales revenue. This is an example of:
a) Descriptive analytics
b) Diagnostic analytics
c) Predictive analytics
d) Prescriptive analytics
Correct Answer: b
,3. Which of the following is an example of structured data?
a) A PDF copy of a signed contract
b) An email thread about invoice approval
c) A database table of general ledger entries
d) A voicemail recording of a payment authorization
Correct Answer: c
4. A data dictionary in an accounting analytics project should include:
a) Only the field names
b) Field names, data types, descriptions, and data source
c) Actual data values for the first 100 rows
d) SQL queries used to generate the data
Correct Answer: b
5. What is the primary purpose of data normalization in accounting databases?
a) Increase data redundancy
b) Reduce data duplication and improve integrity
c) Encrypt sensitive financial fields
d) Convert all numbers to percentages
Correct Answer: b
,6. In the IMPACT cycle for data analytics, the "M" stands for:
a) Manipulate
b) Master the data
c) Measure
d) Model
Correct Answer: b
7. Which of the following is a key performance indicator (KPI) for accounts receivable?
a) Days sales outstanding (DSO)
b) Inventory turnover ratio
c) Debt-to-equity ratio
d) Gross profit margin
Correct Answer: a
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. 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
11. 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
