Sharda chapter 3

________, or "The Extended ASP Model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet).

SaaS (software as a service)

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems? A) extraction, transformation, and load B) enterprise application integration C) enterprise information integration D) enterprise function integration

B) enterprise application integration

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) country of (data) origin. B) nature of the data. C) speed of data transfer. D) source of the data.

C) speed of data transfer

What is the definition of a data mart?

A data mart is a subset of a data warehouse, typically consisting of a single subject area (e.g., marketing, operations). Whereas a data warehouse combines databases across an entire enterprise, a data mart is usually smaller and focuses on a particular subject or department.

How does the use of cloud computing affect the scalability of a data warehouse? A) Cloud computing vendors bring as much hardware as needed to users' offices. B) Hardware resources are dynamically allocated as use increases. C) Cloud vendors are mostly based overseas where the cost of labor is low. D) Cloud computing has little effect on a data warehouse's scalability

B) Hardware resources are dynamically allocated as use increases

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

FALSE

Data warehouses are subsets of data marts.

FALSE

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

TRUE

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

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

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? A) sectional data mart B) public data mart C) independent data mart D) volatile data mart

C) independent data mart

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is A) dice. B) slice. C) roll-up. D) drill down.

d) drill down

Performing extensive ________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.

extraction, information, and load (ETL)

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

relational

All of the following are benefits of hosted data warehouses EXCEPT A) smaller upfront investment. B) better quality hardware. C) greater control of data. D) frees up in-house systems.

C) greater control of data

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture

C) hub-and-spoke data warehouse architecture

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? A) use of the Web by users as a front-end B) parallel processing C) Microsoft Windows D) a larger IT staff

B) parallel processing

________ 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. A) Enterprise information integration (EII) B) Enterprise application integration (EAI) C) Extraction, transformation, and load (ETL) D) None of these

A) Enterprise information integration (EII)

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) snowflake schema C) relational schema D) dimensional schema

A) star schema

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are A) subject-oriented and nonvolatile. B) product-oriented and nonvolatile. C) product-oriented and volatile. D) subject-oriented and volatile

A) subject-oriented and nonvolatile.

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) extended ASP. B) data cloud. C) data lake. D) relational database.

C) data lake

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a A) one-tier architecture. B) two-tier architecture. C) three-tier architecture. D) four-tier architecture.

C) three-tier architecture.

Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses? A) better and more timely information B) extensive new analyses performed by users C) simplified access to data D) improved customer service

D) Improved customer service

Why is a performance management system superior to a performance measurement system? A) because performance measurement systems are only in their infancy B) because measurement automatically leads to problem solution C) because performance management systems cost more D) because measurement alone has little use without action

D) 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? A) transformation B) extraction C) load D) cleanse

D) cleanse

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses? A) independent data marts architecture B) centralized data warehouse architecture C) hub-and-spoke data warehouse architecture D) federated architecture

D) federated architecture

All of the following are true about in-database processing technology EXCEPT A) it pushes the algorithms to where the data is. B) it makes the response to queries much faster than conventional databases. C) it is often used for apps like credit card fraud detection and investment risk management. D) it is the same as in-memory storage technology.

D) it is the same as in-memory storage technology.

Oper marts are created when operational data needs to be analyzed A) linearly. B) in a dashboard. C) unidimensionally. D) multidimensionally

D) multidimensionally

Briefly describe the major components of the data warehousing process.

Data sources. Data are sourced from multiple independent operational "legacy" systems and possibly from external data providers (such as the U.S. Census). Data may also come from an OLTP or ERP system. • Data extraction and transformation. Data are extracted and properly transformed using custom-written or commercial ETL software. • Data loading. Data are loaded into a staging area, where they are transformed and cleansed. The data are then ready to load into the data warehouse and/or data marts. • Comprehensive database. Essentially, this is the EDW to support all decision analysis by providing relevant summarized and detailed information originating from many different sources. • Metadata. Metadata include software programs about data and rules for organizing data summaries that are easy to index and search, especially with Web tools. • Middleware tools. Middleware tools enable access to the data warehouse. There are many front-end applications that business users can use to interact with data stored in the data repositories, including data mining, OLAP, reporting tools, and data visualization tools.

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

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

FALSE

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

FALSE

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

FALSE

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

FALSE

Properly integrating data from various databases and other disparate sources is a trivial process.

FALSE

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

FALSE

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

FALSE

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

FALSE

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

FALSE

What is the definition of a data warehouse (DW) in simple terms?

In simple terms, a data warehouse (DW) is a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organization.

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

Metadata

More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?

Real-time data warehousing, also known as active data warehousing (ADW), is the process of loading and providing data via the data warehouse as they become available

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

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

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

TRUE

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

TRUE

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

TRUE

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

data stores

A(n) ________ data store (ODS) provides a fairly recent form of customer information file.

operational

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

scalability

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