MIS 400 Midterm Exam - Questions and Answers

MIS 400 Midterm Exam - Questions and Answers A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n) data lake. data cloud. extended ASP. relational database. How does the use of cloud computing affect the scalability of a data warehouse? Cloud vendors are mostly based overseas where the cost of labor is low. Cloud computing has little effect on a data warehouse's scalability. Cloud computing vendors bring as much hardware as needed to users' offices. Hardware resources are dynamically allocated as use increases. Business intelligence (BI) is a specific term that describes architectures and tools only. True False Managing data warehouses requires special methods, including parallel computing and/or Hadoop/Spark. True False The use of statistics in baseball by the Oakland Athletics, as described in the Moneyball case study, is an example of the effectiveness of prescriptive analytics. True False The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. True False What has caused the growth of the demand for instant, on-demand access to dispersed information? the need to create a database infrastructure that is always online and contains all the information from the OLTP systems the fact that BI cannot simply be a technical exercise for the information systems department the increasing divide between users who focus on the strategic level and those who are more oriented to the tactical level the more pressing need to close the gap between the operational data and strategic objectives What type of analytics seeks to determine what is likely to happen in the future? predictive domain descriptive prescriptive NPS is a management tool used to measure customer satisfaction and loyalty, NPS stands for Network Performance System Net Promoter Score Non-data promotion score Numeric predictive score The growth in hardware, software, and network capacities has had little impact on modern BI innovations. True False Computer applications have moved from transaction processing and monitoring activities to problem analysis and solution applications. True False Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data? data richness data granularity data accessibility data source reliability