WGU D426 Data Management
Foundations Assessment 2026/2027 –
Verified Q&As with Detailed Rationales
(Test Bank Bundle - 58 Questions)
---
*QUESTION 1:*
Which of the following is a characteristic of a relational database?
A) Data is organized into tables with rows and columns
B) Data is stored as key-value pairs
C) Data is stored in a hierarchical structure
D) Data is stored as documents
> 🎯 *CORRECT ANSWER:* A) Data is organized into tables with rows and columns
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Relational databases use a tabular structure.
> * *Why Distractors Fail:* Key-value, hierarchical, and document are NoSQL models.
> * *Core Takeaway:* Tables define relational databases.
---
*QUESTION 2:*
What is the primary purpose of a primary key in a database table?
A) To uniquely identify each row
,B) To create a relationship with another table
C) To sort the data
D) To enforce data types
> 🎯 *CORRECT ANSWER:* A) To uniquely identify each row
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Primary keys ensure each record is unique.
> * *Why Distractors Fail:* Foreign keys create relationships; sorting and data types are separate.
> * *Core Takeaway:* Primary keys enforce uniqueness.
---
*QUESTION 3:*
A foreign key is used to:
A) Create a relationship between two tables
B) Uniquely identify a row
C) Sort the data in a table
D) Enforce a data type
> 🎯 *CORRECT ANSWER:* A) Create a relationship between two tables
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Foreign keys link tables and enforce referential integrity.
> * *Why Distractors Fail:* Primary keys identify rows; sorting and data types are separate.
> * *Core Takeaway:* Foreign keys define relationships.
---
*QUESTION 4:*
Which SQL statement is used to retrieve data from a database?
,A) SELECT
B) INSERT
C) UPDATE
D) DELETE
> 🎯 *CORRECT ANSWER:* A) SELECT
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* SELECT is the query statement for data retrieval.
> * *Why Distractors Fail:* INSERT adds; UPDATE modifies; DELETE removes data.
> * *Core Takeaway:* SELECT is for reading data.
---
*QUESTION 5:*
A database table has a column with a data type of INT. What type of data does it store?
A) Integer numbers
B) String data
C) Date data
D) Decimal numbers
> 🎯 *CORRECT ANSWER:* A) Integer numbers
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* INT stores whole numbers.
> * *Why Distractors Fail:* VARCHAR stores strings; DATE stores dates; DECIMAL stores decimals.
> * *Core Takeaway:* INT is for integer data.
---
*QUESTION 6:*
, What is the purpose of normalization in database design?
A) To reduce data redundancy and improve data integrity
B) To increase data redundancy
C) To make queries slower
D) To store data as documents
> 🎯 *CORRECT ANSWER:* A) To reduce data redundancy and improve data integrity
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Normalization organizes data to reduce duplication.
> * *Why Distractors Fail:* It reduces redundancy, improves performance, and is not for document
storage.
> * *Core Takeaway:* Normalization reduces redundancy.
---
*QUESTION 7:*
A table is in 1NF if it:
A) Has no repeating groups
B) Has no partial dependencies
C) Has no transitive dependencies
D) Has no foreign keys
> 🎯 *CORRECT ANSWER:* A) Has no repeating groups
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* 1NF eliminates repeating groups.
> * *Why Distractors Fail:* 2NF eliminates partial dependencies; 3NF eliminates transitive
dependencies.
> * *Core Takeaway:* 1NF addresses repeating groups.
Foundations Assessment 2026/2027 –
Verified Q&As with Detailed Rationales
(Test Bank Bundle - 58 Questions)
---
*QUESTION 1:*
Which of the following is a characteristic of a relational database?
A) Data is organized into tables with rows and columns
B) Data is stored as key-value pairs
C) Data is stored in a hierarchical structure
D) Data is stored as documents
> 🎯 *CORRECT ANSWER:* A) Data is organized into tables with rows and columns
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Relational databases use a tabular structure.
> * *Why Distractors Fail:* Key-value, hierarchical, and document are NoSQL models.
> * *Core Takeaway:* Tables define relational databases.
---
*QUESTION 2:*
What is the primary purpose of a primary key in a database table?
A) To uniquely identify each row
,B) To create a relationship with another table
C) To sort the data
D) To enforce data types
> 🎯 *CORRECT ANSWER:* A) To uniquely identify each row
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Primary keys ensure each record is unique.
> * *Why Distractors Fail:* Foreign keys create relationships; sorting and data types are separate.
> * *Core Takeaway:* Primary keys enforce uniqueness.
---
*QUESTION 3:*
A foreign key is used to:
A) Create a relationship between two tables
B) Uniquely identify a row
C) Sort the data in a table
D) Enforce a data type
> 🎯 *CORRECT ANSWER:* A) Create a relationship between two tables
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Foreign keys link tables and enforce referential integrity.
> * *Why Distractors Fail:* Primary keys identify rows; sorting and data types are separate.
> * *Core Takeaway:* Foreign keys define relationships.
---
*QUESTION 4:*
Which SQL statement is used to retrieve data from a database?
,A) SELECT
B) INSERT
C) UPDATE
D) DELETE
> 🎯 *CORRECT ANSWER:* A) SELECT
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* SELECT is the query statement for data retrieval.
> * *Why Distractors Fail:* INSERT adds; UPDATE modifies; DELETE removes data.
> * *Core Takeaway:* SELECT is for reading data.
---
*QUESTION 5:*
A database table has a column with a data type of INT. What type of data does it store?
A) Integer numbers
B) String data
C) Date data
D) Decimal numbers
> 🎯 *CORRECT ANSWER:* A) Integer numbers
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* INT stores whole numbers.
> * *Why Distractors Fail:* VARCHAR stores strings; DATE stores dates; DECIMAL stores decimals.
> * *Core Takeaway:* INT is for integer data.
---
*QUESTION 6:*
, What is the purpose of normalization in database design?
A) To reduce data redundancy and improve data integrity
B) To increase data redundancy
C) To make queries slower
D) To store data as documents
> 🎯 *CORRECT ANSWER:* A) To reduce data redundancy and improve data integrity
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Normalization organizes data to reduce duplication.
> * *Why Distractors Fail:* It reduces redundancy, improves performance, and is not for document
storage.
> * *Core Takeaway:* Normalization reduces redundancy.
---
*QUESTION 7:*
A table is in 1NF if it:
A) Has no repeating groups
B) Has no partial dependencies
C) Has no transitive dependencies
D) Has no foreign keys
> 🎯 *CORRECT ANSWER:* A) Has no repeating groups
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* 1NF eliminates repeating groups.
> * *Why Distractors Fail:* 2NF eliminates partial dependencies; 3NF eliminates transitive
dependencies.
> * *Core Takeaway:* 1NF addresses repeating groups.
