Business Intelligence, 4e(shardaDelen/Turban) Chapter 3 Descriptive Analytics I: Business Intelligence and Data Warehousing 1)The BPm development cycle is essentially a one-shot process where the requirement is to get it right the first time Answer: FALSE Diff: 2 Page Ref: 170 2)The"islands of data"problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization Ansy RUE Diff: 2 Page Ref: 132 3)Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks Answer: FALSE Diff: 2 Page Ref: 133 4) Data warehouses are subsets of data marts Answer: FALSE Diff: 1 Page Ref: 134 5)One way an operational data store differs from a data warehouse is the recency of their data Answer: TRUE Diff: 2 Page Ref: 135 6) Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses Answer: FALSE Diff: 2 Page Ref: 135 7)Without middleware, different bI programs cannot easily connect to the data warehouse Answer: TRUE Diff: 2 Page Ref: 139 8)Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones Answer: FALSE Diff: 2 Page Ref: 140 9) Moving the data into a data warehouse is usually the easiest part of its creation Answer: FALSE Diff: 2 Page Ref: 141 Copyright C 2018 Pearson Education, Inc
1 Copyright © 2018 Pearson Education, Inc. Business Intelligence, 4e (Sharda/Delen/Turban) Chapter 3 Descriptive Analytics II: Business Intelligence and Data Warehousing 1) The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time. Answer: FALSE Diff: 2 Page Ref: 170 2) The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. Answer: TRUE Diff: 2 Page Ref: 132 3) Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks. Answer: FALSE Diff: 2 Page Ref: 133 4) Data warehouses are subsets of data marts. Answer: FALSE Diff: 1 Page Ref: 134 5) One way an operational data store differs from a data warehouse is the recency of their data. Answer: TRUE Diff: 2 Page Ref: 135 6) Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. Answer: FALSE Diff: 2 Page Ref: 135 7) Without middleware, different BI programs cannot easily connect to the data warehouse. Answer: TRUE Diff: 2 Page Ref: 139 8) Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones. Answer: FALSE Diff: 2 Page Ref: 140 9) Moving the data into a data warehouse is usually the easiest part of its creation. Answer: FALSE Diff: 2 Page Ref: 141
0)The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts Answer: TRUE Diff:2 Page Ref: 142 11) Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them Answer: TRUE Diff:2 Page Ref: 144 12) Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture a data mart bus architecture with conformed dimensions Answer: FALSE Diff: 2 Page Ref: 144 13)Properly integrating data from various databases and other disparate sources is a trivial process. Answer: FALSE Diff: 3 Page Ref: 146 14)With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true Answer: TRUE Diff: 2 Page Ref: 176 15)With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy Answer: FALSE Diff: 2 Page Ref: 177 16)OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items Answer: FALSE Diff:2 Page Ref: 158 17) The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager dult, and sage Answer: TRUE Diff: 2 Page Ref: 160-161 18)User-initiated navigation of data through disaggregation is referred to as"drill up Answer: FALSE Diff: 3 Page Ref: 159 Copyright C 2018 Pearson Education, Inc
2 Copyright © 2018 Pearson Education, Inc. 10) The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. Answer: TRUE Diff: 2 Page Ref: 142 11) Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. Answer: TRUE Diff: 2 Page Ref: 144 12) Bill Inmon advocates the data mart bus architecture whereas Ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions. Answer: FALSE Diff: 2 Page Ref: 144 13) Properly integrating data from various databases and other disparate sources is a trivial process. Answer: FALSE Diff: 3 Page Ref: 146 14) With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true. Answer: TRUE Diff: 2 Page Ref: 176 15) With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy. Answer: FALSE Diff: 2 Page Ref: 177 16) OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. Answer: FALSE Diff: 2 Page Ref: 158 17) The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. Answer: TRUE Diff: 2 Page Ref: 160-161 18) User-initiated navigation of data through disaggregation is referred to as "drill up." Answer: FALSE Diff: 3 Page Ref: 159
19)Data warehouse administrators(dWas) do not need strong business insight since they only handle the technical aspect of the infrastructure Answer: FALSE Diff:2 Page Ref: 164 20)Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software Answer FAlsE Diff: 2 Page Ref: 165 21)Why is a performance management system superior to a performance measurement system? A)because performance measurement systems are only in their infancy B)because measurement automatically leads to problem solution C)because performance management systems cost more D)because measurement alone has little use without action Answer: D Diff: 3 Page Ref: 176-177 22)Operational or transaction databases are product oriented, handling transactions that update the database. In contrast data warehouses are A)subject-oriented and nonvolatile B)product-oriented and nonvolatile C) product-oriented and volatile D)subject-oriented and volatile Answer:A Diff: 3 Page Ref: 131 23 )Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? A)sectional data mart B)public data mart C)independent data mart D)volatile data mart Answer: C Diff:2 Page Ref: 134 24)Oper marts are created when operational data needs to be analyzed A)linearly B)in a dashboard C)unidimensional D)multidimensionally Answer: D Diff: 2 Page Ref: 135 Copyright C 2018 Pearson Education, Inc
3 Copyright © 2018 Pearson Education, Inc. 19) Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. Answer: FALSE Diff: 2 Page Ref: 164 20) Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. Answer: FALSE Diff: 2 Page Ref: 165 21) Why is a performance management system superior to a performance measurement system? A) because performance measurement systems are only in their infancy B) because measurement automatically leads to problem solution C) because performance management systems cost more D) because measurement alone has little use without action Answer: D Diff: 3 Page Ref: 176-177 22) Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are A) subject-oriented and nonvolatile. B) product-oriented and nonvolatile. C) product-oriented and volatile. D) subject-oriented and volatile. Answer: A Diff: 3 Page Ref: 131 23) Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? A) sectional data mart B) public data mart C) independent data mart D) volatile data mart Answer: C Diff: 2 Page Ref: 134 24) Oper marts are created when operational data needs to be analyzed A) linearly. B) in a dashboard. C) unidimensionally. D) multidimensionally. Answer: D Diff: 2 Page Ref: 135
25)A Web client that connects to a Web server, which is in turn connected to a bI application server is reflective of a A)one-tier architecture B)two-tier architecture C)three-tier architecture D)four-tier architecture Answe C Diff: 2 Page Ref: 139 26)Which of the following BESt enables a data warehouse to handle complex queries and up to handle many more requests? A)use of the Web by users as a front-end B)parallel processing C) Microsoft Windows D)a larger IT staff answer: B Diff: 3 Page Ref: 141 27)Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses? A)independent data marts architecture B)centralized data warehouse architecture C)hub-and-spoke data warehouse architecture D)federated architecture Answer: D Diff: 3 Page Ref: 142 28)Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts? A)independent data marts architecture B)centralized data warehouse architecture C)hub-and-spoke data warehouse architecture D)federated architecture Answer: C Diff: 3 Page Ref: 142 29)Which approach to data warehouse integration focuses more on sharing process functionality than data across systems? A)extraction, transformation, and load B)enterprise application integration C)enterprise information integratio D)enterprise function integration Answer: B Diff:3 Page Ref: 147 Copyright C 2018 Pearson Education, Inc
4 Copyright © 2018 Pearson Education, Inc. 25) A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a A) one-tier architecture. B) two-tier architecture. C) three-tier architecture. D) four-tier architecture. Answer: C Diff: 2 Page Ref: 139 26) Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? A) use of the Web by users as a front-end B) parallel processing C) Microsoft Windows D) a larger IT staff Answer: B Diff: 3 Page Ref: 141 27) Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture Answer: D Diff: 3 Page Ref: 142 28) Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture Answer: C Diff: 3 Page Ref: 142 29) Which approach to data warehouse integration focuses more on sharing process functionality than data across systems? A) extraction, transformation, and load B) enterprise application integration C) enterprise information integration D) enterprise function integration Answer: B Diff: 3 Page Ref: 147
is an evolving tool space that promises real-time data integration from a variety of sources. such as r elational databases. Web services and multidimensional databases A) Enterprise information integration(ElD) B) Enterprise application integration(EAI C)Extraction, transformation, and load (ETL) D)None of these Answe Diff: 3 Page Ref: 148 3 1)In which stage of extraction, transformation, and load(EtL) into a data warehouse are anomalies detected and corrected? A)transformation B)extraction D)cleanse Answer: D Diff: 3 Page Ref: 149 32)Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses? A)better and more timely information B)extensive new analyses performed by users C)simplified access to data D)improved customer service Answer: D Diff: 3 Page Ref: 150 33)All of the following are benefits of hosted data warehouses EXCEPT A)smaller upfront investment B) better quality hardware C)greater control of data D)frees up in-house systems Answer: C Diff: 2 Page Ref: 157 4)When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure? A)star schema B)snowflake schema C)relational schema D)dimensional schema Answer:A Diff: 3 Page Ref: 157 Copyright C 2018 Pearson Education, Inc
5 Copyright © 2018 Pearson Education, Inc. 30) ________ 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. A) Enterprise information integration (EII) B) Enterprise application integration (EAI) C) Extraction, transformation, and load (ETL) D) None of these Answer: A Diff: 3 Page Ref: 148 31) In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? A) transformation B) extraction C) load D) cleanse Answer: D Diff: 3 Page Ref: 149 32) Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses? A) better and more timely information B) extensive new analyses performed by users C) simplified access to data D) improved customer service Answer: D Diff: 3 Page Ref: 150 33) All of the following are benefits of hosted data warehouses EXCEPT A) smaller upfront investment. B) better quality hardware. C) greater control of data. D) frees up in-house systems. Answer: C Diff: 2 Page Ref: 157 34) When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure? A) star schema B) snowflake schema C) relational schema D) dimensional schema Answer: A Diff: 3 Page Ref: 157