IS 410 Final Exam Review Questions with
Correct Answers
Data Warehouse
A subject-oriented, integrated, time-variant, non-updatable collection of data used in support
of management decision-making processes
Data Mart
A data warehouse that is limited in scope
Operational System
a system that is used to run a business in real time, based on current data; also called a system
of record
Informational system
a system designed to support decision making based on historical point-in-time and
prediction data for complex queries or data-mining applications
Data Warehouse Scope
Application independent, Centralized, possibly enterprise-wide, Planned
Star Schema Factless Facts Tables
No non-key data, but foreign keys for associated dimensions
Used for:
Tracking events
Inventory coverage
Data Mart Scope
, Specific DSS application
Decentralized by user area
Organic, possibly not planned
Star Schema Multiple Facts Table
Can improve performance
Often used to store facts for different combinations of dimensions
Conformed dimensions
Consolidation(ETL)
Consolidating all data into a centralized database (like a data warehouse)
Data federation (EII)
Provides a virtual view of data without actually creating one centralized database
Data propagation (EAI and EDR)
Duplicate data across databases, with near real-time delay
Big Data
Data that exist in very large volumes and many different varieties (data types) and that need
to be processed at a very high velocity (speed)
Analytics
Correct Answers
Data Warehouse
A subject-oriented, integrated, time-variant, non-updatable collection of data used in support
of management decision-making processes
Data Mart
A data warehouse that is limited in scope
Operational System
a system that is used to run a business in real time, based on current data; also called a system
of record
Informational system
a system designed to support decision making based on historical point-in-time and
prediction data for complex queries or data-mining applications
Data Warehouse Scope
Application independent, Centralized, possibly enterprise-wide, Planned
Star Schema Factless Facts Tables
No non-key data, but foreign keys for associated dimensions
Used for:
Tracking events
Inventory coverage
Data Mart Scope
, Specific DSS application
Decentralized by user area
Organic, possibly not planned
Star Schema Multiple Facts Table
Can improve performance
Often used to store facts for different combinations of dimensions
Conformed dimensions
Consolidation(ETL)
Consolidating all data into a centralized database (like a data warehouse)
Data federation (EII)
Provides a virtual view of data without actually creating one centralized database
Data propagation (EAI and EDR)
Duplicate data across databases, with near real-time delay
Big Data
Data that exist in very large volumes and many different varieties (data types) and that need
to be processed at a very high velocity (speed)
Analytics
