WGU C175 Data Management Pre course
Study Guide Exam Questions and Verified for
Accuracy Answers 2024/2025
Business Intelligence - correct answer the processes, technologies, and tools needed
to turn data into information, information into knowledge, and knowledge into plans that
drive profitable business action.
Classification - correct answer Classification involves examining the attributes of a
particular object and assigning it to a defined class.
Clustering - correct answer Clustering is the task of taking a large collection of objects
and dividing them into smaller groups of objects that exhibit some similarity.
Affinity Grouping - correct answer Affinity Grouping is a process of evaluating
relationships or associations between data elements that demonstrate some kind of
affinity between objects.
What are the values of Business Intelligence? - correct answer - Financial value
associated w/ increased profitability.
- Productivity value associated with increased throughput.
- Trust value (customer, employee, supplier satisfaction) as well as increased
confidence in forecasting.
- Risk value - decreased risk associated with decision making
What are the reasons for using the Dimensional Model for Business Intelligence? -
correct answer - Simplicity.
- Lack of bias.
- Extensibility.
,What are the fundamental aspects of a Data Warehouse? - correct answer -
Centralized repository of information.
- Organized around relevant subject areas.
- Provides platform for queries.
- Used for analysis and not transactional
processing.
- Data is nonvolatile.
- Target location for integrating data from multiple sources.
What is the general theme of the ETL process? - correct answer 1. Get the data
2. Map the data to staging area
3. Validate and clean the data
4. Apply necessary transformations
5. Map data to loading model
6. Move data to repository
7. Load data to warehouse
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
Data Warehouse - correct answer A data warehouse is the primary source of
information that feeds the analytical processing within an organization.
Data Mart - correct answer A data mart is a subject-oriented data repository, similar in
structure to the enterprise data warehouse, but it's main purpose is to serve directed
reporting and drill down into specific data.
OLAP - correct answer OLAP (Online Analytical Processing) is both a process of
viewing comparative metrics via a multidimensional analysis of data and the
infrastructure to support that process.
OTAP - correct answer OTAP (online transaction processing) provides a means for
presenting data sourced from a data warehouse or a data mart in a way that allows the
data consumer to view comparative metrics across multiple dimensions.
Cartesian product - correct answer Usually the result of a missing join condition or a
method of expanding the data of 1 table by the number of rows in the second table.
Data volatility - correct answer Describes how often stored data is updated.
DCL - correct answer Data control language is used to control access to data stored in
a database.
Definer - correct answer Definer is a MySQL term where AuthID is the same for
another DBMS
Study Guide Exam Questions and Verified for
Accuracy Answers 2024/2025
Business Intelligence - correct answer the processes, technologies, and tools needed
to turn data into information, information into knowledge, and knowledge into plans that
drive profitable business action.
Classification - correct answer Classification involves examining the attributes of a
particular object and assigning it to a defined class.
Clustering - correct answer Clustering is the task of taking a large collection of objects
and dividing them into smaller groups of objects that exhibit some similarity.
Affinity Grouping - correct answer Affinity Grouping is a process of evaluating
relationships or associations between data elements that demonstrate some kind of
affinity between objects.
What are the values of Business Intelligence? - correct answer - Financial value
associated w/ increased profitability.
- Productivity value associated with increased throughput.
- Trust value (customer, employee, supplier satisfaction) as well as increased
confidence in forecasting.
- Risk value - decreased risk associated with decision making
What are the reasons for using the Dimensional Model for Business Intelligence? -
correct answer - Simplicity.
- Lack of bias.
- Extensibility.
,What are the fundamental aspects of a Data Warehouse? - correct answer -
Centralized repository of information.
- Organized around relevant subject areas.
- Provides platform for queries.
- Used for analysis and not transactional
processing.
- Data is nonvolatile.
- Target location for integrating data from multiple sources.
What is the general theme of the ETL process? - correct answer 1. Get the data
2. Map the data to staging area
3. Validate and clean the data
4. Apply necessary transformations
5. Map data to loading model
6. Move data to repository
7. Load data to warehouse
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
Data Warehouse - correct answer A data warehouse is the primary source of
information that feeds the analytical processing within an organization.
Data Mart - correct answer A data mart is a subject-oriented data repository, similar in
structure to the enterprise data warehouse, but it's main purpose is to serve directed
reporting and drill down into specific data.
OLAP - correct answer OLAP (Online Analytical Processing) is both a process of
viewing comparative metrics via a multidimensional analysis of data and the
infrastructure to support that process.
OTAP - correct answer OTAP (online transaction processing) provides a means for
presenting data sourced from a data warehouse or a data mart in a way that allows the
data consumer to view comparative metrics across multiple dimensions.
Cartesian product - correct answer Usually the result of a missing join condition or a
method of expanding the data of 1 table by the number of rows in the second table.
Data volatility - correct answer Describes how often stored data is updated.
DCL - correct answer Data control language is used to control access to data stored in
a database.
Definer - correct answer Definer is a MySQL term where AuthID is the same for
another DBMS
