WGU d426 (2026-2027) advanced
scenario-based rigging questions with
correct answers and detailed
explanations
Data
Data is numeric, textual, visual or audio information
that describes real-world systems.
Analog
,Historically, data was mostly analog, encoded as
continuous variations on various physical media
digital
today, data is mostly digital, encoded as zeros and
ones on electronic and magnetic medai
Database
a collection of data in a structured format
database system
also known as DBMS, is software that reads and
writes data in a database. ensures data is secure,
consistent and available at all times
query language
a specialized programming language, designed
specifically for database systems.
database application
software that helps business users interact with
database systems.
database administrator
,responsible for securing the database system against
unauthorized users
database designer
determines the format of each data element and the
overall database structure.
database programmer
develops computer programs that utilize a database
database user
a consumer of data in a database.
transaction
A group of queries that must be either completed or
rejected as a whole
architecture
describes the internal components and the
relationship between components.
query processor
interprets queries, creates a plan to modify the
databse or retrieve data, and returns query results
to the application.
, query optimization
performed by the query processor to ensure the
most efficient instructions are executed on the data.
storage manager
translates the query processor instructions into low-
level file-system commands that modify or retrieve
data.
indexes
used by storage manager to quickly locate data
transaction manager
ensures transactions are properly executed
log
a file containing a complete record of all inserts,
updates and deletes processed by the database.
catalog / data dictionary
a directory of tables, columns, indexes and other
database objects
relational database
scenario-based rigging questions with
correct answers and detailed
explanations
Data
Data is numeric, textual, visual or audio information
that describes real-world systems.
Analog
,Historically, data was mostly analog, encoded as
continuous variations on various physical media
digital
today, data is mostly digital, encoded as zeros and
ones on electronic and magnetic medai
Database
a collection of data in a structured format
database system
also known as DBMS, is software that reads and
writes data in a database. ensures data is secure,
consistent and available at all times
query language
a specialized programming language, designed
specifically for database systems.
database application
software that helps business users interact with
database systems.
database administrator
,responsible for securing the database system against
unauthorized users
database designer
determines the format of each data element and the
overall database structure.
database programmer
develops computer programs that utilize a database
database user
a consumer of data in a database.
transaction
A group of queries that must be either completed or
rejected as a whole
architecture
describes the internal components and the
relationship between components.
query processor
interprets queries, creates a plan to modify the
databse or retrieve data, and returns query results
to the application.
, query optimization
performed by the query processor to ensure the
most efficient instructions are executed on the data.
storage manager
translates the query processor instructions into low-
level file-system commands that modify or retrieve
data.
indexes
used by storage manager to quickly locate data
transaction manager
ensures transactions are properly executed
log
a file containing a complete record of all inserts,
updates and deletes processed by the database.
catalog / data dictionary
a directory of tables, columns, indexes and other
database objects
relational database
