Business Intelligence Final
QUESTIONS WITH 100% CORRECT
ANSWERS 2025/2026
Data Warehouse - ANS ✔✔A collection of data created to support decision making; that is
Subject Oriented, Integrated, Time Variant, and Nonvolatile
Data Mart - ANS ✔✔Stores data for a limited number of subject areas, used for specific
applications
Independent Data Mart - ANS ✔✔Data Mart created directly from source systems
Dependent Data Mart - ANS ✔✔Data Mart created with data drawn from a data warehouse
Source System - ANS ✔✔A system that produces data, can be an ERP, Web, Third Party, ect, can
produce many different types of data
ETL (Extraction, Transformation, Load) - ANS ✔✔Process of moving data from a source into a
database
Operational Data Store - ANS ✔✔It consolidates data from multiple sources and provides a near
real-time view of volatile current data
Oper Mart - ANS ✔✔Created when current operational data needs to be analyzed
multidimensionally
Customer Information - ANS ✔✔The most crucial area of data quality
QUESTIONS WITH 100% CORRECT
ANSWERS 2025/2026
Data Warehouse - ANS ✔✔A collection of data created to support decision making; that is
Subject Oriented, Integrated, Time Variant, and Nonvolatile
Data Mart - ANS ✔✔Stores data for a limited number of subject areas, used for specific
applications
Independent Data Mart - ANS ✔✔Data Mart created directly from source systems
Dependent Data Mart - ANS ✔✔Data Mart created with data drawn from a data warehouse
Source System - ANS ✔✔A system that produces data, can be an ERP, Web, Third Party, ect, can
produce many different types of data
ETL (Extraction, Transformation, Load) - ANS ✔✔Process of moving data from a source into a
database
Operational Data Store - ANS ✔✔It consolidates data from multiple sources and provides a near
real-time view of volatile current data
Oper Mart - ANS ✔✔Created when current operational data needs to be analyzed
multidimensionally
Customer Information - ANS ✔✔The most crucial area of data quality