WGU D192 DATA SYSTEMS
ADMINISTRATION 200 QUESTIONS
ACTUAL PAPER 2026 COMPLETE
QUESTIONS AND ANSWERS GRADED A+
⩥ Foreign Key. Answer: Field that is a primary key to another table.
⩥ Schema. Answer: The complete description of the database.
⩥ Variable. Answer: a data type or simply type is a classification of data
which tells the compiler or interpreter how the programmer intends to
use the data; can become incompatible with data warehouse design.
⩥ Flat File Database. Answer: Stores data in plain text, holding one
record; cannot contain multiple tables like a relational database.
⩥ Online Analytical processing (OLAP). Answer: analyze transaction
data used for making decisions; multidimensional (cubical) data;
requires a lengthy, complex loading and updating phase.
⩥ Online transaction processing (OLTP). Answer: database design used
for browsing and manipulating business transaction activity.
,Processing of information into the database.
Don't perform analyses on these databases because it could affect
performance.
⩥ relational database. Answer: type of database in which multiple
information files are combined into one database in one location, where
data are stored in two-dimensional tables known as relations and contain
multiple entities and attributes
⩥ Object-Oriented Database. Answer: A database that is designed to
store mixed media, as opposed to tables in relational databases.
⩥ Conceptual Data Model. Answer: a map of concepts and their
relationships used for databases.
⩥ Logical Data Model. Answer: Provides foundation for designing a
database
⩥ Physical Data Model. Answer: a representation of a data design as
implemented, or intended to be implemented, in a database management
system
⩥ Pointers. Answer: Used to show the relationship between data fields
and tables.
, ⩥ Referential Integrity. Answer: Table relationships must always be
consistent; for an entity or object to exist in a table, an equal value must
exist in the referenced table; the primary and foreign keys must be equal.
⩥ Types of relationships in a relational database model. Answer: One-to-
One, One-to-Many, and Many-to-Many
⩥ Data Manipulation Language. Answer: A language that allows users to
easily modify the data in a database.
⩥ Data Warehousing. Answer: a system used for reporting and data
analysis, and is considered a core component of business intelligence;
data is stored in one place.
⩥ data mart. Answer: smaller subset database from a data warehouse
typically focused on a single area or function.
⩥ Extraction, transformation, and loading (ETL). Answer: a process in
which data is extracted from a computer, transformed (or cleansed) into
a format appropriate for the data warehouse, and then transferred to the
data warehouse.
⩥ Direct Move. Answer: Data that does not need to be transformed
being transferred to a data warehouse.
ADMINISTRATION 200 QUESTIONS
ACTUAL PAPER 2026 COMPLETE
QUESTIONS AND ANSWERS GRADED A+
⩥ Foreign Key. Answer: Field that is a primary key to another table.
⩥ Schema. Answer: The complete description of the database.
⩥ Variable. Answer: a data type or simply type is a classification of data
which tells the compiler or interpreter how the programmer intends to
use the data; can become incompatible with data warehouse design.
⩥ Flat File Database. Answer: Stores data in plain text, holding one
record; cannot contain multiple tables like a relational database.
⩥ Online Analytical processing (OLAP). Answer: analyze transaction
data used for making decisions; multidimensional (cubical) data;
requires a lengthy, complex loading and updating phase.
⩥ Online transaction processing (OLTP). Answer: database design used
for browsing and manipulating business transaction activity.
,Processing of information into the database.
Don't perform analyses on these databases because it could affect
performance.
⩥ relational database. Answer: type of database in which multiple
information files are combined into one database in one location, where
data are stored in two-dimensional tables known as relations and contain
multiple entities and attributes
⩥ Object-Oriented Database. Answer: A database that is designed to
store mixed media, as opposed to tables in relational databases.
⩥ Conceptual Data Model. Answer: a map of concepts and their
relationships used for databases.
⩥ Logical Data Model. Answer: Provides foundation for designing a
database
⩥ Physical Data Model. Answer: a representation of a data design as
implemented, or intended to be implemented, in a database management
system
⩥ Pointers. Answer: Used to show the relationship between data fields
and tables.
, ⩥ Referential Integrity. Answer: Table relationships must always be
consistent; for an entity or object to exist in a table, an equal value must
exist in the referenced table; the primary and foreign keys must be equal.
⩥ Types of relationships in a relational database model. Answer: One-to-
One, One-to-Many, and Many-to-Many
⩥ Data Manipulation Language. Answer: A language that allows users to
easily modify the data in a database.
⩥ Data Warehousing. Answer: a system used for reporting and data
analysis, and is considered a core component of business intelligence;
data is stored in one place.
⩥ data mart. Answer: smaller subset database from a data warehouse
typically focused on a single area or function.
⩥ Extraction, transformation, and loading (ETL). Answer: a process in
which data is extracted from a computer, transformed (or cleansed) into
a format appropriate for the data warehouse, and then transferred to the
data warehouse.
⩥ Direct Move. Answer: Data that does not need to be transformed
being transferred to a data warehouse.
