WGU C175 or D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS || ALREADY
GRADED A+ <UPDATED VERSION>
Common attribute - ANSWER ✔ Defines how a table can be logically connected
to another table
Superkey - ANSWER ✔ An attribute (or group of attributes) that uniquely
identifies each entity in a table
Foreign key - ANSWER ✔ Must match a primary key in a related table
ERD - ANSWER ✔ Used to graphically represent the conceptual database model
Derived attribute - ANSWER ✔ Need not be physically stored within the database
Atomic attribute - ANSWER ✔ An attribute that cannot be subdivided
Existence-Independent - ANSWER ✔ An entity that can exist apart from one or
more related entities
Partial-Dependencies - ANSWER ✔ Dependencies based on only a part of a
composite key
LIKE - ANSWER ✔ A special operator used to check for similar character strings
INSERT - ANSWER ✔ SQL command that lets you insert data into a table, one
row at a time
,UPDATE - ANSWER ✔ SQL command that enables you to make changes in the
data
data integrity problems - ANSWER ✔ Issues that affect the accuracy and
consistency of data.
Normalization - ANSWER ✔ A process that works through a series of normal
forms.
partial dependencies - ANSWER ✔ Dependencies based on only a part of a
composite primary key.
1NF relationship - ANSWER ✔ A table that has all key attributes defined, no
repeating groups, and all its attributes are dependent on the primary key.
SELECT * FROM PRODUCT; - ANSWER ✔ The SQL command to list all the
contents of the PRODUCT table.
DELETE - ANSWER ✔ The SQL command used to delete a table row.
DROP - ANSWER ✔ The SQL command that can delete a table from the
database.
SET columnname = expression - ANSWER ✔ The command that replaces *****
in the UPDATE statement.
full outer join - ANSWER ✔ Returns rows with matching values and includes all
rows from both tables (T1 and T2) with unmatched values.
ETL - ANSWER ✔ Extract, Transform, Load in database management.
Transformation - ANSWER ✔ The step in the ETL process where raw data sets
are aggregated.
data extraction - ANSWER ✔ Extract or copy raw data from multiple sources and
store it in a staging area.
, data transformation - ANSWER ✔ Transform and consolidate the raw data in the
staging area to prepare it for the target data warehouse.
data loading - ANSWER ✔ Moves the transformed data from the staging area into
the target data storage or warehouse.
unnormalized forms - ANSWER ✔ Tables that have repeating groups, contain
multi-valued fields, or fields that contain multiple values.
affinity grouping - ANSWER ✔ The process of evaluating relationships between
data elements to demonstrate an affinity or link between objects.
Prediction - ANSWER ✔ Classifies objects according to an expected future
behavior.
Data warehouse - ANSWER ✔ The primary source of information that feeds
analytical processing for an organization's data analysis.
Increased profitability and increased throughput - ANSWER ✔ The set of results a
company should expect from implementing a business intelligence system.
Data Mart - ANSWER ✔ A subject-oriented data repository smaller than a data
warehouse and normally for a smaller or specific group within an organization.
OLAP vs OLTP - ANSWER ✔ OLAP is for analysis, and OLTP is for transaction
processing.
Staging Area - ANSWER ✔ The infrastructure where raw data sets are
aggregated.
Transformation processes - ANSWER ✔ Data type conversion, Data Cleansing,
Integration, Referential integrity checking, Derivations, Denormalization,
Renormalization, Aggregation, Audits, Null conversions.
Load step of ETL - ANSWER ✔ Focused on moving transformed data into the
data warehouse.
, Directed Knowledge Discovery - ANSWER ✔ Knowledge where you already
have identified the problem you want to resolve.
Undirected Knowledge Discovery - ANSWER ✔ Knowledge where you find
patterns within data sets as a way to discover something interesting or an issue.
Classification - ANSWER ✔ Examine the attributes of a particular object and
assign it a defined class.
Estimation - ANSWER ✔ The process of assigning continuously valued numeric
value to an object.
Clustering - ANSWER ✔ Task of taking large collections of objects and dividing
them into smaller groups.
Third Normal Form - ANSWER ✔ When all non-key columns depend on the key,
the whole key, and nothing but the key.
Fact - ANSWER ✔ A pair of related values in databases.
Boyce-Codd Form - ANSWER ✔ The same as third normal form except it applies
to all key columns instead of just non-key columns.
Performance tuning - ANSWER ✔ Relates to the activities that make the database
execute transactions more efficiently in terms of storage and access speed.
query result set - ANSWER ✔ The response of the DBMS to a query.
Field - ANSWER ✔ Refers to a collection of related records.
data dictionary - ANSWER ✔ The DBMS uses the data dictionary to look up the
required data component structures and relationships, thus relieving programmers
from having to code such complex relationships in each program.
database management system - ANSWER ✔ A(n) database management system is
a collection of programs that manages the database structure and controls access to
the data stored in the database.
FOUNDATIONS OA EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS || ALREADY
GRADED A+ <UPDATED VERSION>
Common attribute - ANSWER ✔ Defines how a table can be logically connected
to another table
Superkey - ANSWER ✔ An attribute (or group of attributes) that uniquely
identifies each entity in a table
Foreign key - ANSWER ✔ Must match a primary key in a related table
ERD - ANSWER ✔ Used to graphically represent the conceptual database model
Derived attribute - ANSWER ✔ Need not be physically stored within the database
Atomic attribute - ANSWER ✔ An attribute that cannot be subdivided
Existence-Independent - ANSWER ✔ An entity that can exist apart from one or
more related entities
Partial-Dependencies - ANSWER ✔ Dependencies based on only a part of a
composite key
LIKE - ANSWER ✔ A special operator used to check for similar character strings
INSERT - ANSWER ✔ SQL command that lets you insert data into a table, one
row at a time
,UPDATE - ANSWER ✔ SQL command that enables you to make changes in the
data
data integrity problems - ANSWER ✔ Issues that affect the accuracy and
consistency of data.
Normalization - ANSWER ✔ A process that works through a series of normal
forms.
partial dependencies - ANSWER ✔ Dependencies based on only a part of a
composite primary key.
1NF relationship - ANSWER ✔ A table that has all key attributes defined, no
repeating groups, and all its attributes are dependent on the primary key.
SELECT * FROM PRODUCT; - ANSWER ✔ The SQL command to list all the
contents of the PRODUCT table.
DELETE - ANSWER ✔ The SQL command used to delete a table row.
DROP - ANSWER ✔ The SQL command that can delete a table from the
database.
SET columnname = expression - ANSWER ✔ The command that replaces *****
in the UPDATE statement.
full outer join - ANSWER ✔ Returns rows with matching values and includes all
rows from both tables (T1 and T2) with unmatched values.
ETL - ANSWER ✔ Extract, Transform, Load in database management.
Transformation - ANSWER ✔ The step in the ETL process where raw data sets
are aggregated.
data extraction - ANSWER ✔ Extract or copy raw data from multiple sources and
store it in a staging area.
, data transformation - ANSWER ✔ Transform and consolidate the raw data in the
staging area to prepare it for the target data warehouse.
data loading - ANSWER ✔ Moves the transformed data from the staging area into
the target data storage or warehouse.
unnormalized forms - ANSWER ✔ Tables that have repeating groups, contain
multi-valued fields, or fields that contain multiple values.
affinity grouping - ANSWER ✔ The process of evaluating relationships between
data elements to demonstrate an affinity or link between objects.
Prediction - ANSWER ✔ Classifies objects according to an expected future
behavior.
Data warehouse - ANSWER ✔ The primary source of information that feeds
analytical processing for an organization's data analysis.
Increased profitability and increased throughput - ANSWER ✔ The set of results a
company should expect from implementing a business intelligence system.
Data Mart - ANSWER ✔ A subject-oriented data repository smaller than a data
warehouse and normally for a smaller or specific group within an organization.
OLAP vs OLTP - ANSWER ✔ OLAP is for analysis, and OLTP is for transaction
processing.
Staging Area - ANSWER ✔ The infrastructure where raw data sets are
aggregated.
Transformation processes - ANSWER ✔ Data type conversion, Data Cleansing,
Integration, Referential integrity checking, Derivations, Denormalization,
Renormalization, Aggregation, Audits, Null conversions.
Load step of ETL - ANSWER ✔ Focused on moving transformed data into the
data warehouse.
, Directed Knowledge Discovery - ANSWER ✔ Knowledge where you already
have identified the problem you want to resolve.
Undirected Knowledge Discovery - ANSWER ✔ Knowledge where you find
patterns within data sets as a way to discover something interesting or an issue.
Classification - ANSWER ✔ Examine the attributes of a particular object and
assign it a defined class.
Estimation - ANSWER ✔ The process of assigning continuously valued numeric
value to an object.
Clustering - ANSWER ✔ Task of taking large collections of objects and dividing
them into smaller groups.
Third Normal Form - ANSWER ✔ When all non-key columns depend on the key,
the whole key, and nothing but the key.
Fact - ANSWER ✔ A pair of related values in databases.
Boyce-Codd Form - ANSWER ✔ The same as third normal form except it applies
to all key columns instead of just non-key columns.
Performance tuning - ANSWER ✔ Relates to the activities that make the database
execute transactions more efficiently in terms of storage and access speed.
query result set - ANSWER ✔ The response of the DBMS to a query.
Field - ANSWER ✔ Refers to a collection of related records.
data dictionary - ANSWER ✔ The DBMS uses the data dictionary to look up the
required data component structures and relationships, thus relieving programmers
from having to code such complex relationships in each program.
database management system - ANSWER ✔ A(n) database management system is
a collection of programs that manages the database structure and controls access to
the data stored in the database.
