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
