ISM 3450 - Big Data - Exam 1

FSU

T or F: 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

T or F: Decision support systems (DSS) and management information system (MIS) have precise definitions agreed to by practitioners.

False

The competitive imperatives for BI include all of the following EXCEPT:

a. right type of data center

b. right information

c. right place

d. right time

a. right type of data center

T or F: Due to industry consolidation, the analytics ecosystem consists of only a handful of players across several functional areas.

False

T or F: 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

T or F: Many business users in the 1980s referred to their mainframes as "the black hole," because all the info went into it, but little ever came back & ad hoc real-time querying was virtually impossible.

True

BI applications must be integrated with:

a. Databases

b. Legacy systems

c. Enterprise systems

d. All of these

d. all of these

T or F: Managing data warehouses requires special methods, including parallel computing and/or Hadoop/Spark

true

In the Opening Vinette on Sports Analytics, what was adjusted to drive one-time ticket sales?

a. ticket prices

b. fan tweets

c. stadium location

d. player selections

a. ticket prices

Business applications have moved from transportation processing & monitoring to other activities. Which of the following is NOT one of those activities?

a. problem analysis

b. solution applications

c. mobile access

d. data monitoring

d. data monitoring

(Possible) Question on Exam: How often should data be updated?

It depends on how often the users need their data to make the best possible decisions.

What is the fundamental challenge of dashboard design?

Ensuring that the required information is shown clearly on a single screen.

Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT:

a. they explore massive amounts of data in hours, not days

b. mobile platforms such as the iPhone are supported by these products.

c. there is less demand on IT departments for reports.

d. it is easier to spot useful patterns and trends in the data.

a. they explore massive amounts of data in hours, not days.

Dashboards can be presented at all of the following levels

1. The visual dashboard level

2. The self-service cube level

3. The static report level

T or F: 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

What is the management feature of a dashboard?

Operational data that identify what actions to take to resolve a problem.

T or F: Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures.

true

Which type of visualization tool can be very helpful when a data set contains location data?

a. geographic map

b. highlight table

c. tree map

d. bar chart

a. geographic map

Which kind of chart is described as an enhanced version of a scatter plot?

a. bubble chart

b. pie chart

c. heat map

d. bullet

a. bubble chart

This plot is a graphical illustration of several descriptive statistics about a given data set.

a. kurtosis

b. bar graph

c. pie chart

d. box-and-whiskers plot

d. box-and-whiskers plot

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 Granularity

T or F: Structured data is what data mining algorithms use and can be classified as categorical or numeric.

true

T or F: 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

T or F: Data is the main ingredient for any BI, data science, and business analytics initiative.

true

Which characteristic of data means that all the required data elements are included in the data set?

data richness

T or F: Nominal data represent the labels of multiple classes used to divide a variable into specific groups.

false

T or F: Data source reliability means that data are correct and are a good match for the analytics problem.

false

Key performance indicators (KPIs) are metrics typically used to measure

a. external results

b. internal results

c. database responsiveness

d. qualitative feedback

b. internal results

Kaplan and Norton developed a report that presents an integrated view of success in the organization called

a. dashboard-type reports

b. balanced scorecard-type reports

c. visual reports

d. metric management reports

b. balanced scorecard-type reports

T or F: Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks.

false

T or F: Organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses.

false

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

a. subject-oriented and volatile

b. product-oriented and volatile

c. product-oriented and nonvolatile

d. subject-oriented and nonvolatile

d. subject-oriented and nonvolatile

All of the following are benefits of hosted data warehouses EXCEPT

a. better quality hardware

b. greater control of data

c. frees up in-house systems

d. smaller upfront investment

b. greater control of data

Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses?

a. extensive new analyses performed by users

b. better & more timely information

c. improved customer service

d. simplified access to data

c. improved customer service

Real-time data warehousing can be used to support the highest level of decision making sophistication and power. The major feature that enables this in relation to handling the data is

a. speed of data transfer

b. nature of the data

c. source of the data

d. country of (data) origin

a. speed of data transfer

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

a. independent data mart

b. sectional data mart

c. public data mart

d. volatile data mart

a. independent data mart

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?

a. cleanse

b. extraction

c. load

d. transformation

a. cleanse

T or F: Data warehouses are subsets of data marts

false

T or F: OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

false

What are the 3 "V's" of big data?

1. Volume

2. Velocity

3. Variety

T or F: User-initiated navigation of data through disaggregation is referred to as "drill up."

false

T or F: The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

false

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. relational schema

c. snowflake schema

d. dimensional schema

a. star schema

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is

a. roll-up

b. slice

c. drill down

d. dice

c. drill down

Why is a performance management system superior to a performance measurement system?

a. bc performance measurement systems are only in their infancy

b. bc measurement along has little use w/o action

c. bc performance management systems cost more

d. bc measurement automatically leads to problem solution

b. bc measurement along has little use w/o action

T or F: With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy.

false

T or F: With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true.

true

What is Six Sigma?

a. methodology aimed at reducing the # of defects in a business process

b. methodology aimed at reducing the amount of variability in a business process

c. methodology aimed at measuring the amount of variability in a business process

d. letter in the Greek alphabet that statisticians use to measure process variability.

a. methodology aimed at reducing the # of defects in a business process

T or F: 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.

false

How does the use of cloud computing affect the scalability of a data warehouse?

a. cloud vendors are mostly based overseas where the cost of labor is low

b. cloud computing has little effect on a data warehouse's scalability

c. hardware resources are dynamically allocated as use increases

d. cloud computing vendors bring as much hardware as needed to users' offices

c. hardware resources are dynamically allocated as use increases