WGU C175: data management foundations
UPDATED ACTUAL Exam Questions and
CORRECT Answers
data - CORRECT ANSWER - numeric, textual, visual or audio information that describes
real-world systems
scope of data - CORRECT ANSWER - the amount of data produced and collected
format of data - CORRECT ANSWER - data may be produced as numbers, text, image,
audio, or video
access of data - CORRECT ANSWER - some data sources are private while others are
made publicly available
database - CORRECT ANSWER - a collection of data in a structured format
database system aka DBMS - CORRECT ANSWER - is software that reads and writes
data in a database. ensures data is secure, internally consistent, and available at all times
query language - CORRECT ANSWER - a specialized programming language designed
specifically for database systems. reads and writes data efficiently, and differs significantly from
general purpose languages such as python or java
database application - CORRECT ANSWER - software that helps business users interact
with database systems
database administrator - CORRECT ANSWER - the person responsible for securing the
database system against unauthorized users. enforces procedures for user and database system
availability
, database designer - CORRECT ANSWER - the person that determines the format of each
data element and the overall database structure. must balance several priorities including storage,
response time, and support for rules that govern the data.
database programmer - CORRECT ANSWER - the person that develops computer
programs that utilize a database. they write applications that combine database query languages
and general purpose programming languages.
database user - CORRECT ANSWER - a consumer of data in a database. request, update,
or use stored data to generate reports or information.
transaction - CORRECT ANSWER - a group of queries that must be either completed or
rejected as a whole.
ensure transactions are processed completely or not at all
prevent conflicts between concurrent transactions
ensure transaction results are never lost - CORRECT ANSWER - when processing
transactions, database systems must:
architecture of a database system (5) - CORRECT ANSWER - describes the internal
components and the relationships between components:
query processor
storage manager
transaction manager
log
catalog
query processor - CORRECT ANSWER - interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application.
UPDATED ACTUAL Exam Questions and
CORRECT Answers
data - CORRECT ANSWER - numeric, textual, visual or audio information that describes
real-world systems
scope of data - CORRECT ANSWER - the amount of data produced and collected
format of data - CORRECT ANSWER - data may be produced as numbers, text, image,
audio, or video
access of data - CORRECT ANSWER - some data sources are private while others are
made publicly available
database - CORRECT ANSWER - a collection of data in a structured format
database system aka DBMS - CORRECT ANSWER - is software that reads and writes
data in a database. ensures data is secure, internally consistent, and available at all times
query language - CORRECT ANSWER - a specialized programming language designed
specifically for database systems. reads and writes data efficiently, and differs significantly from
general purpose languages such as python or java
database application - CORRECT ANSWER - software that helps business users interact
with database systems
database administrator - CORRECT ANSWER - the person responsible for securing the
database system against unauthorized users. enforces procedures for user and database system
availability
, database designer - CORRECT ANSWER - the person that determines the format of each
data element and the overall database structure. must balance several priorities including storage,
response time, and support for rules that govern the data.
database programmer - CORRECT ANSWER - the person that develops computer
programs that utilize a database. they write applications that combine database query languages
and general purpose programming languages.
database user - CORRECT ANSWER - a consumer of data in a database. request, update,
or use stored data to generate reports or information.
transaction - CORRECT ANSWER - a group of queries that must be either completed or
rejected as a whole.
ensure transactions are processed completely or not at all
prevent conflicts between concurrent transactions
ensure transaction results are never lost - CORRECT ANSWER - when processing
transactions, database systems must:
architecture of a database system (5) - CORRECT ANSWER - describes the internal
components and the relationships between components:
query processor
storage manager
transaction manager
log
catalog
query processor - CORRECT ANSWER - interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application.
