WGU D075 Exam 2026 – Complete Study Guide & Practice
Questions with Answers | Latest Updates
Section 1: Database & Data Management (Questions 1-15)
Q1. What is the main purpose of a database?
A. Store data securely
B. Improve programming performance
C. Organize and manage data efficiently
D. Delete data automatically
Answer: C
Rationale: Databases are designed to organize, store, and retrieve data
efficiently.
Q2. Which of the following is a collection of related data organized into rows
and columns?
A. Tuple
B. Table
C. Key
D. Schema
Answer: B
Rationale: A table (relation) stores records in rows and attributes in columns.
Q3. In an Entity-Relationship (ER) diagram, what does a diamond shape
represent?
A. Entity
B. Attribute
C. Relationship
D. Key
,Answer: C
Rationale: Diamonds depict relationships between entities. Rectangles represent
entities; ovals represent attributes.
Q4. A foreign key is used to:
A. Store large text
B. Identify duplicates
C. Link tables together
D. Encrypt data
Answer: C
Rationale: Foreign keys create relationships between tables by linking a column in
one table to the primary key in another.
Q5. What is denormalization?
A. Making data more complex
B. Reducing the number of tables
C. Combining tables to improve performance
D. Increasing redundancy
Answer: C
Rationale: Denormalization strategically adds redundancy to improve read
performance.
Q6. A marketing employee is tasked with mailing discount coupons to the
company's top 100 customers by sales volume. Which process should this
employee use?
A. Data structuring
B. Data warehousing
C. Data mining
D. Data intelligence
,Answer: C
Rationale: Data mining involves analyzing data to find patterns or valuable
information, such as identifying top customers by sales.
Q7. What is the key characteristic that differentiates a datamart from a data
warehouse?
A. A datamart uses centralized data storage while a data warehouse is
decentralized
B. A datamart is a cloud-based service while a data warehouse requires a
dedicated server
C. A datamart is smaller and more specialized in its focus than a data warehouse
D. A datamart allows a broader set of data structures than a data warehouse
Answer: C
Rationale: A datamart is a subset of a data warehouse, focused on a specific
business line or team.
Q8. When using ETL (Extract, Transform, Load), what is done during the
"transform" step?
A. The data are normalized and structured
B. The data are given context and relevance
C. The database is queried for relevant data
D. The database schema is designed and created
Answer: A
Rationale: During the transform step, data are normalized and structured to
prepare for loading.
Q9. What are scrubbed data?
A. Data organized into database tables
B. Data that have been validated for accuracy
C. Data eliminated because they are inconsistent
D. Data deleted for privacy reasons
, Answer: B
Rationale: Scrubbing (data cleansing) validates data for accuracy and consistency.
Q10. Which term is used to refer to data that come from many different sources
in various structures?
A. Unstructured data
B. Disparate data
C. Semistructured data
D. Source data
Answer: B
Rationale: Disparate data comes from many different sources in various
structures.
Q11. What is the velocity of big data?
A. The processing speed of database servers
B. The rate at which data becomes decayed
C. The speed of data produced in a given time
D. The frequency with which the data set must be updated
Answer: C
Rationale: Velocity refers to the speed at which data is generated.
Q12. What is data governance?
A. Procedures for data storage only
B. Procedures ensuring corporate data is accurate, valid, and managed properly
C. Unrelated to IT personnel and managers
D. Only concerned with data retrieval processes
Answer: B
Rationale: Data governance involves establishing procedures and policies to
ensure data is accurate, valid, and properly managed.
Questions with Answers | Latest Updates
Section 1: Database & Data Management (Questions 1-15)
Q1. What is the main purpose of a database?
A. Store data securely
B. Improve programming performance
C. Organize and manage data efficiently
D. Delete data automatically
Answer: C
Rationale: Databases are designed to organize, store, and retrieve data
efficiently.
Q2. Which of the following is a collection of related data organized into rows
and columns?
A. Tuple
B. Table
C. Key
D. Schema
Answer: B
Rationale: A table (relation) stores records in rows and attributes in columns.
Q3. In an Entity-Relationship (ER) diagram, what does a diamond shape
represent?
A. Entity
B. Attribute
C. Relationship
D. Key
,Answer: C
Rationale: Diamonds depict relationships between entities. Rectangles represent
entities; ovals represent attributes.
Q4. A foreign key is used to:
A. Store large text
B. Identify duplicates
C. Link tables together
D. Encrypt data
Answer: C
Rationale: Foreign keys create relationships between tables by linking a column in
one table to the primary key in another.
Q5. What is denormalization?
A. Making data more complex
B. Reducing the number of tables
C. Combining tables to improve performance
D. Increasing redundancy
Answer: C
Rationale: Denormalization strategically adds redundancy to improve read
performance.
Q6. A marketing employee is tasked with mailing discount coupons to the
company's top 100 customers by sales volume. Which process should this
employee use?
A. Data structuring
B. Data warehousing
C. Data mining
D. Data intelligence
,Answer: C
Rationale: Data mining involves analyzing data to find patterns or valuable
information, such as identifying top customers by sales.
Q7. What is the key characteristic that differentiates a datamart from a data
warehouse?
A. A datamart uses centralized data storage while a data warehouse is
decentralized
B. A datamart is a cloud-based service while a data warehouse requires a
dedicated server
C. A datamart is smaller and more specialized in its focus than a data warehouse
D. A datamart allows a broader set of data structures than a data warehouse
Answer: C
Rationale: A datamart is a subset of a data warehouse, focused on a specific
business line or team.
Q8. When using ETL (Extract, Transform, Load), what is done during the
"transform" step?
A. The data are normalized and structured
B. The data are given context and relevance
C. The database is queried for relevant data
D. The database schema is designed and created
Answer: A
Rationale: During the transform step, data are normalized and structured to
prepare for loading.
Q9. What are scrubbed data?
A. Data organized into database tables
B. Data that have been validated for accuracy
C. Data eliminated because they are inconsistent
D. Data deleted for privacy reasons
, Answer: B
Rationale: Scrubbing (data cleansing) validates data for accuracy and consistency.
Q10. Which term is used to refer to data that come from many different sources
in various structures?
A. Unstructured data
B. Disparate data
C. Semistructured data
D. Source data
Answer: B
Rationale: Disparate data comes from many different sources in various
structures.
Q11. What is the velocity of big data?
A. The processing speed of database servers
B. The rate at which data becomes decayed
C. The speed of data produced in a given time
D. The frequency with which the data set must be updated
Answer: C
Rationale: Velocity refers to the speed at which data is generated.
Q12. What is data governance?
A. Procedures for data storage only
B. Procedures ensuring corporate data is accurate, valid, and managed properly
C. Unrelated to IT personnel and managers
D. Only concerned with data retrieval processes
Answer: B
Rationale: Data governance involves establishing procedures and policies to
ensure data is accurate, valid, and properly managed.
