BUSINESS INTELLIGENCE EXAMINATION QUESTIONS
AND CORRECT ANSWER WITH EXPLANATION GRADED
A+ STUDY GUIDE SOUTHERN NEW HAMPSHIRE
UNIVERSITY
1. Business Intelligence (BI) refers to:
A. Tools and processes for analyzing business data
B. Hardware manufacturing
C. Network security only
D. Software coding only
Answer: A
Rationale: BI focuses on analyzing data for decision-making.
2. The main goal of Business Intelligence is to:
A. Support better decision-making
B. Store files
C. Encrypt data
D. Delete data
Answer: A
Rationale: BI turns data into actionable insights.
3. A BI dashboard is:
A. Visual summary of key metrics
B. Database server
C. Programming language
D. Operating system
Answer: A
Rationale: Dashboards display KPIs visually.
4. KPI stands for:
,A. Key Performance Indicator
B. Known Process Index
C. Key Programming Interface
D. Kernel Processing Indicator
Answer: A
Rationale: KPI measures performance.
5. Data warehouse is used for:
A. Centralized data storage for analysis
B. Real-time gaming
C. Hardware repair
D. Email storage only
Answer: A
Rationale: BI systems store historical data.
6. ETL stands for:
A. Extract, Transform, Load
B. Execute, Transfer, Log
C. Export, Track, Link
D. Extract, Test, Launch
Answer: A
Rationale: Data integration process.
7. Data mining is:
A. Discovering patterns in large datasets
B. Deleting data
C. Encrypting data
D. Storing files
Answer: A
Rationale: Extracting hidden patterns.
8. OLAP stands for:
, A. Online Analytical Processing
B. Offline Logical Analysis Program
C. Online Application Platform
D. Output Logic Access Protocol
Answer: A
Rationale: Multidimensional analysis tool.
9. OLTP stands for:
A. Online Transaction Processing
B. Offline Transaction Program
C. Online Transfer Protocol
D. Output Transaction Process
Answer: A
Rationale: Real-time transaction systems.
10. Data visualization in BI is used to:
A. Present data graphically
B. Encrypt data
C. Delete data
D. Store files
Answer: A
Rationale: Helps interpret data easily.
11. A data warehouse stores:
A. Historical and integrated data
B. Only images
C. Only text files
D. Only programs
Answer: A
Rationale: Central BI repository.
12. A data mart is:
AND CORRECT ANSWER WITH EXPLANATION GRADED
A+ STUDY GUIDE SOUTHERN NEW HAMPSHIRE
UNIVERSITY
1. Business Intelligence (BI) refers to:
A. Tools and processes for analyzing business data
B. Hardware manufacturing
C. Network security only
D. Software coding only
Answer: A
Rationale: BI focuses on analyzing data for decision-making.
2. The main goal of Business Intelligence is to:
A. Support better decision-making
B. Store files
C. Encrypt data
D. Delete data
Answer: A
Rationale: BI turns data into actionable insights.
3. A BI dashboard is:
A. Visual summary of key metrics
B. Database server
C. Programming language
D. Operating system
Answer: A
Rationale: Dashboards display KPIs visually.
4. KPI stands for:
,A. Key Performance Indicator
B. Known Process Index
C. Key Programming Interface
D. Kernel Processing Indicator
Answer: A
Rationale: KPI measures performance.
5. Data warehouse is used for:
A. Centralized data storage for analysis
B. Real-time gaming
C. Hardware repair
D. Email storage only
Answer: A
Rationale: BI systems store historical data.
6. ETL stands for:
A. Extract, Transform, Load
B. Execute, Transfer, Log
C. Export, Track, Link
D. Extract, Test, Launch
Answer: A
Rationale: Data integration process.
7. Data mining is:
A. Discovering patterns in large datasets
B. Deleting data
C. Encrypting data
D. Storing files
Answer: A
Rationale: Extracting hidden patterns.
8. OLAP stands for:
, A. Online Analytical Processing
B. Offline Logical Analysis Program
C. Online Application Platform
D. Output Logic Access Protocol
Answer: A
Rationale: Multidimensional analysis tool.
9. OLTP stands for:
A. Online Transaction Processing
B. Offline Transaction Program
C. Online Transfer Protocol
D. Output Transaction Process
Answer: A
Rationale: Real-time transaction systems.
10. Data visualization in BI is used to:
A. Present data graphically
B. Encrypt data
C. Delete data
D. Store files
Answer: A
Rationale: Helps interpret data easily.
11. A data warehouse stores:
A. Historical and integrated data
B. Only images
C. Only text files
D. Only programs
Answer: A
Rationale: Central BI repository.
12. A data mart is:
