WGU D426 Data Management Foundations Exam Prep
| Versions A, B & C with 400 Verified Questions Each,
Detailed Correct Answers & Complete Study Guide
WGU D426 — DATA MANAGEMENT FOUNDATIONS
EXAM PREP | VERSIONS A, B & C | 400 QUESTIONS
Complete Study Guide with CORRECT ANSWER & RATIONALE
SECTION 1: DATABASE CONCEPTS & FUNDAMENTALS
Q1. What is a database?
A. A collection of unrelated text files stored on a hard drive B. A single spreadsheet used
to record transactions C. An organized collection of structured data stored and
accessed electronically D. A programming language used to write software applications
E. A hardware component used to increase processing speed
CORRECT ANSWER: C. An organized collection of structured data stored and
accessed electronically RATIONALE: A database is formally defined as an
organized collection of structured information or data, typically stored electronically in a
computer system and controlled by a Database Management System (DBMS).
Q2. What is a Database Management System (DBMS)?
A. A type of network protocol used to transmit data B. Software that interacts with users,
applications, and the database to capture and analyze data C. A hardware device used
to store backup copies of data D. A programming language exclusively for web
development E. A type of spreadsheet used in financial analysis
CORRECT ANSWER: B. Software that interacts with users, applications, and the
database to capture and analyze data RATIONALE: A DBMS is software that
manages databases, providing an interface for users and applications to store, retrieve,
and manage data efficiently and securely.
Q3. Which of the following is NOT a function of a DBMS?
,A. Data storage management B. Data security and access control C. Compiling
programming languages into machine code D. Backup and recovery E. Data integrity
enforcement
CORRECT ANSWER: C. Compiling programming languages into machine code
RATIONALE: Compiling programming languages is the function of a compiler, not a
DBMS. A DBMS handles storage, security, integrity, backup/recovery, and query
processing.
Q4. What type of database model organizes data into tables with rows and
columns?
A. Hierarchical model B. Network model C. Relational model D. Object-oriented model
E. Document model
CORRECT ANSWER: C. Relational model RATIONALE: The relational model,
introduced by E.F. Codd in 1970, organizes data into tables (relations) consisting of
rows (tuples) and columns (attributes), which is the foundation of modern relational
databases.
Q5. What is a schema in database terminology?
A. A backup copy of the database B. A type of SQL query used to retrieve data C. The
logical structure or blueprint of a database D. A hardware component used in database
servers E. A unique identifier assigned to each record
CORRECT ANSWER: C. The logical structure or blueprint of a database
RATIONALE: A schema defines the logical structure of the database, including tables,
fields, data types, and relationships. It acts as a blueprint that describes how data is
organized.
Q6. Which of the following best describes data independence?
A. The ability to store data without a DBMS B. The separation of data descriptions from
the application programs that use the data C. The use of encrypted passwords to
protect data D. The duplication of data across multiple servers E. The ability of a
database to run on multiple hardware platforms
, CORRECT ANSWER: B. The separation of data descriptions from the application
programs that use the data RATIONALE: Data independence means changes to
data storage structures do not require changes to application programs. It includes
physical data independence (changing storage) and logical data independence
(changing schema).
Q7. What is metadata in the context of databases?
A. Data that has been deleted from the database B. The actual data stored in database
tables C. Data that describes other data, such as field names and data types D.
Encrypted data stored for security purposes E. Data retrieved from external APIs
CORRECT ANSWER: C. Data that describes other data, such as field names and
data types RATIONALE: Metadata is "data about data." In databases, it includes
information like table names, column names, data types, constraints, and relationships
— stored in the data dictionary.
Q8. What is a data dictionary?
A. A glossary of business terms used by end users B. A repository of metadata that
describes the structure of the database C. A list of passwords for database users D. A
document containing SQL query templates E. A backup file storing historical
transactions
CORRECT ANSWER: B. A repository of metadata that describes the structure of the
database RATIONALE: A data dictionary (also called a system catalog) stores
metadata about the database, including definitions of tables, columns, data types,
constraints, and relationships, helping the DBMS manage and enforce the database
structure.
Q9. Which term refers to the collection of all data stored in a database at a
particular moment in time?
A. Schema B. Instance C. Query D. Transaction E. Relation
CORRECT ANSWER: B. Instance RATIONALE: A database instance refers to
the actual data stored in the database at a specific point in time, as opposed to the
schema which is the structural definition. The instance changes as data is inserted,
updated, or deleted.
, Q10. What is the primary purpose of normalization in database design?
A. To increase the physical speed of hardware B. To encrypt sensitive data fields C. To
reduce data redundancy and improve data integrity D. To create backup copies of the
database E. To assign unique IDs to every user account
CORRECT ANSWER: C. To reduce data redundancy and improve data integrity
RATIONALE: Normalization is the process of organizing a database to reduce
redundancy and dependency by dividing large tables into smaller ones and defining
relationships. It helps maintain data integrity and reduces anomalies.
Q11. Which of the following is an advantage of using a DBMS over a flat-file
system?
A. Flat-file systems provide better security features B. DBMS allows multiple users to
access data concurrently while maintaining integrity C. Flat-file systems offer superior
data recovery options D. DBMS always stores data in a more compressed format E.
Flat-file systems support complex queries better than DBMS
CORRECT ANSWER: B. DBMS allows multiple users to access data concurrently
while maintaining integrity RATIONALE: A key advantage of a DBMS is its ability
to handle concurrent access by multiple users while enforcing data integrity, security,
and consistency — features not available in simple flat-file systems.
Q12. What does the term "data redundancy" mean in database management?
A. Backing up data to a secondary server B. Storing the same data in multiple places
unnecessarily C. Encrypting data to prevent unauthorized access D. Using multiple data
types for a single field E. Creating multiple indexes on the same column
CORRECT ANSWER: B. Storing the same data in multiple places unnecessarily
RATIONALE: Data redundancy occurs when the same piece of data is stored in
multiple locations unnecessarily, leading to inconsistencies, wasted storage space, and
update anomalies — problems that normalization aims to solve.
Q13. Which level of the ANSI/SPARC three-schema architecture deals with the
physical storage of data?
| Versions A, B & C with 400 Verified Questions Each,
Detailed Correct Answers & Complete Study Guide
WGU D426 — DATA MANAGEMENT FOUNDATIONS
EXAM PREP | VERSIONS A, B & C | 400 QUESTIONS
Complete Study Guide with CORRECT ANSWER & RATIONALE
SECTION 1: DATABASE CONCEPTS & FUNDAMENTALS
Q1. What is a database?
A. A collection of unrelated text files stored on a hard drive B. A single spreadsheet used
to record transactions C. An organized collection of structured data stored and
accessed electronically D. A programming language used to write software applications
E. A hardware component used to increase processing speed
CORRECT ANSWER: C. An organized collection of structured data stored and
accessed electronically RATIONALE: A database is formally defined as an
organized collection of structured information or data, typically stored electronically in a
computer system and controlled by a Database Management System (DBMS).
Q2. What is a Database Management System (DBMS)?
A. A type of network protocol used to transmit data B. Software that interacts with users,
applications, and the database to capture and analyze data C. A hardware device used
to store backup copies of data D. A programming language exclusively for web
development E. A type of spreadsheet used in financial analysis
CORRECT ANSWER: B. Software that interacts with users, applications, and the
database to capture and analyze data RATIONALE: A DBMS is software that
manages databases, providing an interface for users and applications to store, retrieve,
and manage data efficiently and securely.
Q3. Which of the following is NOT a function of a DBMS?
,A. Data storage management B. Data security and access control C. Compiling
programming languages into machine code D. Backup and recovery E. Data integrity
enforcement
CORRECT ANSWER: C. Compiling programming languages into machine code
RATIONALE: Compiling programming languages is the function of a compiler, not a
DBMS. A DBMS handles storage, security, integrity, backup/recovery, and query
processing.
Q4. What type of database model organizes data into tables with rows and
columns?
A. Hierarchical model B. Network model C. Relational model D. Object-oriented model
E. Document model
CORRECT ANSWER: C. Relational model RATIONALE: The relational model,
introduced by E.F. Codd in 1970, organizes data into tables (relations) consisting of
rows (tuples) and columns (attributes), which is the foundation of modern relational
databases.
Q5. What is a schema in database terminology?
A. A backup copy of the database B. A type of SQL query used to retrieve data C. The
logical structure or blueprint of a database D. A hardware component used in database
servers E. A unique identifier assigned to each record
CORRECT ANSWER: C. The logical structure or blueprint of a database
RATIONALE: A schema defines the logical structure of the database, including tables,
fields, data types, and relationships. It acts as a blueprint that describes how data is
organized.
Q6. Which of the following best describes data independence?
A. The ability to store data without a DBMS B. The separation of data descriptions from
the application programs that use the data C. The use of encrypted passwords to
protect data D. The duplication of data across multiple servers E. The ability of a
database to run on multiple hardware platforms
, CORRECT ANSWER: B. The separation of data descriptions from the application
programs that use the data RATIONALE: Data independence means changes to
data storage structures do not require changes to application programs. It includes
physical data independence (changing storage) and logical data independence
(changing schema).
Q7. What is metadata in the context of databases?
A. Data that has been deleted from the database B. The actual data stored in database
tables C. Data that describes other data, such as field names and data types D.
Encrypted data stored for security purposes E. Data retrieved from external APIs
CORRECT ANSWER: C. Data that describes other data, such as field names and
data types RATIONALE: Metadata is "data about data." In databases, it includes
information like table names, column names, data types, constraints, and relationships
— stored in the data dictionary.
Q8. What is a data dictionary?
A. A glossary of business terms used by end users B. A repository of metadata that
describes the structure of the database C. A list of passwords for database users D. A
document containing SQL query templates E. A backup file storing historical
transactions
CORRECT ANSWER: B. A repository of metadata that describes the structure of the
database RATIONALE: A data dictionary (also called a system catalog) stores
metadata about the database, including definitions of tables, columns, data types,
constraints, and relationships, helping the DBMS manage and enforce the database
structure.
Q9. Which term refers to the collection of all data stored in a database at a
particular moment in time?
A. Schema B. Instance C. Query D. Transaction E. Relation
CORRECT ANSWER: B. Instance RATIONALE: A database instance refers to
the actual data stored in the database at a specific point in time, as opposed to the
schema which is the structural definition. The instance changes as data is inserted,
updated, or deleted.
, Q10. What is the primary purpose of normalization in database design?
A. To increase the physical speed of hardware B. To encrypt sensitive data fields C. To
reduce data redundancy and improve data integrity D. To create backup copies of the
database E. To assign unique IDs to every user account
CORRECT ANSWER: C. To reduce data redundancy and improve data integrity
RATIONALE: Normalization is the process of organizing a database to reduce
redundancy and dependency by dividing large tables into smaller ones and defining
relationships. It helps maintain data integrity and reduces anomalies.
Q11. Which of the following is an advantage of using a DBMS over a flat-file
system?
A. Flat-file systems provide better security features B. DBMS allows multiple users to
access data concurrently while maintaining integrity C. Flat-file systems offer superior
data recovery options D. DBMS always stores data in a more compressed format E.
Flat-file systems support complex queries better than DBMS
CORRECT ANSWER: B. DBMS allows multiple users to access data concurrently
while maintaining integrity RATIONALE: A key advantage of a DBMS is its ability
to handle concurrent access by multiple users while enforcing data integrity, security,
and consistency — features not available in simple flat-file systems.
Q12. What does the term "data redundancy" mean in database management?
A. Backing up data to a secondary server B. Storing the same data in multiple places
unnecessarily C. Encrypting data to prevent unauthorized access D. Using multiple data
types for a single field E. Creating multiple indexes on the same column
CORRECT ANSWER: B. Storing the same data in multiple places unnecessarily
RATIONALE: Data redundancy occurs when the same piece of data is stored in
multiple locations unnecessarily, leading to inconsistencies, wasted storage space, and
update anomalies — problems that normalization aims to solve.
Q13. Which level of the ANSI/SPARC three-schema architecture deals with the
physical storage of data?
