MIS 523 - Ch. 3

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

Hardware resources are dynamically allocated as use increases.

Which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?

ROLAP

The "single version of the truth" embodied in a data warehouse such as Capri Casinos' means all of the following EXCEPT

decision makers have unfettered access to all data in the warehouse.

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

All of the following statements about metadata are true EXCEPT

for most organizations, data warehouse metadata are an unnecessary expense.

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 using organizations. Which of the following is an indirect benefit of data warehouses?

improved customer care

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates?

independent data mart

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

it is the same as in-memory storage technology

Which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?

large numbers of users, including operational staffs

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

parallel processing

Active 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

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

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are

subject-oriented and nonvolatile

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a

three tier architecture

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

transformation

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 approach to data warehouse integration focuses more on sharing process functionality than data across systems?

enterprise application integration