WGU C170 DATA MANAGEMENT
APPLICATIONS MASTER REVIEW SET 2026
◉ analytical database. Answer: A database focused primarily on
storing historical data and business metrics used for tactical or
strategic decision making
◉ availability. Answer: In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes
◉ centralized database. Answer: A database located at a single site
◉ cloud database. Answer: A database that is created and
maintained using cloud services, such as Microsoft Azure or Amazon
AWS
◉ data. Answer: Raw facts, or facts that have not yet been processed
to reveal their meaning to the end user
◉ data anomaly. Answer: 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)
,◉ data dependence. Answer: A data condition in which data
representation and manipulation are dependent on the physical data
storage characteristics
◉ data dictionary. Answer: A DBMS component that stores
metadata. Contains the data definition, as well as their
characteristics and relationships
◉ data inconsistency. Answer: A condition in which different
versions of the same data yield different results
◉ data independence. Answer: A condition in which data access is
unaffected by changes in the physical data storage characteristics
◉ data integrity. Answer: In a relational database, a condition in
which the data in the database complies with all entity and
referential integrity constraints
◉ data management. Answer: A process that focuses on data
collection, storage, and retrieval.
◉ data processing (DP) specialist. Answer: The person responsible
for developing and managing a computerized file processing system
,◉ data redundancy. Answer: Exists when the same data is stored
unnecessarily at different places
◉ database. Answer: A shared, integrated computer structure that
houses a collection of related data including end-user data (raw
facts) and metadata (data about the data)
◉ database design. Answer: 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). Answer: The collection of
programs that manages the database structure and controls access
to the data stored in the database
◉ database system. Answer: An organization of components that
defines and regulates the collection, storage, management, and use
of data in a database environment
◉ desktop database. Answer: A single-user database that runs on a
personal computer
◉ discipline-specific database. Answer: A database that contains
data focused on specific subject areas
, ◉ enterprise database. Answer: The overall company data
representation, which provides support for present and expected
future needs
◉ field. Answer: 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. Answer: A named collection of related records
◉ general-purpose database. Answer: A database that contains a
wide variety of data used in multiple disciplines
◉ hub. Answer: 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. Answer: The result of processing raw data to reveal
its meaning. It consists of transformed data and facilitates decision
making
APPLICATIONS MASTER REVIEW SET 2026
◉ analytical database. Answer: A database focused primarily on
storing historical data and business metrics used for tactical or
strategic decision making
◉ availability. Answer: In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes
◉ centralized database. Answer: A database located at a single site
◉ cloud database. Answer: A database that is created and
maintained using cloud services, such as Microsoft Azure or Amazon
AWS
◉ data. Answer: Raw facts, or facts that have not yet been processed
to reveal their meaning to the end user
◉ data anomaly. Answer: 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)
,◉ data dependence. Answer: A data condition in which data
representation and manipulation are dependent on the physical data
storage characteristics
◉ data dictionary. Answer: A DBMS component that stores
metadata. Contains the data definition, as well as their
characteristics and relationships
◉ data inconsistency. Answer: A condition in which different
versions of the same data yield different results
◉ data independence. Answer: A condition in which data access is
unaffected by changes in the physical data storage characteristics
◉ data integrity. Answer: In a relational database, a condition in
which the data in the database complies with all entity and
referential integrity constraints
◉ data management. Answer: A process that focuses on data
collection, storage, and retrieval.
◉ data processing (DP) specialist. Answer: The person responsible
for developing and managing a computerized file processing system
,◉ data redundancy. Answer: Exists when the same data is stored
unnecessarily at different places
◉ database. Answer: A shared, integrated computer structure that
houses a collection of related data including end-user data (raw
facts) and metadata (data about the data)
◉ database design. Answer: 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). Answer: The collection of
programs that manages the database structure and controls access
to the data stored in the database
◉ database system. Answer: An organization of components that
defines and regulates the collection, storage, management, and use
of data in a database environment
◉ desktop database. Answer: A single-user database that runs on a
personal computer
◉ discipline-specific database. Answer: A database that contains
data focused on specific subject areas
, ◉ enterprise database. Answer: The overall company data
representation, which provides support for present and expected
future needs
◉ field. Answer: 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. Answer: A named collection of related records
◉ general-purpose database. Answer: A database that contains a
wide variety of data used in multiple disciplines
◉ hub. Answer: 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. Answer: The result of processing raw data to reveal
its meaning. It consists of transformed data and facilitates decision
making
