WGU D427 DATA MANAGEMENT
APPLICATIONS 2026 COMPLETE ANSWERS
QUERY DEVELOPMENT PRACTICE RESOURCE
◉ Transaction Manager.
Answer: Ensures transactions are properly executed. The
transaction manager prevents conflicts between concurrent
transactions. The transaction manager also restores the database to
a consistent state in the event of a transaction or system failure.
◉ Metadata.
Answer: Data about the database, such as column names and the
number of rows in each table.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, similar to a
spreadsheet.
◉ Relational Database.
Answer: All _________ ________ systems support the SQL query
language.
◉ Relational Database.
,Answer: Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records.
◉ MongoDB (NoSQL).
Answer: The newer non-relational systems are called NoSQL, for
'not only SQL', and are optimized for big data.
◉ SQL Statements.
Answer: INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
◉ CREATE TABLE (Statement).
Answer: A statement that creates a new table by specifying the table
and column names. Each column is assigned a data type that
indicates the format of column values. Data types can be numeric,
textual, or complex.
◉ Data Type.
Answer: INT stores integer values.
DECIMAL stores fractional numeric values.
, VARCHAR stores textual values.
DATE stores year, month, and day.
◉ Database Design.
Answer: Analysis
Logical design
Physical design
◉ Analysis Phase, Conceptual Design, Entity-Relationship Modeling
(Database Design).
Answer: This phase specifies database requirements without regard
to a specific database system. Requirements are represented as
entities, relationships, and attributes. An entity is a person, place,
activity, or thing. A relationship is a link between entities, and an
attribute is a descriptive property of an entity.
◉ Logical Design (Database Design).
Answer: This phase implements database requirements in a specific
database system. For relational database systems, _________ design
converts entities, relationships, and attributes into tables, keys, and
columns.
◉ Physical Design.
APPLICATIONS 2026 COMPLETE ANSWERS
QUERY DEVELOPMENT PRACTICE RESOURCE
◉ Transaction Manager.
Answer: Ensures transactions are properly executed. The
transaction manager prevents conflicts between concurrent
transactions. The transaction manager also restores the database to
a consistent state in the event of a transaction or system failure.
◉ Metadata.
Answer: Data about the database, such as column names and the
number of rows in each table.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, similar to a
spreadsheet.
◉ Relational Database.
Answer: All _________ ________ systems support the SQL query
language.
◉ Relational Database.
,Answer: Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records.
◉ MongoDB (NoSQL).
Answer: The newer non-relational systems are called NoSQL, for
'not only SQL', and are optimized for big data.
◉ SQL Statements.
Answer: INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
◉ CREATE TABLE (Statement).
Answer: A statement that creates a new table by specifying the table
and column names. Each column is assigned a data type that
indicates the format of column values. Data types can be numeric,
textual, or complex.
◉ Data Type.
Answer: INT stores integer values.
DECIMAL stores fractional numeric values.
, VARCHAR stores textual values.
DATE stores year, month, and day.
◉ Database Design.
Answer: Analysis
Logical design
Physical design
◉ Analysis Phase, Conceptual Design, Entity-Relationship Modeling
(Database Design).
Answer: This phase specifies database requirements without regard
to a specific database system. Requirements are represented as
entities, relationships, and attributes. An entity is a person, place,
activity, or thing. A relationship is a link between entities, and an
attribute is a descriptive property of an entity.
◉ Logical Design (Database Design).
Answer: This phase implements database requirements in a specific
database system. For relational database systems, _________ design
converts entities, relationships, and attributes into tables, keys, and
columns.
◉ Physical Design.
