WGU D552 | 75-Question Timed Mock OA | 2026/2027
WGU D552
Data Analytics for Accountants I
75-Question Timed Mock OA
Answers & Detailed Rationales | ETL, Excel and Data Mining
Document Type: Timed Mock Objective Assessment (OA)
Course: WGU D552 - Data Analytics for Accountants I
Academic Year:
Question Count: 75 Multiple-Choice Questions
Structure: 4 Sections (19 + 19 + 18 + 19)
Cognitive Mix: 30% Recall | 50% Application | 20% Analysis
Question Style: 75% Scenario-Based | 25% Direct
Includes: Complete Answer Key + Detailed Rationales + Grading Rubric
Aligned with 2026|2027 academic and professional standards.
Integrates Microsoft 365 features, modern data visualization, and contemporary audit
analytics.
Page 1 | WGU D552 Timed Mock OA
,WGU D552 | 75-Question Timed Mock OA | 2026/2027
Examination Overview
This 75-Question Timed Mock OA Study Guide for WGU D552 Data Analytics for
Accountants I assesses mastery across four integrated competency domains: (1) ETL
Processes, Data Mining, and Accounting Information Systems; (2) Advanced Excel
Analytics, Functions, and Data Manipulation; (3) Data Visualization, Dashboards, and
Financial Reporting; and (4) Audit Analytics, Fraud Detection, and 2026/2027
technology updates. The guide mirrors the cognitive demand profile of the official
Objective Assessment: 30 percent recall, 50 percent application, and 20 percent
analysis, with 75 percent scenario-based items and 25 percent direct items.
Each question includes the correct answer and a detailed step-by-step rationale
explaining the correct analytical concept, Excel syntax, visualization principle, or
audit technique, and explicitly identifying why each distractor represents a common
Excel, data-cleaning, statistical, or audit error. Distractors are engineered to
reflect the most consequential errors observed in accounting analytics practice.
Document Structure
Part Content Questions
Part 1 Examination Questions (75 Items) Q1 - Q75
Sec 1 ETL Processes, Data Mining & AIS Q1 - Q19
Sec 2 Advanced Excel Analytics & Data Manipulation Q20 - Q38
Sec 3 Data Visualization, Dashboards & Financial Reporting Q39 - Q56
Sec 4 Audit Analytics, Fraud Detection & 2026/2027 Updates Q57 - Q75
Part 2 Complete Solution Key (Answer Summary) All 75
Part 3 Grading Rubric & Mastery Thresholds Scoring Guide
Page 2 | WGU D552 Timed Mock OA
,WGU D552 | 75-Question Timed Mock OA | 2026/2027
PART 1: EXAMINATION QUESTIONS (75 Items)
Instructions: Select the single best answer for each question. Questions are
sequenced Q1 through Q75 across four sections. Correct answers and detailed
rationales are provided inline beneath each question and summarized in Part 2.
Section 1: ETL Processes, Data Mining & Accounting Information
Systems (Q1-Q19)
Q1: A senior accountant at a mid-sized manufacturing firm is initiating a data
analytics project to analyze three years of production cost data. According to the data
analytics lifecycle, which sequence of phases represents the correct order of
activities?
A. Business question definition, data acquisition, data preparation, analysis,
interpretation, deployment [CORRECT]
B. Data extraction, data transformation, data loading, then analysis
C. Data visualization, model building, data cleaning, then reporting
D. Hypothesis testing, data mining, dashboard creation, then ETL processing
Correct Answer: A
Rationale: The data analytics lifecycle begins with defining the business question, followed by
data acquisition, preparation, analysis, interpretation, and deployment. Option B describes
only the ETL subset; Option C reverses analysis and cleaning; Option D places visualization
before data preparation.
Q2: A controller receives a structured general ledger export in CSV format and a folder
of scanned vendor invoices in PDF format for year-end reconciliation. Which statement
accurately characterizes these data types?
A. Both are structured data because both contain financial information about vendor
transactions.
B. The CSV is structured data stored in rows and columns; the PDFs are unstructured data
requiring OCR or NLP extraction before analysis. [CORRECT]
C. The CSV is unstructured because it lacks a database schema; the PDFs are structured
because they follow an invoice template.
D. Both are unstructured data requiring a data warehouse before any analytical processing
can occur.
Correct Answer: B
Rationale: Structured data (CSV) is organized in a predefined row-column schema that is
directly machine-readable, whereas unstructured data (scanned PDFs) requires OCR or NLP to
extract fields. Option A mislabels PDFs; Option C reverses definitions; Option D overstates
requirements since CSVs are analyzable immediately.
Page 3 | WGU D552 Timed Mock OA
, WGU D552 | 75-Question Timed Mock OA | 2026/2027
Q3: An accounts payable analyst builds an ETL pipeline that nightly pulls vendor
payment records from the ERP, standardizes inconsistent vendor name spellings, converts
currency amounts to USD using a daily exchange rate table, and loads the cleaned result
into Power BI. Which ETL stage contains the currency conversion and name
standardization?
A. Extract, because the exchange rate and vendor data must first be pulled from source
systems.
B. Load, because conversions are applied as data is written into the destination model.
C. Transform, because standardization, enrichment, and currency conversion are
data-shaping operations performed between extraction and loading. [CORRECT]
D. Validate, a separate fourth stage dedicated to business rule enforcement after loading.
Correct Answer: C
Rationale: The Transform stage encompasses cleansing, standardization, enrichment, type
conversion, and calculated fields such as currency conversion. Extraction (A) only retrieves
raw data; Loading (B) writes already-transformed data; Option D invents a nonexistent fourth
ETL stage.
Q4: A financial planning team is designing a data warehouse for budget-versus-actual
reporting and debates between a star schema and a snowflake schema. Which statement
correctly distinguishes the two for accounting analytics performance?
A. A snowflake schema normalizes dimension tables into multiple related tables, improving
query performance for large accounting datasets compared to a star schema.
B. Both schemas require identical storage and produce identical query performance; the
choice is purely aesthetic.
C. A star schema is only used for transactional OLTP systems, while snowflake schemas are
exclusively for OLAP reporting.
D. A star schema denormalizes dimensions into single flat tables, which typically delivers
faster query performance and is simpler for business users to navigate in accounting
analytics. [CORRECT]
Correct Answer: D
Rationale: A star schema denormalizes dimension tables into single flat structures surrounding
a central fact table, minimizing joins and improving read performance for OLAP accounting
workloads. A snowflake (A) normalizes dimensions further, increasing join complexity; Option B
is incorrect; Option C is wrong because star schemas are classic OLAP, not OLTP.
Q5: A retail company's CFO wants to segment customers into groups based on purchasing
behavior, recurring revenue patterns, and payment timeliness, without predefined
segment labels. Which data mining technique is most appropriate?
A. K-means clustering, because it is an unsupervised technique that discovers natural
groupings in the data without predefined labels. [CORRECT]
B. Classification, because it assigns each customer to a known, predefined category.
C. Linear regression, because it predicts a continuous revenue value for each customer.
D. Association rules, because it identifies which products are frequently purchased
together.
Correct Answer: A
Rationale: K-means clustering is an unsupervised algorithm that partitions observations into k
groups by feature similarity, ideal for discovering unknown segments without labels.
Classification (B) requires labeled training data; Regression (C) predicts continuous values,
not group membership; Association rules (D) find item co-occurrences, not segmentation.
Page 4 | WGU D552 Timed Mock OA
WGU D552
Data Analytics for Accountants I
75-Question Timed Mock OA
Answers & Detailed Rationales | ETL, Excel and Data Mining
Document Type: Timed Mock Objective Assessment (OA)
Course: WGU D552 - Data Analytics for Accountants I
Academic Year:
Question Count: 75 Multiple-Choice Questions
Structure: 4 Sections (19 + 19 + 18 + 19)
Cognitive Mix: 30% Recall | 50% Application | 20% Analysis
Question Style: 75% Scenario-Based | 25% Direct
Includes: Complete Answer Key + Detailed Rationales + Grading Rubric
Aligned with 2026|2027 academic and professional standards.
Integrates Microsoft 365 features, modern data visualization, and contemporary audit
analytics.
Page 1 | WGU D552 Timed Mock OA
,WGU D552 | 75-Question Timed Mock OA | 2026/2027
Examination Overview
This 75-Question Timed Mock OA Study Guide for WGU D552 Data Analytics for
Accountants I assesses mastery across four integrated competency domains: (1) ETL
Processes, Data Mining, and Accounting Information Systems; (2) Advanced Excel
Analytics, Functions, and Data Manipulation; (3) Data Visualization, Dashboards, and
Financial Reporting; and (4) Audit Analytics, Fraud Detection, and 2026/2027
technology updates. The guide mirrors the cognitive demand profile of the official
Objective Assessment: 30 percent recall, 50 percent application, and 20 percent
analysis, with 75 percent scenario-based items and 25 percent direct items.
Each question includes the correct answer and a detailed step-by-step rationale
explaining the correct analytical concept, Excel syntax, visualization principle, or
audit technique, and explicitly identifying why each distractor represents a common
Excel, data-cleaning, statistical, or audit error. Distractors are engineered to
reflect the most consequential errors observed in accounting analytics practice.
Document Structure
Part Content Questions
Part 1 Examination Questions (75 Items) Q1 - Q75
Sec 1 ETL Processes, Data Mining & AIS Q1 - Q19
Sec 2 Advanced Excel Analytics & Data Manipulation Q20 - Q38
Sec 3 Data Visualization, Dashboards & Financial Reporting Q39 - Q56
Sec 4 Audit Analytics, Fraud Detection & 2026/2027 Updates Q57 - Q75
Part 2 Complete Solution Key (Answer Summary) All 75
Part 3 Grading Rubric & Mastery Thresholds Scoring Guide
Page 2 | WGU D552 Timed Mock OA
,WGU D552 | 75-Question Timed Mock OA | 2026/2027
PART 1: EXAMINATION QUESTIONS (75 Items)
Instructions: Select the single best answer for each question. Questions are
sequenced Q1 through Q75 across four sections. Correct answers and detailed
rationales are provided inline beneath each question and summarized in Part 2.
Section 1: ETL Processes, Data Mining & Accounting Information
Systems (Q1-Q19)
Q1: A senior accountant at a mid-sized manufacturing firm is initiating a data
analytics project to analyze three years of production cost data. According to the data
analytics lifecycle, which sequence of phases represents the correct order of
activities?
A. Business question definition, data acquisition, data preparation, analysis,
interpretation, deployment [CORRECT]
B. Data extraction, data transformation, data loading, then analysis
C. Data visualization, model building, data cleaning, then reporting
D. Hypothesis testing, data mining, dashboard creation, then ETL processing
Correct Answer: A
Rationale: The data analytics lifecycle begins with defining the business question, followed by
data acquisition, preparation, analysis, interpretation, and deployment. Option B describes
only the ETL subset; Option C reverses analysis and cleaning; Option D places visualization
before data preparation.
Q2: A controller receives a structured general ledger export in CSV format and a folder
of scanned vendor invoices in PDF format for year-end reconciliation. Which statement
accurately characterizes these data types?
A. Both are structured data because both contain financial information about vendor
transactions.
B. The CSV is structured data stored in rows and columns; the PDFs are unstructured data
requiring OCR or NLP extraction before analysis. [CORRECT]
C. The CSV is unstructured because it lacks a database schema; the PDFs are structured
because they follow an invoice template.
D. Both are unstructured data requiring a data warehouse before any analytical processing
can occur.
Correct Answer: B
Rationale: Structured data (CSV) is organized in a predefined row-column schema that is
directly machine-readable, whereas unstructured data (scanned PDFs) requires OCR or NLP to
extract fields. Option A mislabels PDFs; Option C reverses definitions; Option D overstates
requirements since CSVs are analyzable immediately.
Page 3 | WGU D552 Timed Mock OA
, WGU D552 | 75-Question Timed Mock OA | 2026/2027
Q3: An accounts payable analyst builds an ETL pipeline that nightly pulls vendor
payment records from the ERP, standardizes inconsistent vendor name spellings, converts
currency amounts to USD using a daily exchange rate table, and loads the cleaned result
into Power BI. Which ETL stage contains the currency conversion and name
standardization?
A. Extract, because the exchange rate and vendor data must first be pulled from source
systems.
B. Load, because conversions are applied as data is written into the destination model.
C. Transform, because standardization, enrichment, and currency conversion are
data-shaping operations performed between extraction and loading. [CORRECT]
D. Validate, a separate fourth stage dedicated to business rule enforcement after loading.
Correct Answer: C
Rationale: The Transform stage encompasses cleansing, standardization, enrichment, type
conversion, and calculated fields such as currency conversion. Extraction (A) only retrieves
raw data; Loading (B) writes already-transformed data; Option D invents a nonexistent fourth
ETL stage.
Q4: A financial planning team is designing a data warehouse for budget-versus-actual
reporting and debates between a star schema and a snowflake schema. Which statement
correctly distinguishes the two for accounting analytics performance?
A. A snowflake schema normalizes dimension tables into multiple related tables, improving
query performance for large accounting datasets compared to a star schema.
B. Both schemas require identical storage and produce identical query performance; the
choice is purely aesthetic.
C. A star schema is only used for transactional OLTP systems, while snowflake schemas are
exclusively for OLAP reporting.
D. A star schema denormalizes dimensions into single flat tables, which typically delivers
faster query performance and is simpler for business users to navigate in accounting
analytics. [CORRECT]
Correct Answer: D
Rationale: A star schema denormalizes dimension tables into single flat structures surrounding
a central fact table, minimizing joins and improving read performance for OLAP accounting
workloads. A snowflake (A) normalizes dimensions further, increasing join complexity; Option B
is incorrect; Option C is wrong because star schemas are classic OLAP, not OLTP.
Q5: A retail company's CFO wants to segment customers into groups based on purchasing
behavior, recurring revenue patterns, and payment timeliness, without predefined
segment labels. Which data mining technique is most appropriate?
A. K-means clustering, because it is an unsupervised technique that discovers natural
groupings in the data without predefined labels. [CORRECT]
B. Classification, because it assigns each customer to a known, predefined category.
C. Linear regression, because it predicts a continuous revenue value for each customer.
D. Association rules, because it identifies which products are frequently purchased
together.
Correct Answer: A
Rationale: K-means clustering is an unsupervised algorithm that partitions observations into k
groups by feature similarity, ideal for discovering unknown segments without labels.
Classification (B) requires labeled training data; Regression (C) predicts continuous values,
not group membership; Association rules (D) find item co-occurrences, not segmentation.
Page 4 | WGU D552 Timed Mock OA
