©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
MIS430 FINAL EXAM Study Guide
Solutions
Operational Information - Ans:✔✔-the information collected and used in support of day to day
operational needs in businesses and other organizations
Analytical Information - Ans:✔✔-Encompasses all organizational information (transactional), and its
primary purpose is to support the performing of managerial analysis tasks
Analytical Information Use - Ans:✔✔-Business intelligence processing
Operational Information Use - Ans:✔✔-1. Original operational purpose
2. As a source system for the DWH
Two main reasons for the creation of DWH as separate analytical DB - Ans:✔✔-1. The performance of
operational data use can be diminished when having to compete with analytical queries
2. Often impossible to structure DB for efficient operational and analytical use
Operational Data Makeup Difference - Ans:✔✔-Typical Time-Horizon: Days/Months
Page 1/25
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
Detailed
Current
Analytical Data Makeup Difference - Ans:✔✔-Typical Time-Horizon: Years
Summarized (and/or Detailed)
Values over time (Snapshots)
Operational Data Technical Difference - Ans:✔✔-- Small amounts used in a process
- High frequency of access
- Can be updated
- Non-redundant (non-repeating)
Analytical Data Technical Difference - Ans:✔✔-- Large amounts used in a process
- Low/Modest frequency of access
- Read (and Append) Only
- Redundancy not an issue
Operational Data Functional Difference - Ans:✔✔-- Used by all types of employees for tactical purposes
Page 2/25
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
- Application oriented
Analytical Data Functional Difference - Ans:✔✔-- Used by narrower set of users for decision-making
- Subject oriented
The Data Warehouse Definition - Ans:✔✔-A structured repository of integrated, subject-oriented,
enterprise-wide, historical, time-variant and nonvolatile data
Structured repository (DWH Definition) - Ans:✔✔-- Contains analytically useful information
- Any DB is a structured repository with its structure represented in its metadata
Integrated (DWH Definition) - Ans:✔✔-- Integrates analytically useful data from various operational DBs
(and possibly other ext. sources)
- Refers to the process of bringing data from multiple sources into a singular DWH
Subject-oriented (DWH Definition) - Ans:✔✔-Refers to the fundamental difference in the purpose of an
operational DB system and a DWH
- DWH developed to analyze specific business subject areas
Enterprise-wide (DWH Definition) - Ans:✔✔-Refers to organization-wide view of the analytically useful
information
Page 3/25
FIRST PUBLISH OCTOBER 2024
MIS430 FINAL EXAM Study Guide
Solutions
Operational Information - Ans:✔✔-the information collected and used in support of day to day
operational needs in businesses and other organizations
Analytical Information - Ans:✔✔-Encompasses all organizational information (transactional), and its
primary purpose is to support the performing of managerial analysis tasks
Analytical Information Use - Ans:✔✔-Business intelligence processing
Operational Information Use - Ans:✔✔-1. Original operational purpose
2. As a source system for the DWH
Two main reasons for the creation of DWH as separate analytical DB - Ans:✔✔-1. The performance of
operational data use can be diminished when having to compete with analytical queries
2. Often impossible to structure DB for efficient operational and analytical use
Operational Data Makeup Difference - Ans:✔✔-Typical Time-Horizon: Days/Months
Page 1/25
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
Detailed
Current
Analytical Data Makeup Difference - Ans:✔✔-Typical Time-Horizon: Years
Summarized (and/or Detailed)
Values over time (Snapshots)
Operational Data Technical Difference - Ans:✔✔-- Small amounts used in a process
- High frequency of access
- Can be updated
- Non-redundant (non-repeating)
Analytical Data Technical Difference - Ans:✔✔-- Large amounts used in a process
- Low/Modest frequency of access
- Read (and Append) Only
- Redundancy not an issue
Operational Data Functional Difference - Ans:✔✔-- Used by all types of employees for tactical purposes
Page 2/25
, ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED
FIRST PUBLISH OCTOBER 2024
- Application oriented
Analytical Data Functional Difference - Ans:✔✔-- Used by narrower set of users for decision-making
- Subject oriented
The Data Warehouse Definition - Ans:✔✔-A structured repository of integrated, subject-oriented,
enterprise-wide, historical, time-variant and nonvolatile data
Structured repository (DWH Definition) - Ans:✔✔-- Contains analytically useful information
- Any DB is a structured repository with its structure represented in its metadata
Integrated (DWH Definition) - Ans:✔✔-- Integrates analytically useful data from various operational DBs
(and possibly other ext. sources)
- Refers to the process of bringing data from multiple sources into a singular DWH
Subject-oriented (DWH Definition) - Ans:✔✔-Refers to the fundamental difference in the purpose of an
operational DB system and a DWH
- DWH developed to analyze specific business subject areas
Enterprise-wide (DWH Definition) - Ans:✔✔-Refers to organization-wide view of the analytically useful
information
Page 3/25
