[WGU D467 OA EXAM 2026 - EXPLORING DATA] – EXAM-STYLE QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
GUARANTEED PASS | 2026/27 LATEST UPDATE | EXAM PREP | STUDY GUIDE |
PRACTICE TEST
1. A data analyst is examining a dataset containing customer transaction
records. The analyst suspects that some transactions may have been entered
incorrectly, as they show a purchase date that is in the future relative to the
current system date. Which data quality dimension is most directly impacted by
this issue?
A. Completeness
B. Validity
C. Timeliness
D. Consistency
Correct Answer: B. Validity
*Rationale: Validity refers to the degree to which data conforms to defined rules
and constraints, such as date formats or permissible ranges. A future purchase date
violates business rules and represents a data validity issue. Completeness deals with
missing data, timeliness concerns whether data is up-to-date at the right time, and
consistency refers to data being the same across different systems.
2. A company is designing a star schema for a sales data warehouse. Which of
the following best describes the primary purpose of a dimension table in this
context?
A. To store the transactional facts and metrics of the business process.
B. To provide a time-based record of changes to data attributes.
,C. To contain descriptive attributes that provide context to the fact
measurements.
D. To ensure the atomicity and integrity of the data warehouse transactions.
Correct Answer: C. To contain descriptive attributes that provide context to the
fact measurements.
*Rationale: In a star schema, dimension tables hold descriptive attributes (e.g.,
customer name, product category, store location) that provide the context for the
quantitative measures stored in the fact table. Fact tables store the metrics
themselves. A slowly changing dimension (SCD) handles changes to attributes, not
the dimension table's primary purpose.
3. A database administrator needs to ensure data integrity by preventing the
entry of duplicate records in a customer table. Which data governance practice
is most effective for implementing this rule at the database level?
A. Data profiling to discover existing duplicates.
B. Implementing a data quality scorecard for customer data.
C. Enforcing a unique constraint on a key identifier, such as CustomerID.
D. Establishing a data stewardship role to review new entries.
Correct Answer: C. Enforcing a unique constraint on a key identifier, such as
CustomerID.
*Rationale: A unique constraint is a database-level rule that prevents duplicate
values from being inserted into a specified column or set of columns. This is the
most direct and effective way to enforce uniqueness at the point of data entry,
ensuring data integrity. Data profiling, scorecards, and stewardship are valuable but
are post-entry or procedural controls, not direct enforcement mechanisms.
,4. Which of the following is the primary distinction between a relational
database management system (RDBMS) and a non-relational (NoSQL)
database?
A. The use of SQL for querying data.
B. The ability to handle unstructured data.
C. The enforcement of a predefined schema.
D. The support for ACID transactions.
Correct Answer: C. The enforcement of a predefined schema.
*Rationale: The primary distinction is that RDBMSs enforce a rigid, predefined
schema (tables, columns, data types, and relationships), whereas NoSQL databases
are schema-flexible, allowing for the storage of varied data structures. While many
RDBMSs use SQL and support ACID, and NoSQL databases often handle
unstructured data, the core difference is their approach to schema enforcement. Not
all RDBMSs strictly support full ACID in all configurations, and NoSQL databases
like MongoDB support ACID transactions at a single document level.
5. During an exploratory data analysis, a data scientist observes that the
distribution of a continuous variable is highly skewed to the right. Which of the
following measures of central tendency would be most appropriate to describe
the "typical" value of this variable?
A. The mean
B. The median
C. The mode
D. The standard deviation
Correct Answer: B. The median
, *Rationale: For a right-skewed distribution, the mean is pulled toward the long tail
of high values, making it a poor representation of the center. The median, the 50th
percentile, is robust to skew and outliers, thus better representing the central
tendency of the data. The mode is the most frequent value and may not represent
the center for continuous data, and standard deviation is a measure of spread, not
central tendency.
6. A data engineer is tasked with building a new data pipeline. The source
system is an operational database that must remain highly available. The
engineer needs to extract data without impacting the performance of this
production system. Which extraction strategy is most appropriate?
A. Full extraction of the source tables during peak hours.
B. Incremental extraction using a timestamp-based filter.
C. Performing an online transaction processing (OLTP) bulk export.
D. Using a Change Data Capture (CDC) tool on transaction logs.
Correct Answer: D. Using a Change Data Capture (CDC) tool on transaction
logs.
*Rationale: Change Data Capture (CDC) minimizes impact on the source system by
reading changes from the database transaction logs, rather than querying the live
tables directly. This is the most non-intrusive method for maintaining high
availability. Full extraction and OLTP exports are more resource-intensive and can
impact performance, especially during peak hours. Incremental extraction using
timestamps can still place a query load on the system.
7. What is the primary purpose of a data dictionary in an organization's data
management framework?
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
GUARANTEED PASS | 2026/27 LATEST UPDATE | EXAM PREP | STUDY GUIDE |
PRACTICE TEST
1. A data analyst is examining a dataset containing customer transaction
records. The analyst suspects that some transactions may have been entered
incorrectly, as they show a purchase date that is in the future relative to the
current system date. Which data quality dimension is most directly impacted by
this issue?
A. Completeness
B. Validity
C. Timeliness
D. Consistency
Correct Answer: B. Validity
*Rationale: Validity refers to the degree to which data conforms to defined rules
and constraints, such as date formats or permissible ranges. A future purchase date
violates business rules and represents a data validity issue. Completeness deals with
missing data, timeliness concerns whether data is up-to-date at the right time, and
consistency refers to data being the same across different systems.
2. A company is designing a star schema for a sales data warehouse. Which of
the following best describes the primary purpose of a dimension table in this
context?
A. To store the transactional facts and metrics of the business process.
B. To provide a time-based record of changes to data attributes.
,C. To contain descriptive attributes that provide context to the fact
measurements.
D. To ensure the atomicity and integrity of the data warehouse transactions.
Correct Answer: C. To contain descriptive attributes that provide context to the
fact measurements.
*Rationale: In a star schema, dimension tables hold descriptive attributes (e.g.,
customer name, product category, store location) that provide the context for the
quantitative measures stored in the fact table. Fact tables store the metrics
themselves. A slowly changing dimension (SCD) handles changes to attributes, not
the dimension table's primary purpose.
3. A database administrator needs to ensure data integrity by preventing the
entry of duplicate records in a customer table. Which data governance practice
is most effective for implementing this rule at the database level?
A. Data profiling to discover existing duplicates.
B. Implementing a data quality scorecard for customer data.
C. Enforcing a unique constraint on a key identifier, such as CustomerID.
D. Establishing a data stewardship role to review new entries.
Correct Answer: C. Enforcing a unique constraint on a key identifier, such as
CustomerID.
*Rationale: A unique constraint is a database-level rule that prevents duplicate
values from being inserted into a specified column or set of columns. This is the
most direct and effective way to enforce uniqueness at the point of data entry,
ensuring data integrity. Data profiling, scorecards, and stewardship are valuable but
are post-entry or procedural controls, not direct enforcement mechanisms.
,4. Which of the following is the primary distinction between a relational
database management system (RDBMS) and a non-relational (NoSQL)
database?
A. The use of SQL for querying data.
B. The ability to handle unstructured data.
C. The enforcement of a predefined schema.
D. The support for ACID transactions.
Correct Answer: C. The enforcement of a predefined schema.
*Rationale: The primary distinction is that RDBMSs enforce a rigid, predefined
schema (tables, columns, data types, and relationships), whereas NoSQL databases
are schema-flexible, allowing for the storage of varied data structures. While many
RDBMSs use SQL and support ACID, and NoSQL databases often handle
unstructured data, the core difference is their approach to schema enforcement. Not
all RDBMSs strictly support full ACID in all configurations, and NoSQL databases
like MongoDB support ACID transactions at a single document level.
5. During an exploratory data analysis, a data scientist observes that the
distribution of a continuous variable is highly skewed to the right. Which of the
following measures of central tendency would be most appropriate to describe
the "typical" value of this variable?
A. The mean
B. The median
C. The mode
D. The standard deviation
Correct Answer: B. The median
, *Rationale: For a right-skewed distribution, the mean is pulled toward the long tail
of high values, making it a poor representation of the center. The median, the 50th
percentile, is robust to skew and outliers, thus better representing the central
tendency of the data. The mode is the most frequent value and may not represent
the center for continuous data, and standard deviation is a measure of spread, not
central tendency.
6. A data engineer is tasked with building a new data pipeline. The source
system is an operational database that must remain highly available. The
engineer needs to extract data without impacting the performance of this
production system. Which extraction strategy is most appropriate?
A. Full extraction of the source tables during peak hours.
B. Incremental extraction using a timestamp-based filter.
C. Performing an online transaction processing (OLTP) bulk export.
D. Using a Change Data Capture (CDC) tool on transaction logs.
Correct Answer: D. Using a Change Data Capture (CDC) tool on transaction
logs.
*Rationale: Change Data Capture (CDC) minimizes impact on the source system by
reading changes from the database transaction logs, rather than querying the live
tables directly. This is the most non-intrusive method for maintaining high
availability. Full extraction and OLTP exports are more resource-intensive and can
impact performance, especially during peak hours. Incremental extraction using
timestamps can still place a query load on the system.
7. What is the primary purpose of a data dictionary in an organization's data
management framework?
