WGU D426 Data Management Foundations exam with complete solution .
3 views 0 purchase
Course
WGU PA
Institution
WGU PA
Data
numeric, textual, visual, or audio information that describes real-world systems.
analog
Historically, data was mostly ______________, encoded as continuous variations on various physical media.
Previous
Play
Next
Rewind 10 seconds
Move forward 10 seconds
Unmute
0:00
/
0:...
WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
1. Data numeric, textual, visual, or audio information
that de- scribes real-world systems.
2. analog Historically, data was mostly , encod-
ed as continuous variations on various physical media.
3. digital Today, data is mostly , encoded as
zeros and ones on electronic and magnetic
media.
4. database a collection of data in a structured format. In
principle,
can be stored on paper or even clay tablets. In
practice, however, modern ones are invariably
stored on com- puters.
5. database system software that reads and writes data in a
/ database man- database. en- sure data is secure, internally
agement system / consistent, and available at all times. These
DBMS functions are challenging for large databases
with many users, so data base systems are
complex.
6. database applica-
tion software that helps business users interact
with data- base systems.
7. database
adminis- trator - responsible for securing the database system
against unauthorized users.
- enforces procedures for user access and
database system availability.
8. database designer determines the format of each data element and
the
overall database structure. Must balance
several prior- ities, including storage, response
time, and support for rules that govern the
data. Since these priorities often conflict,
database design is technically challenging.
9. database program- mer
1/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
develops computer programs that utilize a database.
10. database user - a consumer of data in a database.
request, update, or use stored data to
generate reports or information.
2/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
- usually access the database via applications
but can also submit queries directly to the
database system.
11. transaction a group of queries that must be either completed
or
rejected as a whole. Execution of some, but not
all, queries results in inconsistent or incorrect
data.
12. query processor - interprets queries, creates a plan to modify the
data-
base or retrieve data, and returns query
results to the application.
- manages connections from multiple users
and com- piles queries into low-level
instructions for the storage engine.
13. query optimization The query processor performs to en-
sure the most efficient instructions are
executed on the data.
14. indexes used by the storage manager to quickly locate
data.
15. transaction manag- ensures transactions are properly executed.
er
16. log a file containing a complete record of all
inserts, up- dates, and deletes processed by
the database.
17. relational database stores data in tables, columns, and rows, similar
to a
spreadsheet.
18. SQL includes statements that read and write data,
create and delete tables, and administer the
database system.
19. big data The growth of the internet in the 1990s
3/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
generated mas-
sive volumes of online data, often with poorly
structured or missing information.
20. NoSQL The newer non-relational systems, for 'not only
SQL',
and are optimized for big data.
21. Open source
4/
84
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 tuition. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
