1 | Page
Data Management Foundations -
WGU C175 Questions and Answers
Latest 2026
ad hoc query Ans: A "spur-of-the-moment" question
analytical database Ans: A database focused primarily on
storing historical data and business metrics used for
tactical or strategic decision making
availability Ans: In the context of data security, it refers
to the accessibility of data whenever required by
authorized users and for authorized purposes
centralized database Ans: A database located at a single
site
cloud database Ans: A database that is created and
maintained using cloud services, such as Microsoft Azure
or Amazon AWS
data Ans: Raw facts, or facts that have not yet been
processed to reveal their meaning to the end user
data anomaly Ans: An abnormality of the data in which
inconsistent changes have been made to a database (For
example, an employee moves, but the address changes is
not corrected in all files in the database)
© 2025 All rights reserved
, 2 | Page
data dependence Ans: A data condition in which data
representation and manipulation are dependent on the
physical data storage characteristics
data dictionary Ans: A DBMS component that stores
metadata. Contains the data definition, as well as their
characteristics and relationships
data inconsistency Ans: A condition in which different
versions of the same data yield different results
data independence Ans: A condition in which data access
is unaffected by changes in the physical data storage
characteristics
data integrity Ans: In a relational database, a condition in
which the data in the database complies with all entity
and referential integrity constraints
data management Ans: A process that focuses on data
collection, storage, and retrieval.
data processing (DP) specialist Ans: The person
responsible for developing and managing a computerized
file processing system
data redundancy Ans: Exists when the same data is
stored unnecessarily at different places
database Ans: A shared, integrated computer structure
that houses a collection of related data including end-
user data (raw facts) and metadata (data about the data)
© 2025 All rights reserved
, 3 | Page
database design Ans: The process that yields the
description of the database structure and determines the
database components. The second phase of the database
life cycle
database management system (DBMS) Ans: The collection
of programs that manages the database structure and
controls access to the data stored in the database
database system Ans: An organization of components
that defines and regulates the collection, storage,
management, and use of data in a database environment
desktop database Ans: A single-user database that runs
on a personal computer
discipline-specific database Ans: A database that
contains data focused on specific subject areas
enterprise database Ans: The overall company data
representation, which provides support for present and
expected future needs
field Ans: An alphabetic or numeric character or group of
characters that defines a characteristic of a person, place,
or thing. (for example, a person's SSN, address, phone
number, and bank balance all constitute fields)
file Ans: A named collection of related records
general-purpose database Ans: A database that contains
a wide variety of data used in multiple disciplines
© 2025 All rights reserved
, 4 | Page
hub Ans: A warehouse of data packets housed in a
central location on a local area network. It contains
multiple ports that copy the data in the data packets to
make it accessible to selected or all segments of the
network
information Ans: The result of processing raw data to
reveal its meaning. It consists of transformed data and
facilitates decision making
islands of information Ans: In the old file system
environment, pools of independent, often duplicated, and
inconsistent data created and managed by different
departments
knowledge Ans: The body of information and facts about
a specific subject. It implies familiarity, awareness, and
understanding of information as it applies to an
environment
logical data format Ans: The way a person views data
within the context of a problem domain
metadata Ans: Data about data
multiuser database Ans: A database that supports
multiple concurrent users
NoSQL Ans: A new generation of database management
systems that is not based on the traditional relational
database model. It stores structured and unstructured
data in efficient ways.
© 2025 All rights reserved
Data Management Foundations -
WGU C175 Questions and Answers
Latest 2026
ad hoc query Ans: A "spur-of-the-moment" question
analytical database Ans: A database focused primarily on
storing historical data and business metrics used for
tactical or strategic decision making
availability Ans: In the context of data security, it refers
to the accessibility of data whenever required by
authorized users and for authorized purposes
centralized database Ans: A database located at a single
site
cloud database Ans: A database that is created and
maintained using cloud services, such as Microsoft Azure
or Amazon AWS
data Ans: Raw facts, or facts that have not yet been
processed to reveal their meaning to the end user
data anomaly Ans: An abnormality of the data in which
inconsistent changes have been made to a database (For
example, an employee moves, but the address changes is
not corrected in all files in the database)
© 2025 All rights reserved
, 2 | Page
data dependence Ans: A data condition in which data
representation and manipulation are dependent on the
physical data storage characteristics
data dictionary Ans: A DBMS component that stores
metadata. Contains the data definition, as well as their
characteristics and relationships
data inconsistency Ans: A condition in which different
versions of the same data yield different results
data independence Ans: A condition in which data access
is unaffected by changes in the physical data storage
characteristics
data integrity Ans: In a relational database, a condition in
which the data in the database complies with all entity
and referential integrity constraints
data management Ans: A process that focuses on data
collection, storage, and retrieval.
data processing (DP) specialist Ans: The person
responsible for developing and managing a computerized
file processing system
data redundancy Ans: Exists when the same data is
stored unnecessarily at different places
database Ans: A shared, integrated computer structure
that houses a collection of related data including end-
user data (raw facts) and metadata (data about the data)
© 2025 All rights reserved
, 3 | Page
database design Ans: The process that yields the
description of the database structure and determines the
database components. The second phase of the database
life cycle
database management system (DBMS) Ans: The collection
of programs that manages the database structure and
controls access to the data stored in the database
database system Ans: An organization of components
that defines and regulates the collection, storage,
management, and use of data in a database environment
desktop database Ans: A single-user database that runs
on a personal computer
discipline-specific database Ans: A database that
contains data focused on specific subject areas
enterprise database Ans: The overall company data
representation, which provides support for present and
expected future needs
field Ans: An alphabetic or numeric character or group of
characters that defines a characteristic of a person, place,
or thing. (for example, a person's SSN, address, phone
number, and bank balance all constitute fields)
file Ans: A named collection of related records
general-purpose database Ans: A database that contains
a wide variety of data used in multiple disciplines
© 2025 All rights reserved
, 4 | Page
hub Ans: A warehouse of data packets housed in a
central location on a local area network. It contains
multiple ports that copy the data in the data packets to
make it accessible to selected or all segments of the
network
information Ans: The result of processing raw data to
reveal its meaning. It consists of transformed data and
facilitates decision making
islands of information Ans: In the old file system
environment, pools of independent, often duplicated, and
inconsistent data created and managed by different
departments
knowledge Ans: The body of information and facts about
a specific subject. It implies familiarity, awareness, and
understanding of information as it applies to an
environment
logical data format Ans: The way a person views data
within the context of a problem domain
metadata Ans: Data about data
multiuser database Ans: A database that supports
multiple concurrent users
NoSQL Ans: A new generation of database management
systems that is not based on the traditional relational
database model. It stores structured and unstructured
data in efficient ways.
© 2025 All rights reserved
