1. What is the primary function of a data warehouse in Business
Intelligence (BI)?
A) Data cleansing
B) Data storage and management
C) Data presentation
D) Data mining
Answer: B) Data storage and management
Rationale: A data warehouse serves as a central repository of integrated
data from one or more disparate sources. It stores current and historical
data and is used for creating analytical reports for knowledge workers
throughout the enterprise.
2. Which BI tool is best suited for real-time data analysis?
A) OLAP
B) ETL
C) Data mining
D) CEP
Answer: D) CEP (Complex Event Processing)
Rationale: CEP tools are designed to manage data in real-time, analyzing
and processing information as events occur, which is essential for realtime data analysis.
3. In the context of BI, what does 'ETL' stand for?
A) Extract, Transform, Load
B) Execute, Translate, Load
C) Extract, Translate, Leverage
D) Execute, Transform, Leverage
Answer: A) Extract, Transform, Load
Rationale: ETL is a process that extracts data from various sources,
transforms the data for storing in the proper format or structure for the
purposes of querying and analysis, and loads it into the final target
database.
4. What is the role of OLAP in Business Intelligence?
A) Data entry
B) Data mining
C) Data analysis
D) Data visualization
Category | exam bundles |
Comments | 0 |
Rating | |
Sales | 0 |