WGU D345 Data Management
Foundations exam with verified
answers and rationale updated 2026
graded A+
SECTION 1: Database Fundamentals (Questions 1-15)
1. What is a database?
A) A single spreadsheet file
B) An organized collection of structured data stored electronically
C) A programming language
D) A type of computer hardware
Answer: B
Rationale: A database is a systematic collection of data organized for easy access, management, and
updating, typically stored and accessed electronically via a DBMS.
2. What does DBMS stand for?
A) Database Management System
B) Data Base Multiple Server
C) Database Model Structure
D) Data Backup Management Software
Answer: A
Rationale: DBMS (Database Management System) is software that interacts with users, applications,
and the database to capture and analyze data.
3. Which of the following is an example of a DBMS?
A) Microsoft Word
B) MySQL
,C) Adobe Photoshop
D) Google Chrome
Answer: B
Rationale: MySQL is a popular relational database management system used to create, manage, and
manipulate databases.
4. What is the primary purpose of a database schema?
A) To store actual data
B) To define the logical structure of the database
C) To backup data
D) To encrypt data
Answer: B
Rationale: A schema defines the organization of data, including tables, fields, relationships, and
constraints within the database.
5. What is data redundancy?
A) Having backup copies of data
B) Unnecessary duplication of data within a database
C) Data that is no longer needed
D) Encrypted data
Answer: B
Rationale: Data redundancy occurs when the same piece of data is stored in multiple places, which
can lead to inconsistency and wasted storage.
6. What is data integrity?
A) The physical security of data
B) The accuracy, consistency, and reliability of data
C) The speed of data retrieval
D) The size of the database
,Answer: B
Rationale: Data integrity refers to maintaining and assuring the accuracy and consistency of data
over its entire lifecycle.
7. Which type of database organizes data into tables with rows and columns?
A) Hierarchical database
B) Network database
C) Relational database
D) Object-oriented database
Answer: C
Rationale: Relational databases organize data into tables (relations) consisting of rows (records) and
columns (attributes).
8. What is a flat file database?
A) A database with multiple related tables
B) A single table database with no relationships to other tables
C) A cloud-based database
D) A database with 3D visualization
Answer: B
Rationale: A flat file database stores data in a single table format without relationships to other
tables, unlike relational databases.
9. What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Access, Control, Identity, Data
C) Automatic, Continuous, Integrated, Distributed
D) Analysis, Compilation, Integration, Deployment
Answer: A
, Rationale: ACID properties ensure reliable database transactions: Atomicity (all-or-nothing),
Consistency (valid state), Isolation (concurrent transactions don't interfere), Durability (permanent
once committed).
10. What is the main advantage of using a database over a spreadsheet for large datasets?
A) Databases are always free
B) Databases provide better data integrity, security, and can handle relationships between data
C) Spreadsheets are more secure
D) There is no difference
Answer: B
Rationale: Databases offer superior data integrity through constraints, better security features, and
the ability to model complex relationships between different data entities.
11. What is a data dictionary?
A) A physical book about databases
B) A repository of information describing data elements in a database
C) A type of database software
D) A backup system
Answer: B
Rationale: A data dictionary is a centralized repository of metadata that describes the structure,
content, and relationships of data elements in a database.
12. What is metadata?
A) Data about data
B) Corrupted data
C) The largest table in a database
D) Encrypted data
Answer: A
Rationale: Metadata provides information about other data, such as data type, size, and
relationships, helping describe and organize the actual data.
Foundations exam with verified
answers and rationale updated 2026
graded A+
SECTION 1: Database Fundamentals (Questions 1-15)
1. What is a database?
A) A single spreadsheet file
B) An organized collection of structured data stored electronically
C) A programming language
D) A type of computer hardware
Answer: B
Rationale: A database is a systematic collection of data organized for easy access, management, and
updating, typically stored and accessed electronically via a DBMS.
2. What does DBMS stand for?
A) Database Management System
B) Data Base Multiple Server
C) Database Model Structure
D) Data Backup Management Software
Answer: A
Rationale: DBMS (Database Management System) is software that interacts with users, applications,
and the database to capture and analyze data.
3. Which of the following is an example of a DBMS?
A) Microsoft Word
B) MySQL
,C) Adobe Photoshop
D) Google Chrome
Answer: B
Rationale: MySQL is a popular relational database management system used to create, manage, and
manipulate databases.
4. What is the primary purpose of a database schema?
A) To store actual data
B) To define the logical structure of the database
C) To backup data
D) To encrypt data
Answer: B
Rationale: A schema defines the organization of data, including tables, fields, relationships, and
constraints within the database.
5. What is data redundancy?
A) Having backup copies of data
B) Unnecessary duplication of data within a database
C) Data that is no longer needed
D) Encrypted data
Answer: B
Rationale: Data redundancy occurs when the same piece of data is stored in multiple places, which
can lead to inconsistency and wasted storage.
6. What is data integrity?
A) The physical security of data
B) The accuracy, consistency, and reliability of data
C) The speed of data retrieval
D) The size of the database
,Answer: B
Rationale: Data integrity refers to maintaining and assuring the accuracy and consistency of data
over its entire lifecycle.
7. Which type of database organizes data into tables with rows and columns?
A) Hierarchical database
B) Network database
C) Relational database
D) Object-oriented database
Answer: C
Rationale: Relational databases organize data into tables (relations) consisting of rows (records) and
columns (attributes).
8. What is a flat file database?
A) A database with multiple related tables
B) A single table database with no relationships to other tables
C) A cloud-based database
D) A database with 3D visualization
Answer: B
Rationale: A flat file database stores data in a single table format without relationships to other
tables, unlike relational databases.
9. What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Access, Control, Identity, Data
C) Automatic, Continuous, Integrated, Distributed
D) Analysis, Compilation, Integration, Deployment
Answer: A
, Rationale: ACID properties ensure reliable database transactions: Atomicity (all-or-nothing),
Consistency (valid state), Isolation (concurrent transactions don't interfere), Durability (permanent
once committed).
10. What is the main advantage of using a database over a spreadsheet for large datasets?
A) Databases are always free
B) Databases provide better data integrity, security, and can handle relationships between data
C) Spreadsheets are more secure
D) There is no difference
Answer: B
Rationale: Databases offer superior data integrity through constraints, better security features, and
the ability to model complex relationships between different data entities.
11. What is a data dictionary?
A) A physical book about databases
B) A repository of information describing data elements in a database
C) A type of database software
D) A backup system
Answer: B
Rationale: A data dictionary is a centralized repository of metadata that describes the structure,
content, and relationships of data elements in a database.
12. What is metadata?
A) Data about data
B) Corrupted data
C) The largest table in a database
D) Encrypted data
Answer: A
Rationale: Metadata provides information about other data, such as data type, size, and
relationships, helping describe and organize the actual data.
