is a mechanism that integrates application functionality and shares functionality (rather than data)across systems, thereby enabling flexibility and reuse Answer: Enterprise application integration (EAl) Diff:3 Page Ref: 147 50) is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources. such as relational databases Web services and multidimensional databases Answer: Enterprise information integration(Ell Diff:3 Page Ref: 148 51) Performing extensive to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy Answer: extraction, transformation, and load (etl) Diff: 3 Page Ref: 149 52)The Model, also known as the EDw approach, emphasizes top-down development, employing established database development methodologies and tools, such entity-relationship diagrams(ERD), and an adjustment of the spiral development approach Answer: Inmon Diff: 2 Page Ref: 153-154 53)The Model, also known as the data mart approach, is a"plan big, build small down version of a data warehouse that focuses on the requests of a specific department, sucha a? approach. a data mart is a subject-oriented or department-oriented data warehouse. It is a scal marketing or sales Answer: Kimball Diff: 2 modeling is a retrieval-based system that supports high-volume query access Answer: Dimensiona Diff: 2 Page Ref: 156 55)A(n) data mart is a subset that is created directly from the data warehouse Answer: dependent Diff: 1 Page Ref: 134 56)Online is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM and point of sale Answer: transaction processing Diff: 2 Page Ref: 158 57) Given that the size of data warehouses is expanding at an exponential rate Important issue Answer: scalability Diff: 2 Page Ref: 163 Copyright C 2018 Pearson Education, Inc8 Copyright © 2018 Pearson Education, Inc. 49) ________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse. Answer: Enterprise application integration (EAI) Diff: 3 Page Ref: 147 50) ________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases. Answer: Enterprise information integration (EII) Diff: 3 Page Ref: 148 51) Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy. Answer: extraction, transformation, and load (ETL) Diff: 3 Page Ref: 149 52) The ________ Model, also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach. Answer: Inmon Diff: 2 Page Ref: 153-154 53) The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled￾down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales. Answer: Kimball Diff: 2 Page Ref: 154 54) ________ modeling is a retrieval-based system that supports high-volume query access. Answer: Dimensional Diff: 2 Page Ref: 156 55) A(n) ________ data mart is a subset that is created directly from the data warehouse.. Answer: dependent Diff: 1 Page Ref: 134 56) Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale. Answer: transaction processing Diff: 2 Page Ref: 158 57) Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue. Answer: scalability Diff: 2 Page Ref: 163