Data Management Foundations - WGU C175 exam with answers

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
|\ |\ |\ |\ |\ |\ |\ |\