isds 415 ch 3, BD Chap2, Business Intelligence (CH3), Business Analytics Exam 1, CIS 4093 Chapter 3, isds 2001 ch. 2 test bank, Data Science Exam 1 (ALL WITH CORRECT ANSWERS- A+ Rated

Data warehouses are subsets of data marts. - Answer-false One way an operational data store differs from a data warehouse is the recency of their data. - Answer-true Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. - Answer-false Without middleware, different BI programs cannot easily connect to the data warehouse - Answer-true Moving the data into a data warehouse is usually the easiest part of its creation. - Answer-false With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true. - Answer-true OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. - Answer-false Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure - Answer-false 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 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 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 Oper marts are created when operational data needs to be analyzed A) linearly. B) in a dashboard. C) unidimensionally. D) multidimensionally. - Answer-d 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 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 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