wgu c182 objective assessment exam latest 2024 que
Written for
WGU
WGU
WGU
All documents for this subject (6264)
Seller
Follow
AMAZONN
Content preview
Data Management Foundations - WGU
C175 Exam With 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller AMAZONN. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.