MIS 430 Quiz 2 with Correct Answers

MIS 430 Quiz 2 with Correct Answers A typical organization - Ans:-maintains and utilizes a number of operational data sources. The operational data sources include - Ans:-the databases and other data repositories which are used to support the organization's day-to-day operations A data warehouse is created - Ans:-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 - Ans:-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 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) - - Ans:-the information collected and used in support of day to day operational needs in businesses and other organizations ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 2/11 Analytical information - - Ans:-the information collected and used in support of analytical tasks Analytical information is based on operational (transactional) information Operational Data - Ans:-Data Makeup Differences --Typical Time-Horizon: Days/Months --Detailed --Current Technical Differences --Small Amounts used in a Process --High frequency of Access --Can be Updated --Non-Redundant ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 3/11 Functional Differences --Used by all types of employees for tactical purposes --Application Oriented Analytical Data - Ans:-Data Makeup Differences --Typical Time-Horizon: Years --Summarized (and/or Detailed) --Values over time (Snapshots) Technical Differences --Large Amounts used in a Process --Low/Modest frequency of Access --Read (and Append) Only --Redundancy not an Issu