Data Management
Foundations - WGU C175
Exam Questions and
Complete Solutions
Graded A+
Denning [Date] [Course title]
,ad hoc query - Answer: A "spur-of-the-moment" question
analytical database - Answer: A database focused primarily on storing historical data and business
metrics used for tactical or strategic decision making
availability - 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 - Answer: A database located at a single site
cloud database - Answer: A database that is created and maintained using cloud services, such as
Microsoft Azure or Amazon AWS
data - Answer: Raw facts, or facts that have not yet been processed to reveal their meaning to the end
user
data anomaly - 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 - Answer: A data condition in which data representation and manipulation are
dependent on the physical data storage characteristics
data dictionary - Answer: A DBMS component that stores metadata. Contains the data definition, as
well as their characteristics and relationships
data inconsistency - Answer: A condition in which different versions of the same data yield different
results
data independence - Answer: A condition in which data access is unaffected by changes in the physical
data storage characteristics
, data integrity - Answer: In a relational database, a condition in which the data in the database complies
with all entity and referential integrity constraints
data management - Answer: A process that focuses on data collection, storage, and retrieval.
data processing (DP) specialist - Answer: The person responsible for developing and managing a
computerized file processing system
data redundancy - Answer: Exists when the same data is stored unnecessarily at different places
database - 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 - 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) - Answer: The collection of programs that manages the database
structure and controls access to the data stored in the database
database system - Answer: An organization of components that defines and regulates the collection,
storage, management, and use of data in a database environment
desktop database - Answer: A single-user database that runs on a personal computer
discipline-specific database - Answer: A database that contains data focused on specific subject areas
enterprise database - Answer: The overall company data representation, which provides support for
present and expected future needs
field - 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)
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 YourExamplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.