Correct Answers | Already Graded A+
A typical organization - ✔✔maintains and utilizes a number of operational
data sources.
The operational data sources include - ✔✔the databases and other data
repositories which are used to support the organization's day-to-day
operations
A data warehouse is created - ✔✔within an organization as a separate data
store whose primary purpose is data analysis.
Two main reasons for the creation of a data warehouse as a separate
analytical database - ✔✔The performance of operational day-to-day tasks
involving data use can be severely diminished if such tasks have to
compete for computing resources with analytical queries
1
©NINJANERD 2025/2026. YEAR PUBLISHED 2025.
, It is often impossible to structure a database which can be used in an
efficient manner for both operational and analytical purposes
Operational information (transactional information) - - ✔✔the information
collected and used in support of day to day operational needs in
businesses and other organizations
Analytical information - - ✔✔the information collected and used
in support of analytical tasks
Analytical information is based on operational (transactional) information
Operational Data - ✔✔Data Makeup Differences
--Typical Time-Horizon: Days/Months
--Detailed
--Current
Technical Differences
--Small Amounts used in a Process
2
©NINJANERD 2025/2026. YEAR PUBLISHED 2025.