WGU D426 0A Data Management Foundations
2026 NEW EXAM (COMPLIED FROM REAL
EXAM) 100% ACCURATELY RATED
Data Warehouse
Five-step process - ETL: Extract-Transform Load 1) Extract data 2) Cleanse data 3)
Integrate data 4) Restructure data 5) Load data - Open-source ETL tools: -
PowerCenter -SQL Server Integration Services -Oracle Data Integrator
Data Warehouse Refresh
AKA: Star Schema - Consists of fact and dimension tables. Fact Table - Contains
numeric data used to measure business performance.. Primary key is the composite
for all foreign keys referencing dimension tables. Dimension Table - Contains textual
data that describes the fact data.
Dimensional Design
Sequence of columns in which each column has a one-many relationship to the next
column.
Dimension Hierarchy
A database that stores data in main memory, instead of or in addition to storage media.
Ex: SQL Server In-Memory OLTP - Oracle Database In-Memory - MySQL
In-Memory Databases
A database that is packaged with a programming language. AKA: In-Process Database
(Database Architecture) - SQLite - SQL Server Compact
Embedded Databases
Collection of two or more participating databases under a coordinating software layer
called middleware.
Federated Database
, Relationships are named and classified by their cardinalities, which means count (as in
the number of items in a set). HAS-A relationship. Each of the three types of binary
relationships has a different cardinality. Is the maximum number of entity instances
that can participate in a relationship instance.
Maximum Cardinality
Minimum number of entity instances that must participate in a relationship instance.
These values typically assume a value of zero (optional) or one (mandatory).
Minimum Cardinality
An entity whose instances cannot exist in the database without the existence of an
instance of another entity.
Weak Entity
Can exist in the database independently.
Strong Entity
Can be exclusive or inclusive. Can be a part of an IS-A relationship.
Subtype Entities
Depicted with square corners
Unmatched data from either table is included. Will result in empty fields.
Full Outer Join
Specifies tables, columns, and keys. Implements database requirements in a specific
database system. Also called a schema.
Logical Design
Specifies indexes, table structures, and partitions. Specifies how tables are organized
on storage media.
Physical Design
2026 NEW EXAM (COMPLIED FROM REAL
EXAM) 100% ACCURATELY RATED
Data Warehouse
Five-step process - ETL: Extract-Transform Load 1) Extract data 2) Cleanse data 3)
Integrate data 4) Restructure data 5) Load data - Open-source ETL tools: -
PowerCenter -SQL Server Integration Services -Oracle Data Integrator
Data Warehouse Refresh
AKA: Star Schema - Consists of fact and dimension tables. Fact Table - Contains
numeric data used to measure business performance.. Primary key is the composite
for all foreign keys referencing dimension tables. Dimension Table - Contains textual
data that describes the fact data.
Dimensional Design
Sequence of columns in which each column has a one-many relationship to the next
column.
Dimension Hierarchy
A database that stores data in main memory, instead of or in addition to storage media.
Ex: SQL Server In-Memory OLTP - Oracle Database In-Memory - MySQL
In-Memory Databases
A database that is packaged with a programming language. AKA: In-Process Database
(Database Architecture) - SQLite - SQL Server Compact
Embedded Databases
Collection of two or more participating databases under a coordinating software layer
called middleware.
Federated Database
, Relationships are named and classified by their cardinalities, which means count (as in
the number of items in a set). HAS-A relationship. Each of the three types of binary
relationships has a different cardinality. Is the maximum number of entity instances
that can participate in a relationship instance.
Maximum Cardinality
Minimum number of entity instances that must participate in a relationship instance.
These values typically assume a value of zero (optional) or one (mandatory).
Minimum Cardinality
An entity whose instances cannot exist in the database without the existence of an
instance of another entity.
Weak Entity
Can exist in the database independently.
Strong Entity
Can be exclusive or inclusive. Can be a part of an IS-A relationship.
Subtype Entities
Depicted with square corners
Unmatched data from either table is included. Will result in empty fields.
Full Outer Join
Specifies tables, columns, and keys. Implements database requirements in a specific
database system. Also called a schema.
Logical Design
Specifies indexes, table structures, and partitions. Specifies how tables are organized
on storage media.
Physical Design
