Page |1
WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA ACTUAL UPDATED EXAM WITH
EXPERTLY AND CORRECTLY ANSWERED
QUESTIONS| WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA ACTUAL UPDATED EXAM | ACE
YOUR GRADES!!!
1. Extraction in ETL - Correct Answer-Data extracted and put into staging
area.
2. Cleanse in ETL - Correct Answer-Errors are eliminated from data;
standard abbreviations applied.
3. Integrate in ETL - Correct Answer-Data is put into a uniform structure;
Data converted to uniform structure.
4. Restructure in ETL - Correct Answer-Data is structured in a design that
is optimal for analysis.
5. Load in ETL - Correct Answer-Data is loaded to the data warehouse.
, Page |2
6. Issue focused on 'Load' component of ETL - Correct Answer-Monitor
refreshing volume and frequency.
7. Step in ETL Process where raw data is aggregated - Correct Answer-
Transformation steps.
8. Data mining activities - Correct Answer-1. Clustering & Segmentation 2.
Classification 3. Estimation 4. Prediction 5. Affinity Grouping 6.
Description.
9. Clustering & Segmentation - Correct Answer-Taking large entity and
dividing into smaller groups of entities. Useful when unsure of what
looking for.
10. Classification (Data Mining) - Correct Answer-Organizing data into
predefined classes.
11. Estimation (Data Mining) - Correct Answer-Assigning a numeric value
to an object.
12. Prediction (Data Mining) - Correct Answer-Classifying objects
according to an expected future behavior.
, Page |3
13. Affinity Grouping - Correct Answer-Evaluating relationships between
data elements that demonstrate some kind of affinity between objects.
14. Entity types - Correct Answer-The uniquely identifiable element about
which data can be categorized in an entity-relationship diagram.
15. Referential integrity rules by modern relational database
management systems - Correct Answer-Insert, Update, Delete.
16. DISTINCT clause - Correct Answer-Returns only unique or 'distinct'
values; Filters Data Results.
17. ORDER BY clause - Correct Answer-Modifies presentation of data
results.
18. Heap file - Correct Answer-A file where records can be placed
anywhere in the memory.
, Page |4
19. Hash file - Correct Answer-A file that uses Hash function computation
on some fields of the records, and the result of that computation
determines where the record is stored.
20. Major Joins - Correct Answer-- LEFT JOIN - RIGHT JOIN - INNER
JOIN - FULL JOIN.
21. Joins - Correct Answer-Joins usually compare the foreign key of one
table to the primary key of another table (but can join any columns) -
joining together data from two tables into one table.
22. LEFT JOIN - Correct Answer-Selects all the rows from the left table,
and only matching rows from the right table.
23. RIGHT JOIN - Correct Answer-Selects all the rows from the right
table, and only matching rows from the left table.
24. OUTER JOIN - Correct Answer-Any join that selects unmatched
rows; LEFT, RIGHT, or FULL JOINS.
25. INNER JOIN - Correct Answer-Joins together only rows that match
from both tables - contains no unmatched rows.
WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA ACTUAL UPDATED EXAM WITH
EXPERTLY AND CORRECTLY ANSWERED
QUESTIONS| WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA ACTUAL UPDATED EXAM | ACE
YOUR GRADES!!!
1. Extraction in ETL - Correct Answer-Data extracted and put into staging
area.
2. Cleanse in ETL - Correct Answer-Errors are eliminated from data;
standard abbreviations applied.
3. Integrate in ETL - Correct Answer-Data is put into a uniform structure;
Data converted to uniform structure.
4. Restructure in ETL - Correct Answer-Data is structured in a design that
is optimal for analysis.
5. Load in ETL - Correct Answer-Data is loaded to the data warehouse.
, Page |2
6. Issue focused on 'Load' component of ETL - Correct Answer-Monitor
refreshing volume and frequency.
7. Step in ETL Process where raw data is aggregated - Correct Answer-
Transformation steps.
8. Data mining activities - Correct Answer-1. Clustering & Segmentation 2.
Classification 3. Estimation 4. Prediction 5. Affinity Grouping 6.
Description.
9. Clustering & Segmentation - Correct Answer-Taking large entity and
dividing into smaller groups of entities. Useful when unsure of what
looking for.
10. Classification (Data Mining) - Correct Answer-Organizing data into
predefined classes.
11. Estimation (Data Mining) - Correct Answer-Assigning a numeric value
to an object.
12. Prediction (Data Mining) - Correct Answer-Classifying objects
according to an expected future behavior.
, Page |3
13. Affinity Grouping - Correct Answer-Evaluating relationships between
data elements that demonstrate some kind of affinity between objects.
14. Entity types - Correct Answer-The uniquely identifiable element about
which data can be categorized in an entity-relationship diagram.
15. Referential integrity rules by modern relational database
management systems - Correct Answer-Insert, Update, Delete.
16. DISTINCT clause - Correct Answer-Returns only unique or 'distinct'
values; Filters Data Results.
17. ORDER BY clause - Correct Answer-Modifies presentation of data
results.
18. Heap file - Correct Answer-A file where records can be placed
anywhere in the memory.
, Page |4
19. Hash file - Correct Answer-A file that uses Hash function computation
on some fields of the records, and the result of that computation
determines where the record is stored.
20. Major Joins - Correct Answer-- LEFT JOIN - RIGHT JOIN - INNER
JOIN - FULL JOIN.
21. Joins - Correct Answer-Joins usually compare the foreign key of one
table to the primary key of another table (but can join any columns) -
joining together data from two tables into one table.
22. LEFT JOIN - Correct Answer-Selects all the rows from the left table,
and only matching rows from the right table.
23. RIGHT JOIN - Correct Answer-Selects all the rows from the right
table, and only matching rows from the left table.
24. OUTER JOIN - Correct Answer-Any join that selects unmatched
rows; LEFT, RIGHT, or FULL JOINS.
25. INNER JOIN - Correct Answer-Joins together only rows that match
from both tables - contains no unmatched rows.
