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