WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Architecture - ANSWER-Describes the internal components AND the relationships
between components.
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.
Query Optimization - ANSWER-Ensures efficient instructions are executed on the
data from the Query Processor.
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.
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.
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.
Catalog/Data Dictionary/Repository - ANSWER-A directory of tables, columns,
indexes, and other database objects.
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Relational Database - ANSWER-Stores data in tables, columns, and rows, SIMILAR
to a spreadsheet. It also supports SQL. Made up of relations.
NoSQL - ANSWER-A new generation of DBMS that is NOT based on the traditional
relational database model.
CRUD - ANSWER-Acronym for actions that can be performed by a query.
SQL Statement - ANSWER-A database command such as a query that inserts,
retrieves, updates, or deletes data. Composed of one or more clauses.
INSERT - ANSWER-Inserts rows into a table.
SELECT - ANSWER-Retrieves data from a table.
UPDATE - ANSWER-Modifies data in a table.
DELETE - ANSWER-Deletes rows from a table.
CREATE TABLE - ANSWER-Creates a new table by specifying the table and column
names.
Data Type - ANSWER-Indicates the TYPE of data that can be stored in a field of a
column.
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
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.
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.
Metadata - ANSWER-Data ABOUT the database, such as column names and the
number of rows in each table.
Database Design - Analysis - ANSWER-This phase specifies database requirements
without regard to a specific database system. May also be referred to as
conceptual design, entity-relationship modeling, and requirements definition.
Database Design - Logical Design - ANSWER-This phase implements database
requirements in a specific database system. Depicted in a table diagram.
Database Design - Physical Design - ANSWER-This phase adds indexes and
specifies HOW tables are organized on storage media. Specified with SQL
statements.
Key - ANSWER-A column used to identify individual rows of a table. Used to refer
to only one specific row or record.
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Architecture - ANSWER-Describes the internal components AND the relationships
between components.
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.
Query Optimization - ANSWER-Ensures efficient instructions are executed on the
data from the Query Processor.
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.
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.
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.
Catalog/Data Dictionary/Repository - ANSWER-A directory of tables, columns,
indexes, and other database objects.
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Relational Database - ANSWER-Stores data in tables, columns, and rows, SIMILAR
to a spreadsheet. It also supports SQL. Made up of relations.
NoSQL - ANSWER-A new generation of DBMS that is NOT based on the traditional
relational database model.
CRUD - ANSWER-Acronym for actions that can be performed by a query.
SQL Statement - ANSWER-A database command such as a query that inserts,
retrieves, updates, or deletes data. Composed of one or more clauses.
INSERT - ANSWER-Inserts rows into a table.
SELECT - ANSWER-Retrieves data from a table.
UPDATE - ANSWER-Modifies data in a table.
DELETE - ANSWER-Deletes rows from a table.
CREATE TABLE - ANSWER-Creates a new table by specifying the table and column
names.
Data Type - ANSWER-Indicates the TYPE of data that can be stored in a field of a
column.
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
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.
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.
Metadata - ANSWER-Data ABOUT the database, such as column names and the
number of rows in each table.
Database Design - Analysis - ANSWER-This phase specifies database requirements
without regard to a specific database system. May also be referred to as
conceptual design, entity-relationship modeling, and requirements definition.
Database Design - Logical Design - ANSWER-This phase implements database
requirements in a specific database system. Depicted in a table diagram.
Database Design - Physical Design - ANSWER-This phase adds indexes and
specifies HOW tables are organized on storage media. Specified with SQL
statements.
Key - ANSWER-A column used to identify individual rows of a table. Used to refer
to only one specific row or record.
