Data Management Foundations - WGU C175
UPDATED ACTUAL Exam Questions and
CORRECT 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 - 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 - 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.
Contains the data definition, as well as their characteristics and relationships
,data inconsistency - CORRECT ANSWER - A condition in which different versions of the
same data yield different 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.
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 including end-user data (raw facts) and metadata (data about the data)
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
database management system (DBMS) - CORRECT ANSWER - The collection of
programs that manages the database structure and controls access to the data stored in the
database
database system - CORRECT ANSWER - An organization of components that defines and
regulates the collection, storage, management, and use of data in a database environment
, desktop database - CORRECT ANSWER - A single-user database that runs on a personal
computer
discipline-specific database - CORRECT ANSWER - A database that contains data
focused on specific subject areas
enterprise database - CORRECT ANSWER - The overall company data representation,
which provides support for present and expected future needs
field - CORRECT 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 - CORRECT ANSWER - A named collection of related records
general-purpose database - CORRECT ANSWER - A database that contains a wide
variety of data used in multiple disciplines
hub - CORRECT 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 - CORRECT ANSWER - The result of processing raw data to reveal its
meaning. It consists of transformed data and facilitates decision making
islands of information - CORRECT ANSWER - In the old file system environment, pools
of independent, often duplicated, and inconsistent data created and managed by different
departments
UPDATED ACTUAL Exam Questions and
CORRECT 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 - 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 - 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.
Contains the data definition, as well as their characteristics and relationships
,data inconsistency - CORRECT ANSWER - A condition in which different versions of the
same data yield different 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.
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 including end-user data (raw facts) and metadata (data about the data)
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
database management system (DBMS) - CORRECT ANSWER - The collection of
programs that manages the database structure and controls access to the data stored in the
database
database system - CORRECT ANSWER - An organization of components that defines and
regulates the collection, storage, management, and use of data in a database environment
, desktop database - CORRECT ANSWER - A single-user database that runs on a personal
computer
discipline-specific database - CORRECT ANSWER - A database that contains data
focused on specific subject areas
enterprise database - CORRECT ANSWER - The overall company data representation,
which provides support for present and expected future needs
field - CORRECT 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 - CORRECT ANSWER - A named collection of related records
general-purpose database - CORRECT ANSWER - A database that contains a wide
variety of data used in multiple disciplines
hub - CORRECT 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 - CORRECT ANSWER - The result of processing raw data to reveal its
meaning. It consists of transformed data and facilitates decision making
islands of information - CORRECT ANSWER - In the old file system environment, pools
of independent, often duplicated, and inconsistent data created and managed by different
departments
