Quantitative Methods Chapter 3

Why is a performance management system superior to a performance measurement system? a. because performance management systems cost more b. because measurement automatically leads to problem solution c. because measurement alone has little use without action d. because performance measurement systems are only in their infancy

because measurement alone has little use without action

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

cleanse

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) a. relational database. b. extended ASP. c. data cloud. d. data lake.

data lake.

The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.

data stores

All of the following are benefits of hosted data warehouses EXCEPT a. frees up in-house systems. b. smaller upfront investment. c. greater control of data. d. better quality hardware.

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. improved customer service b. simplified access to data c. extensive new analyses performed by users d. better and more timely information

improved customer service

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

independent data mart

Data ________ comprises data access, data federation, and change capture.

integration

Most data warehouses are built using ________ database management systems to control and manage the data.

relational

Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue.

scalability

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are a. product-oriented and nonvolatile. b. product-oriented and volatile. c. subject-oriented and nonvolatile. d. subject-oriented and volatile.

subject-oriented and nonvolatile.

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

transaction processing system

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. True or False?

False

Data warehouses are subsets of data marts. True or False?

False

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. True or False?

False

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

False

Properly integrating data from various databases and other disparate sources is a trivial process. True or False?

False

User-initiated navigation of data through disaggregation is referred to as "drill up." True or False?

False

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

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. Hardware resources are dynamically allocated as use increases. c. Cloud computing vendors bring as much hardware as needed to users' offices. d. Cloud computing has little effect on a data warehouse's scalability.

Hardware resources are dynamically allocated as use increases.

________ describe the structure and meaning of the data, contributing to their effective use.

Metadata

Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. True or False?

True

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

True

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. True or False?

True

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

True

Without middleware, different BI programs cannot easily connect to the data warehouse. True or False?

True

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

Drill-down.

What is Six Sigma? a. a letter in the Greek alphabet that statisticians use to measure process variability b. a methodology aimed at reducing the number of defects in a business process c. a methodology aimed at reducing the amount of variability in a business process d. a methodology aimed at measuring the amount of variability in a business process

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