Exam (elaborations)
WGU C175: data management foundations/120 Questions with complete solutions
WGU C175: data management foundations/120 Questions with complete solutions
[Show more]
Content preview
WGU C175: data managementfoundations/120 Questions with complete
solutions
data - -numeric, textual, visual or audio information that describes real-
world systems
-scope of data - -the amount of data produced and collected
-format of data - -data may be produced as numbers, text, image, audio, or
video
-access of data - -some data sources are private while others are made
publicly available
-database - -a collection of data in a structured format
-database system aka DBMS - -is software that reads and writes data in a
database. ensures data is secure, internally consistent, and available at all
times
-query language - -a specialized programming language designed
specifically for database systems. reads and writes data efficiently, and
differs significantly from general purpose languages such as python or java
-database application - -software that helps business users interact with
database systems
-database administrator - -the person responsible for securing the database
system against unauthorized users. enforces procedures for user and
database system availability
-database designer - -the person that determines the format of each data
element and the overall database structure. must balance several priorities
including storage, response time, and support for rules that govern the data.
-database programmer - -the person that develops computer programs that
utilize a database. they write applications that combine database query
languages and general purpose programming languages.
-database user - -a consumer of data in a database. request, update, or use
stored data to generate reports or information.
, -transaction - -a group of queries that must be either completed or rejected
as a whole.
-ensure transactions are processed completely or not at all
prevent conflicts between concurrent transactions
ensure transaction results are never lost - -when processing transactions,
database systems must:
-architecture of a database system (5) - -describes the internal components
and the relationships between components:
query processor
storage manager
transaction manager
log
catalog
-query processor - -interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application.
-storage manager - -translates the query processor instructions into low-
level file-system commands that modify or retrieve data.
-query optimization - -query processor performs ___________ to ensure that
most efficient instructions are executed on the data
-indexes - -storage manager uses ______ to quickly locate data
-transaction manager - -Ensures transactions are properly executed.
Prevents conflicts between concurrent transactions. Restores the database
to a consistent state in the event of a transaction or system failure.
-log - -a file containing a complete record of all inserts, updates, and
deletes processed by the database. the transaction manager writes these
before applying changes to the database.
-catalog/data dictionary - -A directory of tables, columns, indexes, and other
database objects.
-relational database - -stores data in tables, columns, and rows, similar to a
spreadsheet.
-SQL (Structured Query Language) - -the standard language of relational
database systems. includes statements that read and write data, create and
delete tables, and administer the database system
-NoSQL - -a newer non-relational system that is optimized for big data
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 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 Victorious23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.51. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now