CIS 405 FINAL 2025 EXAM QUESTIONS WITH
COMPLETE SOLUTIONS.
In ETL Process "Q" stands for Answer - Quality assurance
A Fact Answer - Center of the schema
Computing power of Hadoop is Answer - Decentralized
Keyword to indicate dimensionality of business intelligence Answer - "Tables"
An active data warehouse is useful for what type of decision making Answer -
Strategic and tactical decision-making
The primary mechanism for data integration in a data warehouse environment
is? Answer - ETL
When data is changed during the loading process what part of ETL is that?
Answer - Transformation (T)
Star Schema Answer - Is a central fact table surrounded by and connected to
several dimension tables. "denormalized"
, Snowflake Schema Answer - Is multidimensional arrangement. A chain of
relationships. "Normalized"
Do governments use business intelligence. True or False? Answer - True
The process of business intelligence is? Answer - Transformation of data to
information then to decisions and finally actions
Which database is not typically used for data warehousing? Answer - Microsoft
Access
Data mining "tells us what is likely to happen and why" Answer - Data-driven
hypotheses and probable outcomes
Can multiple enterprise data warehouses overlap with information? Answer -
True
2010 data approaches are? Answer - Big Data analytics, social media analytics,
2000's data approaches are? Answer - Business intelligence popularized with
data mining a predictive modeling.
1990's approaches are? Answer - Data warehousing was born
1980's approaches are? Answer - Business data warehouse term was coined
and relational Data base management system.
COMPLETE SOLUTIONS.
In ETL Process "Q" stands for Answer - Quality assurance
A Fact Answer - Center of the schema
Computing power of Hadoop is Answer - Decentralized
Keyword to indicate dimensionality of business intelligence Answer - "Tables"
An active data warehouse is useful for what type of decision making Answer -
Strategic and tactical decision-making
The primary mechanism for data integration in a data warehouse environment
is? Answer - ETL
When data is changed during the loading process what part of ETL is that?
Answer - Transformation (T)
Star Schema Answer - Is a central fact table surrounded by and connected to
several dimension tables. "denormalized"
, Snowflake Schema Answer - Is multidimensional arrangement. A chain of
relationships. "Normalized"
Do governments use business intelligence. True or False? Answer - True
The process of business intelligence is? Answer - Transformation of data to
information then to decisions and finally actions
Which database is not typically used for data warehousing? Answer - Microsoft
Access
Data mining "tells us what is likely to happen and why" Answer - Data-driven
hypotheses and probable outcomes
Can multiple enterprise data warehouses overlap with information? Answer -
True
2010 data approaches are? Answer - Big Data analytics, social media analytics,
2000's data approaches are? Answer - Business intelligence popularized with
data mining a predictive modeling.
1990's approaches are? Answer - Data warehousing was born
1980's approaches are? Answer - Business data warehouse term was coined
and relational Data base management system.
