liu

59) The filing system developed by Google to handle Big Data storage challenges is known as the ________ Distributed File System.

Hadoop

1) One of SiriusXM's challenges was tracking potential customers when cars were sold.

TRUE

62) What are the four major components of a Business Intelligence (BI) system?

1. A data warehouse, with its source data 2. Business analytics, a collection of tools for manipulating, mining, and analyzing the data in the data warehouse 3. Business performance management (BPM) for monitoring and analyzing performance 4. A user interface (e.g., a dashboard)

30) Which type of question does visual analytics seeks to answer? A) Why is it happening? B) What happened yesterday? C) What is happening today? D) When did it happen?

A

24) 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? A) data source reliability B) data accessibility C) data richness D) data granularity

D

32) The very design that makes an OLTP system efficient for transaction processing makes it inefficient for A) end-user ad hoc reports, queries, and analysis. B) transaction processing systems that constantly update operational databases. C) the collection of reputable sources of intelligence. D) transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly.

A

33) What is the management feature of a dashboard? A) operational data that identify what actions to take to resolve a problem B) summarized dimensional data to analyze the root cause of problems C) summarized dimensional data to monitor key performance metrics D) graphical, abstracted data to monitor key performance metrics

A

24) Which of the following developments is NOT contributing to facilitating growth of decision support and analytics? A) collaboration technologies B) Big Data C) knowledge management systems D) locally concentrated workforces

D

25) Which of the following is LEAST related to data/information visualization? A) information graphics B) scientific visualization C) statistical graphics D) graphic artwork

D

63) Why is data alone worthless?

Alone, data is worthless because it does not provide business value. To provide business value, it has to be analyzed.

27) Which kind of chart is described as an enhanced version of a scatter plot? A) heat map B) bullet C) pie chart D) bubble chart

D

28) Which of the following is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies? A) MIS B) DSS C) ERP D) BI

D

34) BI applications must be integrated with A) databases. B) legacy systems. C) enterprise systems. D) all of these

D

34) What is the fundamental challenge of dashboard design? A) ensuring that users across the organization have access to it B) ensuring that the organization has the appropriate hardware onsite to support it C) ensuring that the organization has access to the latest Web browsers D) ensuring that the required information is shown clearly on a single screen

D

22) In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics? A) heuristics B) heat maps C) cascaded decision trees D) sentiment analysis

B

23) Kaplan and Norton developed a report that presents an integrated view of success in the organization called A) metric management reports. B) balanced scorecard-type reports. C) dashboard-type reports. D) visual reports.

B

25) In what decade did disjointed information systems begin to be integrated? A) 1970s B) 1980s C) 1990s D) 2000s

B

29) The competitive imperatives for BI include all of the following EXCEPT A) right information B) right user C) right time D) right place

B

29) Which type of visualization tool can be very helpful when a data set contains location data? A) bar chart B) geographic map C) highlight table D) tree map

B

31) When you tell a story in a presentation, all of the following are true EXCEPT A) a story should make sense and order out of a lot of background noise. B) a well-told story should have no need for subsequent discussion. C) stories and their lessons should be easy to remember. D) the outcome and reasons for it should be clear at the end of your story.

B

33) How are enterprise resources planning (ERP) systems related to supply chain management (SCM) systems? A) different terms for the same system B) complementary systems C) mutually exclusive systems D) none of the above; these systems never interface

B

35) Contextual metadata for a dashboard includes all the following EXCEPT A) whether any high-value transactions that would skew the overall trends were rejected as a part of the loading process. B) which operating system is running the dashboard server software. C) whether the dashboard is presenting "fresh" or "stale" information. D) when the data warehouse was last refreshed.

B

36) Today, many vendors offer diversified tools, some of which are completely preprogrammed (called shells). How are these shells utilized? A) They are used for customization of BI solutions. B) All a user needs to do is insert the numbers. C) The shell provides a secure environment for the organization's BI data. D) They host an enterprise data warehouse that can assist in decision making.

B

37) What type of analytics seeks to recognize what is going on as well as the likely forecast and make decisions to achieve the best performance possible? A) descriptive B) prescriptive C) predictive D) domain

B

47) ________ cycle times are now extremely compressed, faster, and more informed across industries.

Business

44) ________ is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies.

Business intelligence (BI)

21) Which characteristic of data means that all the required data elements are included in the data set? A) data source reliability B) data accessibility C) data richness D) data granularity

C

23) Business applications have moved from transaction processing and monitoring to other activities. Which of the following is NOT one of those activities? A) problem analysis B) solution applications C) data monitoring D) mobile access

C

26) Relational databases began to be used in the A) 1960s. B) 1970s. C) 1980s. D) 1990s.

C

26) The Internet emerged as a new medium for visualization and brought all the following EXCEPT A) worldwide digital distribution of visualization. B) immersive environments for consuming data. C) new forms of computation of business logic. D) new graphics displays through PC displays.

C

27) The need for more versatile reporting than what was available in 1980s era ERP systems led to the development of what type of system? A) management information systems B) relational databases C) executive information systems D) data warehouses

C

28) Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration? A) heat map B) bullet C) pie chart D) bubble chart

C

30) Which of the following is NOT an example of transaction processing? A) ATM withdrawal B) bank deposit C) sales report D) cash register scans

C

31) Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically A) the end result of BI processes and operations. B) a repository of actionable intelligence obtained from a data mart. C) a distinct system that provides storage for data that will be made use of in analysis. D) an integral subsystem of an online analytical processing (OLAP) system.

C

32) Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT A) mobile platforms such as the iPhone are supported by these products. B) it is easier to spot useful patterns and trends in the data. C) they explore massive amounts of data in hours, not days. D) there is less demand on IT departments for reports.

C

35) What has caused the growth of the demand for instant, on-demand access to dispersed information? A) the increasing divide between users who focus on the strategic level and those who are more oriented to the tactical level B) the need to create a database infrastructure that is always online and contains all the information from the OLTP systems C) the more pressing need to close the gap between the operational data and strategic objectives D) the fact that BI cannot simply be a technical exercise for the information systems department

C

38) What type of analytics seeks to determine what is likely to happen in the future? A) descriptive B) prescriptive C) predictive D) domain

C

40) Big Data often involves a form of distributed storage and processing using Hadoop and MapReduce. One reason for this is A) centralized storage creates too many vulnerabilities. B) the "Big" in Big Data necessitates over 10,000 processing nodes. C) the processing power needed for the centralized model would overload a single computer. D) Big Data systems have to match the geographical spread of social media.

C

39) Which of the following statements about Big Data is true? A) Data chunks are stored in different locations on one computer. B) Hadoop is a type of processor used to process Big Data applications. C) MapReduce is a storage filing system. D) Pure Big Data systems do not involve fault tolerance.

D

21) In the Opening Vignette on Sports Analytics, what was adjusted to drive one-time ticket sales? A) player selections B) stadium location C) fan tweets D) ticket prices

D

22) Key performance indicators (KPIs) are metrics typically used to measure A) database responsiveness. B) qualitative feedback. C) external results. D) internal results.

D

49) ________ providers focus on providing technology and services aimed toward integrating data from multiple sources.

Data Warehouse

55) ________ analytics help managers understand current events in the organization including causes, trends, and patterns.

Descriptive

53) With ________, all the data from every corner of the enterprise is collected and integrated into a consistent schema so that every part of the organization has access to the single version of the truth when and where needed.

Enterprise Resource Planning (ERP)

1) Computerized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities.

FALSE

10) Major commercial business intelligence (BI) products and services were well established in the early 1970s.

FALSE

11) Information systems that support such transactions as ATM withdrawals, bank deposits, and cash register scans at the grocery store represent transaction processing, a critical branch of BI.

FALSE

11) When telling a story during a presentation, it is best to avoid describing hurdles that your character must overcome, to avoid souring the mood.

FALSE

12) Visual analytics is aimed at answering, "What is it happening?" and is usually associated with business analytics.

FALSE

13) Dashboards provide visual displays of important information that is consolidated and arranged across several screens to maintain data order.

FALSE

13) Successful BI is a tool for the information systems department, but is not exposed to the larger organization.

FALSE

14) BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives.

FALSE

14) In the Dallas Cowboys case study, the focus was on using data analytics to decide which players would play every week.

FALSE

15) Data source reliability means that data are correct and are a good match for the analytics problem.

FALSE

16) Demands for instant, on-demand access to dispersed information decrease as firms successfully integrate BI into their operations.

FALSE

17) The use of dashboards and data visualizations is seldom effective in identifying issues in organizations, as demonstrated by the Silvaris Corporation Case Study.

FALSE

19) Due to industry consolidation, the analytics ecosystem consists of only a handful of players across several functional areas.

FALSE

19) Nominal data represent the labels of multiple classes used to divide a variable into specific groups.

FALSE

2) To respond to its market challenges, SiriusXM decided to focus on manufacturing efficiency.

FALSE

20) Data generation is a precursor, and is not included in the analytics ecosystem.

FALSE

3) Data is the contextualization of information, that is, information set in context.

FALSE

4) Business intelligence (BI) is a specific term that describes architectures and tools only.

FALSE

5) The growth in hardware, software, and network capacities has had little impact on modern BI innovations.

FALSE

6) The data storage component of a business reporting system builds the various reports and hosts them for, or disseminates them to users. It also provides notification, annotation, collaboration, and other services.

FALSE

7) Managing information on operations, customers, internal procedures and employee interactions is the domain of cognitive science.

FALSE

8) Decision support system (DSS) and management information system (MIS) have precise definitions agreed to by practitioners.

FALSE

60) The programing algorithm developed by Google to handle Big Data computational challenges is known as ________.

MapReduce

50) ________ providers focus on bringing all the data stores into an enterprise-wide platform.

Middleware

56) ________ analytics help managers understand probable future outcomes.

Predictive

57) ________ analytics help managers make decisions to achieve the best performance in the future.

Prescriptive

10) Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures.

TRUE

12) Many business users in the 1980s referred to their mainframes as "the black hole," because all the information went into it, but little ever came back and ad hoc real-time querying was virtually impossible.

TRUE

15) Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses.

TRUE

16) Data accessibility means that the data are easily and readily obtainable.

TRUE

17) Structured data is what data mining algorithms use and can be classified as categorical or numeric.

TRUE

18) Interval data are variables that can be measured on interval scales.

TRUE

18) 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

2) During the early days of analytics, data was often obtained from the domain experts using manual processes to build mathematical or knowledge-based models.

TRUE

20) Descriptive statistics is all about describing the sample data on hand.

TRUE

3) Computer applications have moved from transaction processing and monitoring activities to problem analysis and solution applications.

TRUE

4) Data is the main ingredient for any BI, data science, and business analytics initiative.

TRUE

5) Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms.

TRUE

6) Managing data warehouses requires special methods, including parallel computing and/or Hadoop/Spark.

TRUE

7) In the FEMA case study, the BureauNet software was the primary reason behind the increased speed and relevance of the reports FEMA employees received.

TRUE

8) Google Maps has set new standards for data visualization with its intuitive Web mapping software.

TRUE

9) In the 2000s, the DW-driven DSSs began to be called BI systems.

TRUE

9) There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type.

TRUE

64) What is the intent of the analysis of data that is stored in a data warehouse?

The intent of the analysis is to give management the ability to analyze data for insights into the business, and thus provide tactical or operational decision support whereby, for example, line personnel can make quicker and/or more informed decisions.

58) The Google search engine is an example of Big Data in that it has to search and index billions of ________ in fractions of a second for each search.

Web pages

52) Data warehouses are intended to work with informational data used for online ________ processing systems.

analytical

41) Fundamental reasons for investing in BI must be ________ with the company's business strategy.

aligned

43) Organizations using BI systems are typically seeking to ________ the gap between the operational data and strategic objectives has become more pressing.

close

51) The user interface of a BI system is often referred to as a(n) ________.

dashboard

45) A(n) ________ is a major component of a Business Intelligence (BI) system that holds source data.

data warehouse

48) Different types of players are identified and described in the analytics ________.

ecosystem

54) As the number of potential BI applications increases, the need to justify and prioritize them arises. This is not an easy task due to the large number of ________ benefits.

intangible

42) Software monitors referred to as ________ can be placed on a separate server in the network and use event- and process-based approaches to measure and monitor operational processes.

intelligent agents

46) A(n) ________ is a major component of a Business Intelligence (BI) system that is often browser based and often presents a portal or dashboard.

user interface

67) List and describe three levels or categories of analytics that are most often viewed as sequential and independent, but also occasionally seen as overlapping.

• Descriptive or reporting analytics refers to knowing what is happening in the organization and understanding some underlying trends and causes of such occurrences. • Predictive analytics aims to determine what is likely to happen in the future. This analysis is based on statistical techniques as well as other more recently developed techniques that fall under the general category of data mining. • Prescriptive analytics recognizes what is going on as well as the likely forecast and makes decisions to achieve the best performance possible.

65) Describe the three major subsets of the Analytics Focused Software Developers portion of the Analytics Ecosystem.

• Reporting/Descriptive Analytics — Includes tools is enabled by and available from the Middleware industry players and unique capabilities offered by focused providers. • Predictive Analytics — a rapidly growing area that includes a variety of statistical packages. • Prescriptive Analytics — Software providers in this category offer modeling tools and algorithms for optimization of operations usually called management science/operations research software.