Exam 13: Business Intelligence and Data Warehouses

In multidimensional terms,the ability to focus on slices of the cube to perform a more detailed analysis is known as ____________________.

A(n)____ is a dynamic table that not only contains the SQL query command to generate the rows,but also stores the actual rows.

In most implementations,the data warehouse and OLAP are stand-alone,independent environments.

In a MOLAP system,the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.

A data ____________________ is a small,single-subject data warehouse subset that provides decision support to a small group of people.

In practice,_________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.

The star schema is designed to optimize data query operations rather than data update operations.

Had ____ been as pivotal to business operations a few years back,crises precipitated by the likes of Enron,WorldCom,and Arthur Andersen might have been avoided.

Queries against operational data typically are broad in scope and high in complexity.

The ____ contains business data extracted from the operational database and from external data sources.

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

___________________________________ are quantifiable measurements (numeric or scale based)that assess the company's effectiveness or success in reaching its strategic and operational goals.

A(n)______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business.

____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.

____________________ is a term used to describe a comprehensive,cohesive,and integrated set of tools and processes used to capture,collect,integrate,store,and analyze data with the purpose of generating and presenting information used to support business decision making.

Multidimensional data analysis techniques include advanced computational functions.

Once data enter the data warehouse,they are never removed.

The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.