(Excelsior) BUS431 Business Data Analytics - Latest Midterm Review .

BUS431



Business Data Analytics




LATEST MIDTERM REVIEW




© 2024/2025

,1. What is the primary function of a data warehouse?
- A) Transaction processing
- B) Data storage
- C) Online Analytical Processing (OLAP)
- D) All of the above


Correct Answer: D
Rationale: A data warehouse serves multiple functions, including
transaction processing (in some cases), serves as long-term data
storage, and enables OLAP capabilities for analysis and reporting.


2. Which of the following is NOT a step in the data mining
process?
- A) Data collection
- B) Data distribution
- C) Data preprocessing
- D) Data evaluation


Correct Answer: B

© 2024/2025

, Rationale: The data mining process typically includes data
collection, preprocessing, analysis, and evaluation. Data
distribution is not commonly considered a core step.


3. In the context of business analytics, what does ETL stand for?
- A) Extract, Transform, Load
- B) Evaluate, Transfer, Link
- C) Extract, Test, Load
- D) Engage, Transform, Learn


Correct Answer: A
Rationale: ETL is a crucial process in data warehousing that
stands for Extract, Transform, and Load.


4. What is the main benefit of using predictive analytics?
- A) It provides historical data analysis
- B) It can forecast future trends based on historical data
- C) It focuses exclusively on real-time data
- D) It eliminates the need for data cleaning


Correct Answer: B

© 2024/2025