CIS 405 Final Exam UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
In ETL Process "Q" stands for - CORRECT ANSWER Quality assurance
A Fact - CORRECT ANSWER Center of the schema
Computing power of Hadoop is - CORRECT ANSWER Decentralized
Keyword to indicate dimensionality of business intelligence - CORRECT ANSWER "Tables"
An active data warehouse is useful for what type of decision making - CORRECT
ANSWER Strategic and tactical decision-making
The primary mechanism for data integration in a data warehouse environment is? - CORRECT
ANSWER ETL
When data is changed during the loading process what part of ETL is that? - CORRECT
ANSWER Transformation (T)
Star Schema - CORRECT ANSWER Is a central fact table surrounded by and connected to
several dimension tables. "denormalized"
Snowflake Schema - CORRECT ANSWER Is multidimensional arrangement. A chain of
relationships. "Normalized"
Do governments use business intelligence. True or False? - CORRECT ANSWER True
The process of business intelligence is? - CORRECT ANSWER Transformation of data to
information then to decisions and finally actions
, Which database is not typically used for data warehousing? - CORRECT ANSWER Microsoft
Access
Data mining "tells us what is likely to happen and why" - CORRECT ANSWER Data-driven
hypotheses and probable outcomes
Can multiple enterprise data warehouses overlap with information? - CORRECT
ANSWER True
2010 data approaches are? - CORRECT ANSWER Big Data analytics, social media analytics,
2000's data approaches are? - CORRECT ANSWER Business intelligence popularized with
data mining a predictive modeling.
1990's approaches are? - CORRECT ANSWER Data warehousing was born
1980's approaches are? - CORRECT ANSWER Business data warehouse term was coined and
relational Data base management system.
1970's approaches are? - CORRECT ANSWER routine reporting and primitive database
structures.
Data warehouse is these three things? - CORRECT ANSWER Is a collection of data that is
consolidated to support decision making, contain historical information, is organized by subject area.
Dependent Data Mart receives its data from - CORRECT ANSWER one or more source
systems rather than a data warehouse.
During the ETL process you do not bring in all the possible data from gathered from the report -
CORRECT ANSWER True, selecting all the data will overload the system and slow down
memory capabilities.
QUESTIONS AND CORRECT ANSWERS
In ETL Process "Q" stands for - CORRECT ANSWER Quality assurance
A Fact - CORRECT ANSWER Center of the schema
Computing power of Hadoop is - CORRECT ANSWER Decentralized
Keyword to indicate dimensionality of business intelligence - CORRECT ANSWER "Tables"
An active data warehouse is useful for what type of decision making - CORRECT
ANSWER Strategic and tactical decision-making
The primary mechanism for data integration in a data warehouse environment is? - CORRECT
ANSWER ETL
When data is changed during the loading process what part of ETL is that? - CORRECT
ANSWER Transformation (T)
Star Schema - CORRECT ANSWER Is a central fact table surrounded by and connected to
several dimension tables. "denormalized"
Snowflake Schema - CORRECT ANSWER Is multidimensional arrangement. A chain of
relationships. "Normalized"
Do governments use business intelligence. True or False? - CORRECT ANSWER True
The process of business intelligence is? - CORRECT ANSWER Transformation of data to
information then to decisions and finally actions
, Which database is not typically used for data warehousing? - CORRECT ANSWER Microsoft
Access
Data mining "tells us what is likely to happen and why" - CORRECT ANSWER Data-driven
hypotheses and probable outcomes
Can multiple enterprise data warehouses overlap with information? - CORRECT
ANSWER True
2010 data approaches are? - CORRECT ANSWER Big Data analytics, social media analytics,
2000's data approaches are? - CORRECT ANSWER Business intelligence popularized with
data mining a predictive modeling.
1990's approaches are? - CORRECT ANSWER Data warehousing was born
1980's approaches are? - CORRECT ANSWER Business data warehouse term was coined and
relational Data base management system.
1970's approaches are? - CORRECT ANSWER routine reporting and primitive database
structures.
Data warehouse is these three things? - CORRECT ANSWER Is a collection of data that is
consolidated to support decision making, contain historical information, is organized by subject area.
Dependent Data Mart receives its data from - CORRECT ANSWER one or more source
systems rather than a data warehouse.
During the ETL process you do not bring in all the possible data from gathered from the report -
CORRECT ANSWER True, selecting all the data will overload the system and slow down
memory capabilities.
