WGU C175 QUESTIONS AND ANSWERS
ad hoc query
CORRECT ANSWER A "spur-of-the-moment" question.
analytical database
CORRECT ANSWER A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making.
availability
CORRECT 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
CORRECT ANSWER A database located at a single site.
cloud database
CORRECT ANSWER A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS.
data
CORRECT ANSWER Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
data anomaly
CORRECT ANSWER A data abnormality in which inconsistent changes have been made to a
database. For example, an employee moves, but the address change is not corrected in all files in the
database.
data dependence
CORRECT ANSWER A data condition in which data representation and manipulation are
dependent on the physical data storage characteristics.
data dictionary
, CORRECT ANSWER A DBMS component that stores metadata—data about data. Thus, the
data dictionary contains the data definition as well as their characteristics and relationships. A data
dictionary may also include data that are external to the DBMS. Also known as an information
resource dictionary. See also active data dictionary, metadata, and passive data dictionary.
data inconsistency
CORRECT ANSWER A condition in which different versions of the same data yield different
(inconsistent) results.
data independence
CORRECT ANSWER A condition in which data access is unaffected by changes in the physical
data storage characteristics.
data integrity
CORRECT ANSWER In a relational database, a condition in which the data in the database
complies with all entity and referential integrity constraints.
data management
CORRECT ANSWER A process that focuses on data collection, storage, and retrieval. Common
data management functions include addition, deletion, modification, and listing.
data processing (DP) specialist
CORRECT ANSWER The person responsible for developing and managing a computerized file
processing system.
data redundancy
CORRECT ANSWER Exists when the same data is stored unnecessarily at different places.
database
CORRECT ANSWER A shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data (raw facts) and metadata.
database design
CORRECT ANSWER The process that yields the description of the database structure and
determines the database components. The second phase of the Database Life Cycle.
ad hoc query
CORRECT ANSWER A "spur-of-the-moment" question.
analytical database
CORRECT ANSWER A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making.
availability
CORRECT 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
CORRECT ANSWER A database located at a single site.
cloud database
CORRECT ANSWER A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS.
data
CORRECT ANSWER Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
data anomaly
CORRECT ANSWER A data abnormality in which inconsistent changes have been made to a
database. For example, an employee moves, but the address change is not corrected in all files in the
database.
data dependence
CORRECT ANSWER A data condition in which data representation and manipulation are
dependent on the physical data storage characteristics.
data dictionary
, CORRECT ANSWER A DBMS component that stores metadata—data about data. Thus, the
data dictionary contains the data definition as well as their characteristics and relationships. A data
dictionary may also include data that are external to the DBMS. Also known as an information
resource dictionary. See also active data dictionary, metadata, and passive data dictionary.
data inconsistency
CORRECT ANSWER A condition in which different versions of the same data yield different
(inconsistent) results.
data independence
CORRECT ANSWER A condition in which data access is unaffected by changes in the physical
data storage characteristics.
data integrity
CORRECT ANSWER In a relational database, a condition in which the data in the database
complies with all entity and referential integrity constraints.
data management
CORRECT ANSWER A process that focuses on data collection, storage, and retrieval. Common
data management functions include addition, deletion, modification, and listing.
data processing (DP) specialist
CORRECT ANSWER The person responsible for developing and managing a computerized file
processing system.
data redundancy
CORRECT ANSWER Exists when the same data is stored unnecessarily at different places.
database
CORRECT ANSWER A shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data (raw facts) and metadata.
database design
CORRECT ANSWER The process that yields the description of the database structure and
determines the database components. The second phase of the Database Life Cycle.
