WGU D426 Data Management Foundations Final Exam (Latest 2023/ 2023 Update) | Questions and Verified Answers|100% Correct| Grade A

WGU D426 Data Management Foundations

Final Exam (Latest 2023/ 2023 Update) |

Questions and Verified Answers|100%

Correct| Grade A

Q: Architecture

Answer:

Describes the internal components AND the relationships between components.

Q: Query Processor

Answer:

Interprets queries, creates a plan to modify the database or retrieve the data, and returns query

results to the application. Performs query optimization.

Q: Query Optimization

Answer:

Ensures efficient instructions are executed on the data from the Query Processor.

Q: Storage Manager

Answer:

Translates the query processor instructions into low-level file-system commands that modify OR

retrieve data. Uses indexes to quickly locate data.

Q: Transaction Manager

Answer:

Ensures transactions are properly executed. Prevents conflicts between concurrent transactions.

Also restores the database to a consistent state in the event of a failure.

Q: Log

Answer:

A file containing a complete record of ALL inserts, updates, and deletes processed by the

database. The records can be used to restore a database.

Q: Catalog/Data Dictionary/Repository

Answer:

A directory of tables, columns, indexes, and other database objects.

Q: Relational Database

Answer:

Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also supports SQL. Made

up of relations.

Q: NoSQL

Answer:

A new generation of DBMS that is NOT based on the traditional relational database model.

Q: CRUD

Answer:

Acronym for actions that can be performed by a query.

Q: SQL Statement

Answer:

A database command such as a query that inserts, retrieves, updates, or deletes data. Composed

of one or more clauses.

Q: INSERT

Answer:

Inserts rows into a table.

Q: SELECT

Answer:

Retrieves data from a table.

Q: UPDATE

Answer:

Modifies data in a table.

Q: DELETE

Answer:

Deletes rows from a table.

Q: CREATE TABLE

Answer:

Creates a new table by specifying the table and column names.

Q: Data Type

Answer:

Indicates the TYPE of data that can be stored in a field of a column.

Q: Data Independence

Answer:

Allows database administrators to improve query performance by changing the organization of

data on storage devices, without affecting query results or changes to programs.

Q: Database Design

Answer:

A specification of database objects such as tables, columns data types, and indexes. Also refers

to the process used to develop the specifications.

Q: Metadata

Answer:

Data ABOUT the database, such as column names and the number of rows in each table.