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 lowlevel 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)
, 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.
WGU D426 Data Management Foundations Final Exam (Latest
2023-2023 Update)
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Data Type - ANSWER-Indicates the TYPE of data that can be
stored in a field of a column.
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
WGU D426 Data Management Foundations Final Exam (Latest
2023-2023 Update)
(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 lowlevel 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)
, 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.
WGU D426 Data Management Foundations Final Exam (Latest
2023-2023 Update)
, WGU D426 Data Management Foundations Final Exam
(Latest 2023/ 2023 Update) | Questions and Verified
Answers|100% Correct| Grade A
Data Type - ANSWER-Indicates the TYPE of data that can be
stored in a field of a column.
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
WGU D426 Data Management Foundations Final Exam (Latest
2023-2023 Update)
