WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA CERTIFICATION EVALUATION
EXAMS SET LATEST VERSION
⩥ 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
⩥ islands of information. Answer: In the old file system environment,
pools of independent, often duplicated, and inconsistent data created and
managed by different departments
⩥ knowledge. Answer: The body of information and facts about a
specific subject. It implies familiarity, awareness, and understanding of
information as it applies to an environment
FOUNDATIONS OA CERTIFICATION EVALUATION
EXAMS SET LATEST VERSION
⩥ 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
⩥ islands of information. Answer: In the old file system environment,
pools of independent, often duplicated, and inconsistent data created and
managed by different departments
⩥ knowledge. Answer: The body of information and facts about a
specific subject. It implies familiarity, awareness, and understanding of
information as it applies to an environment
