WGU C175 Problem Solving Exam Questions
and With Distinction level Marking scheme
updated 2024/2025
What is the key factor based on the need for linear scalability? - correct answer
Performance
What is used for populating summaries or any cube dimensions that can be performed
at the staging area (ETL)? - correct answer Aggregation
What data mining activity is a process of assigning some continuously valued numeric
value to an object? - correct answer Estimation
What includes exploiting the discovery of table and foreign keys for representing linkage
between different tables? - correct answer Integration
What data mining activity is the process of organizing data into predefined classes? -
correct answer Classification
Which activity groups data members that have similarities? - correct answer Clustering
Business intelligence (BI) - correct answer A comprehensive, cohesive, and integrated
set of tools and processes used to capture, collect, integrate, store, and analyze data
with the purpose of generating and presenting information to support business decision
making.
cube cache - correct answer In multidimensional OLAP, the shared, reserved memory
area where data cubes are held.
dashboards - correct answer In business intelligence, a web-based system that
presents key business performance indicators or information in a single, integrated view
with clear and concise graphics.
, data cube - correct answer The multidimensional data structure used to store and
manipulate data in a multidimensional DBMS.
data mart - correct answer A small, single-subject data warehouse subset that provides
decision support to a small group of people.
data visualization - correct answer Abstracting data to provide information in a visual
format that enhances the user's ability to effectively comprehend the meaning of the
data.
data warehouse - correct answer An integrated, subject-oriented, time-variant,
nonvolatile collection of data in a specialized database that stores historical and
aggregated data in a format that provides support for decision making.
decision support system (DSS) - correct answer An arrangement of computerized tools
used to assist managerial decision making within a business.
dimension tables - correct answer In a data warehouse, tables used to search, filter, or
classify facts within a star schema.
drill down - correct answer To decompose data into more atomic components—that is,
data at lower levels of aggregation. This approach is used primarily in a decision
support system to focus on specific geographic areas, business types, and so on.
extraction, transformation, and loading (ETL) - correct answer In a data warehousing
environment, the integrated processes of getting data from original sources into the data
warehouse.
governance - correct answer In business intelligence, the methods for controlling and
monitoring business health and promoting consistent decision making.
and With Distinction level Marking scheme
updated 2024/2025
What is the key factor based on the need for linear scalability? - correct answer
Performance
What is used for populating summaries or any cube dimensions that can be performed
at the staging area (ETL)? - correct answer Aggregation
What data mining activity is a process of assigning some continuously valued numeric
value to an object? - correct answer Estimation
What includes exploiting the discovery of table and foreign keys for representing linkage
between different tables? - correct answer Integration
What data mining activity is the process of organizing data into predefined classes? -
correct answer Classification
Which activity groups data members that have similarities? - correct answer Clustering
Business intelligence (BI) - correct answer A comprehensive, cohesive, and integrated
set of tools and processes used to capture, collect, integrate, store, and analyze data
with the purpose of generating and presenting information to support business decision
making.
cube cache - correct answer In multidimensional OLAP, the shared, reserved memory
area where data cubes are held.
dashboards - correct answer In business intelligence, a web-based system that
presents key business performance indicators or information in a single, integrated view
with clear and concise graphics.
, data cube - correct answer The multidimensional data structure used to store and
manipulate data in a multidimensional DBMS.
data mart - correct answer A small, single-subject data warehouse subset that provides
decision support to a small group of people.
data visualization - correct answer Abstracting data to provide information in a visual
format that enhances the user's ability to effectively comprehend the meaning of the
data.
data warehouse - correct answer An integrated, subject-oriented, time-variant,
nonvolatile collection of data in a specialized database that stores historical and
aggregated data in a format that provides support for decision making.
decision support system (DSS) - correct answer An arrangement of computerized tools
used to assist managerial decision making within a business.
dimension tables - correct answer In a data warehouse, tables used to search, filter, or
classify facts within a star schema.
drill down - correct answer To decompose data into more atomic components—that is,
data at lower levels of aggregation. This approach is used primarily in a decision
support system to focus on specific geographic areas, business types, and so on.
extraction, transformation, and loading (ETL) - correct answer In a data warehousing
environment, the integrated processes of getting data from original sources into the data
warehouse.
governance - correct answer In business intelligence, the methods for controlling and
monitoring business health and promoting consistent decision making.
