MGT 430 Chapter 7: Accessing Organizational Information - Data Warehouses Exam Questions and Answers

MGT 430 Chapter 7: Accessing Organizational Information - Data Warehouses Exam Questions and Answers Choose three reasons why operational systems are not appropriate for business analysis. Operational systems are not integrated Operational information is typically outdated Information from other operational applications is not included Operational information never has quality issues Operational information is mainly current - Ans:-Operational systems are not integrated Information from other operational applications is not included Operational information is mainly current A(n) __________ is a central location in which data is stored. ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 2/13 repository data set data point - Ans:-repository What is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks? Data dictionary Database Data-driven website Data warehouse - Ans:-Data warehouse What is the collection of data from various sources for the purpose of data processing? data cleansing dirty data data repository data aggregation - Ans:-data aggregation ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 3/13 What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse? Business critical integrity constraints Relational database transformation Extraction, transformation, and loading - Ans:-Extraction, transformation, and loading What is a central location in which data is stored? dirty data data warehouse repository data aggregation - Ans:-repository What contains a subset of data warehouse information? Data warehouse Data mining tools Data website Data mart - Ans:-Data mart ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 4/13 A data ________ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. website dictionary warehouse - Ans:-warehouse ______ data is erroneous or flawed data. Scrubbed Dirty Clean - Ans:-Dirty Data _______ is the collection of data from various sources for the purpose of data processing. aggregation extraction and load transformation and load - Ans:-aggregation What is a process that weeds out and fixes or discards i