1
WGU D465 DATA APPLICATIONS EXAM
OA TEST BANK Actual Exam 2026/2027
Complete Questions and Verified Answers
Pass Guaranteed - A+ Graded
SECTION 1: DATA FUNDAMENTALS (Questions 1-15)
Q1: A company has customer data stored in multiple systems with inconsistent formats. For
example, one system stores phone numbers as (555) 123-4567, while another stores them as 555-
123-4567. This is an example of poor data quality in which dimension?
• A. Accuracy
• B. Consistency [CORRECT]
• C. Timeliness
• D. Uniqueness
Correct Answer: B
Rationale: Consistency refers to data being uniform across different systems or datasets.
Inconsistent formatting of the same data type across systems represents a consistency issue.
Accuracy would involve incorrect values, timeliness refers to data currency, and uniqueness
concerns duplicate records.
Q2: Which of the following best describes semi-structured data?
• A. Data organized in fixed rows and columns with rigid schema
• B. Data with no predefined format or organization
• C. Data that contains tags or markers to separate elements but lacks rigid tabular structure
[CORRECT]
• D. Data that has been processed through ETL and stored in a data warehouse
Correct Answer: C
,2
Rationale: Semi-structured data (JSON, XML) contains organizational tags or markers but
doesn't conform to the rigid tabular structure of relational databases. Structured data uses
rows/columns, unstructured data has no organization, and processed warehouse data describes a
state rather than a data type.
Q3: A data steward is responsible for which of the following activities?
• A. Designing the technical database architecture
• B. Defining business rules and ensuring data quality within their domain [CORRECT]
• C. Writing all SQL queries for the organization
• D. Managing network security infrastructure
Correct Answer: B
Rationale: Data stewards are business-focused roles responsible for data quality, business rule
definition, and domain-specific data governance within their area. Database architecture is
typically a DBA function, SQL development is performed by analysts/developers, and network
security is an IT security function.
Q4: Which data quality dimension ensures that data represents real-world values correctly?
• A. Completeness
• B. Validity
• C. Accuracy [CORRECT]
• D. Consistency
Correct Answer: C
Rationale: Accuracy measures whether data correctly represents the real-world values it
purports to describe. Completeness ensures all required data is present, validity checks
conformance to defined formats/rules, and consistency ensures uniformity across systems.
Q5: Social media posts, images, and video content are examples of:
• A. Structured data
• B. Semi-structured data
• C. Unstructured data [CORRECT]
,3
• D. Metadata
Correct Answer: C
Rationale: Unstructured data lacks predefined organizational format or schema. Text, images,
audio, and video content don't conform to rigid data models. Structured data fits relational tables,
semi-structured uses tags/markup, and metadata describes other data.
Q6: A retail company purchases demographic information from a third-party provider to enhance
their customer profiles. This represents:
• A. Internal data source
• B. External data source [CORRECT]
• C. Primary data source
• D. Metadata source
Correct Answer: B
Rationale: External data sources originate outside the organization, including third-party data
providers, public datasets, and social media. Internal sources come from within the organization
(CRM, ERP), primary data is collected firsthand, and metadata describes data characteristics.
Q7: Which component of data governance focuses on documenting data definitions, lineage, and
business context?
• A. Data quality management
• B. Metadata management [CORRECT]
• C. Master data management
• D. Data security management
Correct Answer: B
Rationale: Metadata management involves creating and maintaining documentation about data
including definitions, lineage (origin and transformations), and business context. Data quality
focuses on accuracy/completeness, master data manages core business entities, and security
manages access controls.
, 4
Q8: A database contains two records for the same customer with slightly different names: "John
Smith" and "Jon Smith." This represents a violation of which data quality dimension?
• A. Validity
• B. Timeliness
• C. Uniqueness [CORRECT]
• D. Consistency
Correct Answer: C
Rationale: Uniqueness requires that each real-world entity be represented only once in the
dataset. Duplicate records for the same customer violate uniqueness. Validity concerns format
conformance, timeliness concerns currency, and consistency concerns cross-system uniformity.
Q9: In the data lifecycle, which phase involves determining how long data should be retained
and when it should be archived or deleted?
• A. Data creation
• B. Data storage
• C. Data usage
• D. Data retention and disposal [CORRECT]
Correct Answer: D
Rationale: The retention and disposal phase establishes policies for data archiving, retention
periods, and secure deletion. Creation involves data generation, storage involves physical
maintenance, and usage involves active data access and analysis.
Q10: Which of the following is an example of internal structured data?
• A. Twitter feeds about company products
• B. Transaction records from the company's ERP system [CORRECT]
• C. Weather data from a government website
• D. Industry benchmark reports
Correct Answer: B
WGU D465 DATA APPLICATIONS EXAM
OA TEST BANK Actual Exam 2026/2027
Complete Questions and Verified Answers
Pass Guaranteed - A+ Graded
SECTION 1: DATA FUNDAMENTALS (Questions 1-15)
Q1: A company has customer data stored in multiple systems with inconsistent formats. For
example, one system stores phone numbers as (555) 123-4567, while another stores them as 555-
123-4567. This is an example of poor data quality in which dimension?
• A. Accuracy
• B. Consistency [CORRECT]
• C. Timeliness
• D. Uniqueness
Correct Answer: B
Rationale: Consistency refers to data being uniform across different systems or datasets.
Inconsistent formatting of the same data type across systems represents a consistency issue.
Accuracy would involve incorrect values, timeliness refers to data currency, and uniqueness
concerns duplicate records.
Q2: Which of the following best describes semi-structured data?
• A. Data organized in fixed rows and columns with rigid schema
• B. Data with no predefined format or organization
• C. Data that contains tags or markers to separate elements but lacks rigid tabular structure
[CORRECT]
• D. Data that has been processed through ETL and stored in a data warehouse
Correct Answer: C
,2
Rationale: Semi-structured data (JSON, XML) contains organizational tags or markers but
doesn't conform to the rigid tabular structure of relational databases. Structured data uses
rows/columns, unstructured data has no organization, and processed warehouse data describes a
state rather than a data type.
Q3: A data steward is responsible for which of the following activities?
• A. Designing the technical database architecture
• B. Defining business rules and ensuring data quality within their domain [CORRECT]
• C. Writing all SQL queries for the organization
• D. Managing network security infrastructure
Correct Answer: B
Rationale: Data stewards are business-focused roles responsible for data quality, business rule
definition, and domain-specific data governance within their area. Database architecture is
typically a DBA function, SQL development is performed by analysts/developers, and network
security is an IT security function.
Q4: Which data quality dimension ensures that data represents real-world values correctly?
• A. Completeness
• B. Validity
• C. Accuracy [CORRECT]
• D. Consistency
Correct Answer: C
Rationale: Accuracy measures whether data correctly represents the real-world values it
purports to describe. Completeness ensures all required data is present, validity checks
conformance to defined formats/rules, and consistency ensures uniformity across systems.
Q5: Social media posts, images, and video content are examples of:
• A. Structured data
• B. Semi-structured data
• C. Unstructured data [CORRECT]
,3
• D. Metadata
Correct Answer: C
Rationale: Unstructured data lacks predefined organizational format or schema. Text, images,
audio, and video content don't conform to rigid data models. Structured data fits relational tables,
semi-structured uses tags/markup, and metadata describes other data.
Q6: A retail company purchases demographic information from a third-party provider to enhance
their customer profiles. This represents:
• A. Internal data source
• B. External data source [CORRECT]
• C. Primary data source
• D. Metadata source
Correct Answer: B
Rationale: External data sources originate outside the organization, including third-party data
providers, public datasets, and social media. Internal sources come from within the organization
(CRM, ERP), primary data is collected firsthand, and metadata describes data characteristics.
Q7: Which component of data governance focuses on documenting data definitions, lineage, and
business context?
• A. Data quality management
• B. Metadata management [CORRECT]
• C. Master data management
• D. Data security management
Correct Answer: B
Rationale: Metadata management involves creating and maintaining documentation about data
including definitions, lineage (origin and transformations), and business context. Data quality
focuses on accuracy/completeness, master data manages core business entities, and security
manages access controls.
, 4
Q8: A database contains two records for the same customer with slightly different names: "John
Smith" and "Jon Smith." This represents a violation of which data quality dimension?
• A. Validity
• B. Timeliness
• C. Uniqueness [CORRECT]
• D. Consistency
Correct Answer: C
Rationale: Uniqueness requires that each real-world entity be represented only once in the
dataset. Duplicate records for the same customer violate uniqueness. Validity concerns format
conformance, timeliness concerns currency, and consistency concerns cross-system uniformity.
Q9: In the data lifecycle, which phase involves determining how long data should be retained
and when it should be archived or deleted?
• A. Data creation
• B. Data storage
• C. Data usage
• D. Data retention and disposal [CORRECT]
Correct Answer: D
Rationale: The retention and disposal phase establishes policies for data archiving, retention
periods, and secure deletion. Creation involves data generation, storage involves physical
maintenance, and usage involves active data access and analysis.
Q10: Which of the following is an example of internal structured data?
• A. Twitter feeds about company products
• B. Transaction records from the company's ERP system [CORRECT]
• C. Weather data from a government website
• D. Industry benchmark reports
Correct Answer: B
