Business Intelligence (Exam 1 Review)
2025 Questions and Answers
What's the most important thing about a Data Warehouse? - --Answer --It
becomes a single version of truth for a company.
What is a 'data warehouse'? - --Answer --A physical repository where
relational data are specially organized to provide enterprise-wide, cleansed data in a
standardized format
What does a data warehouse do? (3 Key Terms) - --Answer --"The data
warehouse is a collection of integrated, subject-oriented databases designed to
support DSS functions, where each unit of data is non-volatile and relevant to
some moment in time"
What is relational data? - --Answer --Used in data warehouses. For example,
in UKH terms, a FSC has rates and J-codes. A CMP list links J-codes to rev codes
or DRGs. Therefore, two totally different systems/processes/servers (CMP v
FSC) can read each other and collaborate.
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, What is a data mart? - --Answer --A departmental small-scale "Data
warehouse" that stores only limited/relevant data
Dependent Data Mart - --Answer --A subset that is created directly from a
data warehouse
Independent Data Mart - --Answer --A small data warehouse designed for a
strategic business unit or a department.
Operational Data Stores (ODS) - --Answer --A database often used as an
interim area for a data warehouse.
Oper Marts - --Answer --An OPERational data MART
Enterprise Data Warehouse (EDW) - --Answer --A data warehouse for the
entire enterprise
Meta Data - --Answer --Data about data. It describes the contents of a data
warehouse and the manner of its acquisition and use.
Data Warehouse Framework (30,000FT) - --Answer --Data Sources -> ETL
Process (IMPORTANT, Acct No vs Customer No, etc) -> [ACCESS START]
Enterprise Data Warehouse (Meta is used to find data inside of the warehouse) ->
Data marts (if applicable, per individual department [ACCESS END] ->
Applications and visualization
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
2025 Questions and Answers
What's the most important thing about a Data Warehouse? - --Answer --It
becomes a single version of truth for a company.
What is a 'data warehouse'? - --Answer --A physical repository where
relational data are specially organized to provide enterprise-wide, cleansed data in a
standardized format
What does a data warehouse do? (3 Key Terms) - --Answer --"The data
warehouse is a collection of integrated, subject-oriented databases designed to
support DSS functions, where each unit of data is non-volatile and relevant to
some moment in time"
What is relational data? - --Answer --Used in data warehouses. For example,
in UKH terms, a FSC has rates and J-codes. A CMP list links J-codes to rev codes
or DRGs. Therefore, two totally different systems/processes/servers (CMP v
FSC) can read each other and collaborate.
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, What is a data mart? - --Answer --A departmental small-scale "Data
warehouse" that stores only limited/relevant data
Dependent Data Mart - --Answer --A subset that is created directly from a
data warehouse
Independent Data Mart - --Answer --A small data warehouse designed for a
strategic business unit or a department.
Operational Data Stores (ODS) - --Answer --A database often used as an
interim area for a data warehouse.
Oper Marts - --Answer --An OPERational data MART
Enterprise Data Warehouse (EDW) - --Answer --A data warehouse for the
entire enterprise
Meta Data - --Answer --Data about data. It describes the contents of a data
warehouse and the manner of its acquisition and use.
Data Warehouse Framework (30,000FT) - --Answer --Data Sources -> ETL
Process (IMPORTANT, Acct No vs Customer No, etc) -> [ACCESS START]
Enterprise Data Warehouse (Meta is used to find data inside of the warehouse) ->
Data marts (if applicable, per individual department [ACCESS END] ->
Applications and visualization
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
