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, Inc4 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