CIS 405 FINAL EXAM QUESTIONS AND 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.
There is "one size fits all" data warehouse architecture. True or False? - CORRECT ANSWER✅✅False
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.
There is "one size fits all" data warehouse architecture. True or False? - CORRECT ANSWER✅✅False
