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