ISM 3540 Exam 1

Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software

False

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

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

False

Data is the contextualization of information, that is, information set in context

False

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

False

Moving the data into a data warehouse is usually the easiest part of its creation

False

Subject oriented databases for data warehousing are organized by detailed subjects such as disk drives, computers, and networks

False

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

False

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

False

User-initiated navigation of data through disaggregation is referred to as "drill up"

False

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

False

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

False

In what decade did disjointed information systems begin to be integrated

1980s

Relational databases began to be used in the

1980s

Today, many vendors offer diversified tools, some of which are completely preprogrammed (called shells). How are these shells utilized?

All a user needs to do is insert the numbers

Data accessibility means that the data are easily and readily obtainable

True

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

True

Descriptive statistics is all about describing the sample data on hand

True

Interval data are variables that can be measured on interval scales

True

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

One way an operational data store differs from a data warehouse is the recency of their data

True

Online transaction processing (OLTP) systems handle a company's routing ongoing business. In contrast, a data warehouse is typically

a distinct system that provides storage for data that will be made use of in analysis

What is Six Sigma

a methodology aimed at reducing the number of defects in a business process

When you tell a story in a presentation, all of the following are true EXCEPT

a well-told story should have no need for subsequent discussion

This measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set

arithmetic mean

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

balanced scorecard-type reports

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

because measurement alone has little use without action

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

bubble chart

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

cleanse

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

drill down

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

geographic map

Which of the following is LEAST related to data/information visualization?

graphic artwork

In the Opening Vignette on Sports Analytics, what type of modeling was used to predict offensive tactics

heat maps

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

improved customer service

Key performance indicators (KPI's) are metrics typically used to measure

internal results

All of the following are true about in-database processing technology EXCEPT

it is the same as in-memory storage technology

The internet emerged as a new medium for visualization and brought all the following EXCEPT

new forms of computation of business logic

OLAP systems and Data Warehouses are optimized for

outputs like end-user ad hoc reports, queries, and analysis

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?

pie chart

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

prescriptive

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?

star schema

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

False

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

Hardware resources are dynamically allocated as use increases

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

True

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization

True

The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage

True

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

True

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

True

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

speed of data transfer

This measure of dispersion is calculated by simply taking the square root of the variations

standard deviation