Ch. 3 ISYS

(T/F) Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.

False

(T/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

(T/F) Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

False

(T/F) Data warehouses are subsets of data marts.

False

(T/F) Fundamental reasons for investingterized support is only used for organizational decisions that are responses to external pressures, not for taking advantage of opportunities.

False

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

False

(T/F) Properly integrating data from various databases and other disparate sources is a trivial process.

False

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

False

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

False

(T/F) Two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones.

False

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

False

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

False

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

False

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

Graphic Work

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

Hardware resources are dynamically allocated as use increases

(T/F) Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them.

True

(T/F) Data accessibility means that the data are easily and readily obtainable.

True

(T/F) Descriptive statistics is all about describing the sample data on hand.

True

(T/F) The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

True

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

True

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

True

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

True

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

True

Without middleware, different BI programs cannot easily connect to the data warehouse.

True

What is Six Sigma?

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

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

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?

federated architecture

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

geographic map

All of the following are benefits of hosted data warehouses EXCEPT

greater control of data

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?

hub-and-spoke data warehouse architecture

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

improved customer service

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

it is the same as in-memory storage technology.

Oper marts are created when operational data needs to be analyzed

multidimensionally.

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?

parallel processing

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

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

balanced scorecard-type reports.

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

bubble chart

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

Data Warehouse

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

Drill Down

________ is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

Enterprise information integration (EII)

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

cleanse

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

enterprise application integration