WGU D426 DATA MANAGEMENT
FOUNDATIONS EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS GRADED A+
transaction
a group of queries that must be either completed or rejected as a whole.
Execution of some, but not all, queries results in inconsistent or incorrect data.
query processor
- interprets queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
- manages connections from multiple users and compiles queries into low-level
instructions for the storage engine.
query optimization
The query processor performs ______________ to ensure the most efficient
instructions are executed on the data.
indexes
Page | 1
,used by the 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.
relational database
stores data in tables, columns, and rows, similar to a spreadsheet.
SQL
includes statements that read and write data, create and delete tables, and
administer the database system.
big data
Page | 2
,The growth of the internet in the 1990s generated massive volumes of online
data, often with poorly structured or missing information.
NoSQL
The newer non-relational systems, for 'not only SQL', and are optimized for big
data.
Open source
software that anyone can inspect, copy, and modify with no licensing fee.
Data
numeric, textual, visual, or audio information that describes real-world systems.
analog
Historically, data was mostly ______________, encoded as continuous
variations on various physical media.
Page | 3
, digital
Today, data is mostly ______________, encoded as zeros and ones on
electronic and magnetic media.
database
a collection of data in a structured format. In principle, can be stored on paper
or even clay tablets. In practice, however, modern ones are invariably stored on
computers.
database system / database management system / DBMS
software that reads and writes data in a database. ensure data is secure,
internally consistent, and available at all times. These functions are challenging
for large databases with many users, so data base systems are complex.
database application
software that helps business users interact with database systems.
database administrator
- responsible for securing the database system against unauthorized users.
Page | 4
FOUNDATIONS EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS GRADED A+
transaction
a group of queries that must be either completed or rejected as a whole.
Execution of some, but not all, queries results in inconsistent or incorrect data.
query processor
- interprets queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
- manages connections from multiple users and compiles queries into low-level
instructions for the storage engine.
query optimization
The query processor performs ______________ to ensure the most efficient
instructions are executed on the data.
indexes
Page | 1
,used by the 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.
relational database
stores data in tables, columns, and rows, similar to a spreadsheet.
SQL
includes statements that read and write data, create and delete tables, and
administer the database system.
big data
Page | 2
,The growth of the internet in the 1990s generated massive volumes of online
data, often with poorly structured or missing information.
NoSQL
The newer non-relational systems, for 'not only SQL', and are optimized for big
data.
Open source
software that anyone can inspect, copy, and modify with no licensing fee.
Data
numeric, textual, visual, or audio information that describes real-world systems.
analog
Historically, data was mostly ______________, encoded as continuous
variations on various physical media.
Page | 3
, digital
Today, data is mostly ______________, encoded as zeros and ones on
electronic and magnetic media.
database
a collection of data in a structured format. In principle, can be stored on paper
or even clay tablets. In practice, however, modern ones are invariably stored on
computers.
database system / database management system / DBMS
software that reads and writes data in a database. ensure data is secure,
internally consistent, and available at all times. These functions are challenging
for large databases with many users, so data base systems are complex.
database application
software that helps business users interact with database systems.
database administrator
- responsible for securing the database system against unauthorized users.
Page | 4
