WGU - C175 - data management foundations
Objective Assessment Guide Exam Questions
and Already graded Solutions and Assured
Satisfactions 2024/2025
A centralized repository of information - correct answer data warehouse
This is arranged around the relevant subject areas important to the business. It is also
nonvolatile, not used for transactions but for analysis, and integrates data from multiple
sources. - correct answer data warehouse
Subject-oriented data repository smaller than a data warehouse and normally for a
smaller or specific group within an organization - correct answer data mart
Differences between olap and oltp - correct answer olap is for analysis, and oltp is for
transaction processing
What is etl? - correct answer extract, transform, load
The infrastructure where raw data sets are aggregated - correct answer staging area
What two prime questions are essential to understanding extraction? - correct answer
what and how should data be extracted?
What processes are involved in the transformation step of the etl process? - correct
answer -data type conversion
-data cleansing
-integration
-referential integrity checking
-derivations
, -denormalization
-renormalization
-aggregation
-audits
-null conversions
This step of the etl is focused on moving transformed data into the data warehouse -
correct answer load
What processes are involved in the load step of the etl process? - correct answer -
target dependencies
-refresh volume and frequency
Data mining can be described in this way - correct answer the virtuous cycle
Identifying the business problems, and continual improvement of business processes
that drive discovery of actionable knowledge and taking action based on that knowledge
- correct answer the virtuous cycle
Advantage of views - protect sensitive data - correct answer a table may contain
sensitive data. Ex: the employee table contains compensation columns such as salary
and bonus. A view can exclude sensitive columns but include all other columns.
Authorizing users and programmers access to the view but not the underlying table
protects the sensitive data.
Advantage of views - save complex queries - correct answer complex or difficult select
statements can be saved as a view. Database users can reference the view without
writing the select statement.
Advantage of views - save optimized queries - correct answer often, the same result
table can be generated with equivalent select statements. Although the results of
equivalent statements are the same, performance may vary. To ensure fast execution,
the optimal statement can be saved as a view and distributed to database users.
Objective Assessment Guide Exam Questions
and Already graded Solutions and Assured
Satisfactions 2024/2025
A centralized repository of information - correct answer data warehouse
This is arranged around the relevant subject areas important to the business. It is also
nonvolatile, not used for transactions but for analysis, and integrates data from multiple
sources. - correct answer data warehouse
Subject-oriented data repository smaller than a data warehouse and normally for a
smaller or specific group within an organization - correct answer data mart
Differences between olap and oltp - correct answer olap is for analysis, and oltp is for
transaction processing
What is etl? - correct answer extract, transform, load
The infrastructure where raw data sets are aggregated - correct answer staging area
What two prime questions are essential to understanding extraction? - correct answer
what and how should data be extracted?
What processes are involved in the transformation step of the etl process? - correct
answer -data type conversion
-data cleansing
-integration
-referential integrity checking
-derivations
, -denormalization
-renormalization
-aggregation
-audits
-null conversions
This step of the etl is focused on moving transformed data into the data warehouse -
correct answer load
What processes are involved in the load step of the etl process? - correct answer -
target dependencies
-refresh volume and frequency
Data mining can be described in this way - correct answer the virtuous cycle
Identifying the business problems, and continual improvement of business processes
that drive discovery of actionable knowledge and taking action based on that knowledge
- correct answer the virtuous cycle
Advantage of views - protect sensitive data - correct answer a table may contain
sensitive data. Ex: the employee table contains compensation columns such as salary
and bonus. A view can exclude sensitive columns but include all other columns.
Authorizing users and programmers access to the view but not the underlying table
protects the sensitive data.
Advantage of views - save complex queries - correct answer complex or difficult select
statements can be saved as a view. Database users can reference the view without
writing the select statement.
Advantage of views - save optimized queries - correct answer often, the same result
table can be generated with equivalent select statements. Although the results of
equivalent statements are the same, performance may vary. To ensure fast execution,
the optimal statement can be saved as a view and distributed to database users.
