WGU D195 Data Management Foundations Theory Exam Review and Study Guide for Western Governors University Students | Database Fundamentals, Data Modeling Concepts, Relational Database Structures, SQL Basics, Data Governance, Information Security Principles

WGU D195 Data Management Foundations Theory Exam Review and Study
Guide for Western Governors University Students | Database
Fundamentals, Data Modeling Concepts, Relational Database Structures,
SQL Basics, Data Governance, Information Security Principles, Data
Quality Management and Database System Foundations Practice
Questions and Answers | Updated 2026 Assessment Preparation
Resource
Question 1:
Which of the following is NOT a characteristic of a relational database?
A) Data is organized into tables
B) Relationships between tables are defined by foreign keys
C) Data is stored in flat files
D) Each table has a primary key
Correct Option: C)
Rationale: A relational database uses structured tables to store data rather than flat
files. Flat files do not support relationships or complex queries, which are fundamental
in relational databases.


Question 2:
In the context of data governance, which principle is primarily concerned with ensuring
that data is accurate and trustworthy?
A) Data Stewardship
B) Data Quality
C) Data Accessibility
D) Data Privacy
Correct Option: B)
Rationale: Data Quality is the principle focused on ensuring that data is accurate,
reliable, and timely. It encompasses the processes and standards that maintain the
integrity of data, which is crucial for informed decision-making.


Question 3:
Which normalization form eliminates transitive dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)

,Correct Option: C)
Rationale: Third Normal Form (3NF) is achieved when a database is in Second Normal
Form (2NF) and all the attributes are functionally dependent only on the primary key,
thus eliminating transitive dependencies. This prevents redundancy and promotes data
integrity.


Question 4:
What is the primary purpose of a data warehouse?
A) To store operational data for transactional processing
B) To consolidate data from multiple sources for analysis
C) To support database transactions in real-time
D) To manage relational databases efficiently
Correct Option: B)
Rationale: A data warehouse is designed to consolidate data from different sources
into a central repository for analysis and reporting. Unlike operational databases, which
support day-to-day transactions, data warehouses focus on historical data and
analytics.


Question 5:
Which SQL command is used to remove a table and all of its data from a database?
A) DELETE
B) DROP
C) TRUNCATE
D) REMOVE
Correct Option: C)
Rationale: The TRUNCATE command is used to remove all rows from a table while
keeping the table structure intact. In contrast, the DROP command removes the table
entirely from the database schema.
Question 6:
Which of the following is a method used to ensure data integrity?
A) Data Backups
B) Data Normalization
C) Referential Integrity Constraints
D) Data Redundancy
Correct Option: C)
Rationale: Referential Integrity Constraints ensure that relationships between tables

,remain valid, meaning that foreign keys reliably point to existing primary keys. This helps
in maintaining consistent and accurate data.


Question 7:
What is the primary function of an Entity-Relationship Diagram (ERD)?
A) To define the database structure in SQL
B) To provide a visualization of database performance
C) To model data relationships and structure
D) To outline data governance policies
Correct Option: C)
Rationale: An Entity-Relationship Diagram (ERD) visually represents the relationships
among entities in a database, allowing for better understanding and communication of
the data model.


Question 8:
Which of the following database models emphasizes relationships between data?
A) Hierarchical Model
B) Network Model
C) Object-Oriented Model
D) Relational Model
Correct Option: D)
Rationale: The Relational Model organizes data into structured tables (relations) and
emphasizes how these tables relate to one another through the use of keys, thus
facilitating complex queries and relationships.


Question 9:
In data warehousing, what does ETL stand for?
A) Extract, Transform, Load
B) Evaluate, Transfer, Load
C) Extract, Transfer, Link
D) Enhance, Transform, Load
Correct Option: A)
Rationale: ETL stands for Extract, Transform, Load, which is a process used to move
data from source systems into the data warehouse, preparing it for analysis and
reporting by cleaning and transforming the data.

, Question 10:
Which SQL command is used to modify existing data in a table?
A) SELECT
B) DELETE
C) UPDATE
D) INSERT
Correct Option: C)
Rationale: The UPDATE command is specifically designed to modify existing records in
a table, allowing you to change values in one or more columns for the specified rows.


Question 11:
What does a primary key ensure in a relational database?
A) Uniqueness of records
B) Easy retrieval of data
C) Improved data compression
D) Data redundancy
Correct Option: A)
Rationale: A primary key is a unique identifier for each record in a table. It ensures that
no two records can have the same value for the primary key column(s), thus preserving
the uniqueness of data.


Question 12:
Which of the following describes a data lake?
A) A structured set of tables for specific queries
B) A storage repository for raw, unprocessed data
C) A system for analyzing structured data only
D) A method for data redundancy
Correct Option: B)
Rationale: A data lake is a centralized repository that holds vast amounts of raw data in
its native format until it is needed for analysis, thereby allowing for storage flexibility and
scalability compared to traditional databases.


Question 13:
What is the purpose of data profiling?