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