WGU D426 DATA MANAGEMENT - FOUNDATIONS
EXAM
Complete 150-Question Practice Test Bank | 2026 Update | Verified Answers with Rationales
SECTION 1: DATABASE FUNDAMENTALS & CORE CONCEPTS
Questions 1–25
Question 1
What is the broad definition of data?
A) Information processed by a computer
B) Raw facts captured on printed or digital media
C) The result of querying a database
D) Metadata about database structures
Correct answer: B
Rationale: Data is defined as raw facts that have not yet been processed or organized into
meaningful information. These facts can be captured on various media, including printed
documents and digital storage .
Question 2
What is the primary role of a database management system (DBMS)?
A) To store data in operating system files
B) To provide an interface for defining, creating, querying, updating, and administering
databases
C) To replace spreadsheets entirely
D) To compile Java programs
Correct answer: B
,Rationale: A DBMS is software that manages data, providing data definition, data manipulation,
and administration capabilities. It serves as an intermediary between users and the database .
Question 3
Which term refers to raw, unprocessed facts?
A) Information
B) Data
C) Metadata
D) Database
Correct answer: B
Rationale: Data are raw facts. Information is data that has been processed into a meaningful
context. Metadata is "data about data" .
Question 4
What is a determining characteristic of unstructured data?
A) It is always stored in tables
B) It does not follow a data model
C) It is easily queried with SQL
D) It has a rigid structure
Correct answer: B
Rationale: Unstructured data lacks a predefined data model or organization. Examples include
text documents, images, and videos. It does not fit neatly into tables like structured data .
Question 5
In the relational model, a row is formally called a:
A) Tuple
B) Attribute
C) Domain
,D) Schema
Correct answer: A
Rationale: Relational theory uses "tuple" for a row (record) and "attribute" for a column (field) .
Question 6
What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Consistency, Integrity, Durability
C) Atomicity, Concurrency, Isolation, Dependency
D) Accuracy, Concurrency, Integrity, Dependency
Correct answer: A
Rationale: ACID properties ensure reliable processing of database transactions .
Question 7
Which requirement within large, complex databases ensures users have limited access to the
database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
Correct answer: C
Rationale: Authorization ensures that users have appropriate permissions and limited access to
database resources based on their roles .
Question 8
Facts that are collected and stored in a database system are called:
, A) Information
B) Data
C) Metadata
D) Knowledge
Correct answer: B
Rationale: Data refers to the raw facts and figures that are collected and stored within a
database system. Information is processed data that has meaning .
Question 9
What is the difference between analog and digital data?
A) Analog data refer to data from before the invention of computers
B) There is no real difference
C) Analog data cannot be stored, while digital data are stored using computers
D) Analog data are continuous, while digital data are discrete
Correct answer: D
Rationale: Analog data are continuous in nature, while digital data are discrete and represented
by distinct values .
Question 10
Which design type specifies database requirements without regard to a specific database
system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
Correct answer: B
Rationale: Conceptual design focuses on identifying and describing data requirements
independently of any specific database management system .
EXAM
Complete 150-Question Practice Test Bank | 2026 Update | Verified Answers with Rationales
SECTION 1: DATABASE FUNDAMENTALS & CORE CONCEPTS
Questions 1–25
Question 1
What is the broad definition of data?
A) Information processed by a computer
B) Raw facts captured on printed or digital media
C) The result of querying a database
D) Metadata about database structures
Correct answer: B
Rationale: Data is defined as raw facts that have not yet been processed or organized into
meaningful information. These facts can be captured on various media, including printed
documents and digital storage .
Question 2
What is the primary role of a database management system (DBMS)?
A) To store data in operating system files
B) To provide an interface for defining, creating, querying, updating, and administering
databases
C) To replace spreadsheets entirely
D) To compile Java programs
Correct answer: B
,Rationale: A DBMS is software that manages data, providing data definition, data manipulation,
and administration capabilities. It serves as an intermediary between users and the database .
Question 3
Which term refers to raw, unprocessed facts?
A) Information
B) Data
C) Metadata
D) Database
Correct answer: B
Rationale: Data are raw facts. Information is data that has been processed into a meaningful
context. Metadata is "data about data" .
Question 4
What is a determining characteristic of unstructured data?
A) It is always stored in tables
B) It does not follow a data model
C) It is easily queried with SQL
D) It has a rigid structure
Correct answer: B
Rationale: Unstructured data lacks a predefined data model or organization. Examples include
text documents, images, and videos. It does not fit neatly into tables like structured data .
Question 5
In the relational model, a row is formally called a:
A) Tuple
B) Attribute
C) Domain
,D) Schema
Correct answer: A
Rationale: Relational theory uses "tuple" for a row (record) and "attribute" for a column (field) .
Question 6
What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Consistency, Integrity, Durability
C) Atomicity, Concurrency, Isolation, Dependency
D) Accuracy, Concurrency, Integrity, Dependency
Correct answer: A
Rationale: ACID properties ensure reliable processing of database transactions .
Question 7
Which requirement within large, complex databases ensures users have limited access to the
database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
Correct answer: C
Rationale: Authorization ensures that users have appropriate permissions and limited access to
database resources based on their roles .
Question 8
Facts that are collected and stored in a database system are called:
, A) Information
B) Data
C) Metadata
D) Knowledge
Correct answer: B
Rationale: Data refers to the raw facts and figures that are collected and stored within a
database system. Information is processed data that has meaning .
Question 9
What is the difference between analog and digital data?
A) Analog data refer to data from before the invention of computers
B) There is no real difference
C) Analog data cannot be stored, while digital data are stored using computers
D) Analog data are continuous, while digital data are discrete
Correct answer: D
Rationale: Analog data are continuous in nature, while digital data are discrete and represented
by distinct values .
Question 10
Which design type specifies database requirements without regard to a specific database
system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
Correct answer: B
Rationale: Conceptual design focuses on identifying and describing data requirements
independently of any specific database management system .
