WGU D426 Data Management Foundations Exam
183 Questions with Verified Answers
Numeric, textual, visual, or audio information that describes real-world systems. It
is collected and processed to aid in a variety of tasks. - CORRECT ANSWER Data
Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks. - CORRECT ANSWER Analog Data
Most common today. Encoded as 0s and 1s on electronic magnetic data. -
CORRECT ANSWER Digital Data
A collection of data in structured format. In principle, can be stored on paper or
even clay tablets. - CORRECT ANSWER Database
Software that reads and writes in a database. - CORRECT ANSWER Database
System (DBMS)
A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database. - CORRECT
ANSWER Query
Specialized programming language designed specifically for database systems.
Reads and writes data efficiently. - CORRECT ANSWER Query Language
,Software that HELPS business users interact with database systems. - CORRECT
ANSWER Database Application
What role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability. - CORRECT
ANSWER Database Administrator
What role am I?
Determines the format of each data element AND the overall database
STRUCTURE. Must balance priorities like including storage, response time, and
support for rules that govern the data. - CORRECT ANSWER Database Designer
What role am I?
Develop programs that utilize a database and write applications that combine
query languages and general purpose programming language. - CORRECT
ANSWER Database Programmer
What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information. - CORRECT ANSWER Database User
, A group of queries that MUST be completed or rejected as a whole. - CORRECT
ANSWER Transaction
Describes the internal components AND the relationships between components. -
CORRECT ANSWER Architecture
Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization. - CORRECT
ANSWER Query Processor
Ensures efficient instructions are executed on the data from the Query Processor. -
CORRECT ANSWER Query Optimization
Translates the query processor instructions into low-level file-system commands
that modify OR retrieve data. Uses indexes to quickly locate data. - CORRECT
ANSWER Storage Manager
Ensures transactions are properly executed. Prevents conflicts between
concurrent transactions. Also restores the database to a consistent state in the
event of a failure. - CORRECT ANSWER Transaction Manager
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. - CORRECT
ANSWER Log
A directory of tables, columns, indexes, and other database objects. - CORRECT
ANSWER Catalog/Data Dictionary/Repository
183 Questions with Verified Answers
Numeric, textual, visual, or audio information that describes real-world systems. It
is collected and processed to aid in a variety of tasks. - CORRECT ANSWER Data
Most common before computers. Audio was recorded as vibrations impressed on
vinyl disks. - CORRECT ANSWER Analog Data
Most common today. Encoded as 0s and 1s on electronic magnetic data. -
CORRECT ANSWER Digital Data
A collection of data in structured format. In principle, can be stored on paper or
even clay tablets. - CORRECT ANSWER Database
Software that reads and writes in a database. - CORRECT ANSWER Database
System (DBMS)
A request to retrieve or change data in a database. Typically inserts new data,
retrieves data, updates, data, or deletes data from a database. - CORRECT
ANSWER Query
Specialized programming language designed specifically for database systems.
Reads and writes data efficiently. - CORRECT ANSWER Query Language
,Software that HELPS business users interact with database systems. - CORRECT
ANSWER Database Application
What role am I?
Responsible for securing the database system against unauthorized users. They
enforce procedures for user access and database system availability. - CORRECT
ANSWER Database Administrator
What role am I?
Determines the format of each data element AND the overall database
STRUCTURE. Must balance priorities like including storage, response time, and
support for rules that govern the data. - CORRECT ANSWER Database Designer
What role am I?
Develop programs that utilize a database and write applications that combine
query languages and general purpose programming language. - CORRECT
ANSWER Database Programmer
What role am I?
A consumer of data in a database. They request, update, or use stored data to
generate reports or information. - CORRECT ANSWER Database User
, A group of queries that MUST be completed or rejected as a whole. - CORRECT
ANSWER Transaction
Describes the internal components AND the relationships between components. -
CORRECT ANSWER Architecture
Interprets queries, creates a plan to modify the database or retrieve the data, and
returns query results to the application. Performs query optimization. - CORRECT
ANSWER Query Processor
Ensures efficient instructions are executed on the data from the Query Processor. -
CORRECT ANSWER Query Optimization
Translates the query processor instructions into low-level file-system commands
that modify OR retrieve data. Uses indexes to quickly locate data. - CORRECT
ANSWER Storage Manager
Ensures transactions are properly executed. Prevents conflicts between
concurrent transactions. Also restores the database to a consistent state in the
event of a failure. - CORRECT ANSWER Transaction Manager
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. - CORRECT
ANSWER Log
A directory of tables, columns, indexes, and other database objects. - CORRECT
ANSWER Catalog/Data Dictionary/Repository
