DATA WAREHOUSING EXAMINATION QUESTIONS AND
CORRECT ANSWER WITH EXPLANATION GRADED A+
STUDY GUIDE SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Data warehousing is the process of:
A. Storing and managing large volumes of data for analysis
B. Deleting system files
C. Encrypting emails
D. Building hardware
Answer: A
Rationale: Data warehousing focuses on analytical data storage.
2. A data warehouse is primarily used for:
A. Decision making and analysis
B. Gaming
C. Hardware repair
D. Networking
Answer: A
Rationale: It supports business intelligence.
3. Data in a warehouse is usually:
A. Historical and integrated
B. Random and unstructured only
C. Temporary only
D. Encrypted only
Answer: A
Rationale: Warehouses store historical data.
4. OLAP stands for:
,A. Online Analytical Processing
B. Online Application Protocol
C. Offline Analytical Program
D. Output Logic Access Process
Answer: A
Rationale: OLAP supports multidimensional analysis.
5. OLTP stands for:
A. Online Transaction Processing
B. Online Transfer Protocol
C. Offline Transaction Program
D. Output Transaction Process
Answer: A
Rationale: OLTP handles real-time transactions.
6. Data warehouse is optimized for:
A. Query and analysis
B. Transaction processing
C. Gaming
D. Printing
Answer: A
Rationale: Analytical workloads.
7. ETL stands for:
A. Extract, Transform, Load
B. Execute, Transfer, Load
C. Extract, Test, Link
D. Export, Track, Load
Answer: A
Rationale: Data integration process.
8. ELT stands for:
, A. Extract, Load, Transform
B. Execute, Load, Transfer
C. Extract, Link, Transform
D. Encrypt, Load, Transform
Answer: A
Rationale: Modern data processing approach.
9. Data mart is:
A. Subset of data warehouse
B. Full database system
C. Hardware component
D. Network system
Answer: A
Rationale: Department-specific warehouse.
10. Star schema consists of:
A. Fact and dimension tables
B. Only fact tables
C. Only dimension tables
D. Network tables
Answer: A
Rationale: Simple data warehouse model.
11. Snowflake schema is:
A. Normalized star schema
B. Hardware design
C. Network system
D. Encryption model
Answer: A
Rationale: More normalized structure.
12. Fact table contains:
CORRECT ANSWER WITH EXPLANATION GRADED A+
STUDY GUIDE SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Data warehousing is the process of:
A. Storing and managing large volumes of data for analysis
B. Deleting system files
C. Encrypting emails
D. Building hardware
Answer: A
Rationale: Data warehousing focuses on analytical data storage.
2. A data warehouse is primarily used for:
A. Decision making and analysis
B. Gaming
C. Hardware repair
D. Networking
Answer: A
Rationale: It supports business intelligence.
3. Data in a warehouse is usually:
A. Historical and integrated
B. Random and unstructured only
C. Temporary only
D. Encrypted only
Answer: A
Rationale: Warehouses store historical data.
4. OLAP stands for:
,A. Online Analytical Processing
B. Online Application Protocol
C. Offline Analytical Program
D. Output Logic Access Process
Answer: A
Rationale: OLAP supports multidimensional analysis.
5. OLTP stands for:
A. Online Transaction Processing
B. Online Transfer Protocol
C. Offline Transaction Program
D. Output Transaction Process
Answer: A
Rationale: OLTP handles real-time transactions.
6. Data warehouse is optimized for:
A. Query and analysis
B. Transaction processing
C. Gaming
D. Printing
Answer: A
Rationale: Analytical workloads.
7. ETL stands for:
A. Extract, Transform, Load
B. Execute, Transfer, Load
C. Extract, Test, Link
D. Export, Track, Load
Answer: A
Rationale: Data integration process.
8. ELT stands for:
, A. Extract, Load, Transform
B. Execute, Load, Transfer
C. Extract, Link, Transform
D. Encrypt, Load, Transform
Answer: A
Rationale: Modern data processing approach.
9. Data mart is:
A. Subset of data warehouse
B. Full database system
C. Hardware component
D. Network system
Answer: A
Rationale: Department-specific warehouse.
10. Star schema consists of:
A. Fact and dimension tables
B. Only fact tables
C. Only dimension tables
D. Network tables
Answer: A
Rationale: Simple data warehouse model.
11. Snowflake schema is:
A. Normalized star schema
B. Hardware design
C. Network system
D. Encryption model
Answer: A
Rationale: More normalized structure.
12. Fact table contains:
