DATA MANAGEMENT - FOUNDATIONS
- D426 WGU EXAM QUESTIONS AND
CORRECT ANSWERS FOR 2025
, Data - ANSWERnumeric , textual , visual or audio information that describes real-world
systems.
varies in ways such as scope, format, access.
analog data - ANSWERHistorically most common before computers, encoded as
continuous variations on various physical media.
digital data - ANSWERmost common today, recorded as 0's and 1's on electronic and
magnetic media.
database designer - ANSWERdetermines the format of each data element and the
overall database structure
database user - ANSWERa consumer of data in a database. can either use an
application or submit queries directly to the database. they use, request and update
data. to generate reports
transaction - ANSWERa group of queries that must be completed or rejected as whole.
will result in incomplete or incorrect data if not terminated as a whole.
Query processor - ANSWERinterprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Query optimization - ANSWERto ensure the most efficient instructions are executed on
the data from the processor.
Storage Manager - ANSWERtranslates the query processor instructions into low-level
file-system commands that modify or retrieve data.
indexes - ANSWERused by the storage manager to quickly locate data
catalog - ANSWERalso called a data dictionary , a directory of tables, columns and
indexes as well as other database objects.
relational database - ANSWERa database that stores data in tables that consist of rows
and columns, similar to a spreadsheet
SQL - ANSWERStructured Query Language
- D426 WGU EXAM QUESTIONS AND
CORRECT ANSWERS FOR 2025
, Data - ANSWERnumeric , textual , visual or audio information that describes real-world
systems.
varies in ways such as scope, format, access.
analog data - ANSWERHistorically most common before computers, encoded as
continuous variations on various physical media.
digital data - ANSWERmost common today, recorded as 0's and 1's on electronic and
magnetic media.
database designer - ANSWERdetermines the format of each data element and the
overall database structure
database user - ANSWERa consumer of data in a database. can either use an
application or submit queries directly to the database. they use, request and update
data. to generate reports
transaction - ANSWERa group of queries that must be completed or rejected as whole.
will result in incomplete or incorrect data if not terminated as a whole.
Query processor - ANSWERinterprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
Query optimization - ANSWERto ensure the most efficient instructions are executed on
the data from the processor.
Storage Manager - ANSWERtranslates the query processor instructions into low-level
file-system commands that modify or retrieve data.
indexes - ANSWERused by the storage manager to quickly locate data
catalog - ANSWERalso called a data dictionary , a directory of tables, columns and
indexes as well as other database objects.
relational database - ANSWERa database that stores data in tables that consist of rows
and columns, similar to a spreadsheet
SQL - ANSWERStructured Query Language
