Page 1 of 62
WGU D467 EXPLORING DATA FOR OA AND PRE
-ASSESSMENT EXAM | {LATEST 2026/ 2027
UPDATE} COMPLETE ACTUAL AND AUTHENTIC
EXAM | BRAND NEW!
A magazine conducts research about people's reading preferences.
They only include respondents who currently subscribe. What type of
bias does this scenario describe?
Confirmation
Interpretation
Sampling
Observer
Sampling
Fill in the blank: The data ethics principle of _____ states that an
individual has the right to understand all of the data-processing
activities and algorithms used on their data.
transaction transparency
,Page 2 of 62
consent
ownership
currency
transaction transparency
A financial institution publishes data about stock prices and market
trends, which any business, nonprofit, or citizen can access, reuse, or
redistribute through its online databases. What type of data is
described in this scenario?
Open
Allowable
Free
Closed
Open
Fill in the blank: A relational database contains a series of _____ that
can be connected to form relationships.
tables
,Page 3 of 62
cells
fields
spreadsheets
tables
What is the term for an identifier that references a database column
in which each value is unique?
Field
Relation
Primary key
Foreign key
Primary key
What process do data professionals use to eliminate data redundancy,
increase data integrity, and reduce complexity in a database?
Composition
Normalization
Manipulation
, Page 4 of 62
Iteration
Normalization
Fill in the blank: When using a relational database, data analysts write
_____ to request data from the related tables.
relationships
keys
queries
programs
queries
A large company has several databases across its many departments.
What kind of metadata describes how many locations contain a
certain piece of data?
Structural
Administrative
Descriptive
Representative
WGU D467 EXPLORING DATA FOR OA AND PRE
-ASSESSMENT EXAM | {LATEST 2026/ 2027
UPDATE} COMPLETE ACTUAL AND AUTHENTIC
EXAM | BRAND NEW!
A magazine conducts research about people's reading preferences.
They only include respondents who currently subscribe. What type of
bias does this scenario describe?
Confirmation
Interpretation
Sampling
Observer
Sampling
Fill in the blank: The data ethics principle of _____ states that an
individual has the right to understand all of the data-processing
activities and algorithms used on their data.
transaction transparency
,Page 2 of 62
consent
ownership
currency
transaction transparency
A financial institution publishes data about stock prices and market
trends, which any business, nonprofit, or citizen can access, reuse, or
redistribute through its online databases. What type of data is
described in this scenario?
Open
Allowable
Free
Closed
Open
Fill in the blank: A relational database contains a series of _____ that
can be connected to form relationships.
tables
,Page 3 of 62
cells
fields
spreadsheets
tables
What is the term for an identifier that references a database column
in which each value is unique?
Field
Relation
Primary key
Foreign key
Primary key
What process do data professionals use to eliminate data redundancy,
increase data integrity, and reduce complexity in a database?
Composition
Normalization
Manipulation
, Page 4 of 62
Iteration
Normalization
Fill in the blank: When using a relational database, data analysts write
_____ to request data from the related tables.
relationships
keys
queries
programs
queries
A large company has several databases across its many departments.
What kind of metadata describes how many locations contain a
certain piece of data?
Structural
Administrative
Descriptive
Representative
