WGU D426 - DATA MANAGEMENT FOUNDATIONS UPDATED ACTUAL QUESTIONS AND CORRECT ANSWERS

WGU D426 - DATA MANAGEMENT FOUNDATIONS
UPDATED ACTUAL QUESTIONS AND CORRECT
ANSWERS

Question:
1. numeric, textual, visual, or audio information that describes real-world systems.
Answer:
Data

Question:
2. Historically, data was mostly ______________, encoded as continuous variations on various physical
media.
Answer:
analog

Question:
3. Today, data is mostly ______________, encoded as zeros and ones on electronic and magnetic media.
Answer:
digital

Question:
4. 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 computers.
Answer:
database

Question:
5. software that reads and writes data in a database. ensure data is secure, internally consistent, and
available at all times. These functions are challenging for large databases with many users, so data base
systems are complex.
Answer:
database system / database management system / DBMS

Question:
6. software that helps business users interact with database systems.
Answer:
database application

Question:
7. - responsible for securing the database system against unauthorized users.
- enforces procedures for user access and database system availability.
Answer:
database administrator

,Question:
8. 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. Since these priorities
often conflict, database design is technically challenging.
Answer:
database designer

Question:
9. develops computer programs that utilize a database.
Answer:
database programmer

Question:
10. - a consumer of data in a database. request, update, or use stored data to generate reports or
information.
- usually access the database via applications but can also submit queries directly to the database system.
Answer:
database user

Question:
11. 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.
Answer:
transaction

Question:
12. - interprets queries, creates a plan to modify the database or retrieve data, and returns query results to
the application.
- manages connections from multiple users and compiles queries into low-level instructions for the storage
engine.
Answer:
query processor

Question:
13. The query processor performs ______________ to ensure the most efficient instructions are executed
on the data.
Answer:
query optimization

Question:
14. used by the storage manager to quickly locate data.
Answer:
indexes

Question:
15. ensures transactions are properly executed.

,Answer:
transaction manager

Question:
16. a file containing a complete record of all inserts, updates, and deletes processed by the database.
Answer:
log

Question:
17. stores data in tables, columns, and rows, similar to a spreadsheet.
Answer:
relational database

Question:
18. includes statements that read and write data, create and delete tables, and administer the database
system.
Answer:
SQL

Question:
19. The growth of the internet in the 1990s generated massive volumes of online data, often with poorly
structured or missing information.
Answer:
big data

Question:
20. The newer non-relational systems, for 'not only SQL', and are optimized for big data.
Answer:
NoSQL

Question:
21. software that anyone can inspect, copy, and modify with no licensing fee.
Answer:
Open source

Question:
22. a command for a database that typically inserts new data, retrieves data, updates data, or deletes data
from a database.
Answer:
query

Question:
23. a computer programming language for writing database queries.
Answer:
query language

, Question:
24. The four common queries are an acronym for Create, Read, Update, and Delete data.
Answer:
CRUD

Question:
25. retrieves data from a table.
Answer:
SELECT

Question:
26. modifies data in a table.
Answer:
UPDATE

Question:
27. creates a new table by specifying the table and column names.
Answer:
CREATE TABLE

Question:
28. Each column is assigned a ______________ that indicates the format of column values and can be
numeric, textual, or complex.
Answer:
data type

Question:
29. a specification of database objects such as tables, columns, data types, and indexes. Also refers to the
process used to develop the specification.
Answer:
database design

Question:
30. specifies database requirements without regard to a specific database system.
Answer:
analysis

Question:
31. depicts entities, relationships, and attributes.
Answer:
ER diagrams

Question:
32. implements database requirements in a specific database system. specifies tables, columns, and keys.
Answer:
logical design