Exam 13: Business Intelligence and Data Warehouses

____________________ are numeric measurements (values)that represent a specific business aspect or activity.

The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search,group information,or describe attributes.

In a star schema,dimensions are normally stored in ____.

____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.

What is a data cube?

Data is captured from the OLTP system and placed on the ____ on a near-real time basis.

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

BI is a framework that allows a business to transform data into information,information into knowledge,and knowledge into wisdom.

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

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

Creating a data warehouse is a simple exercise that takes little time,money,or effort.

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.

Normalizing fact tables improves data access performance and saves data storage space.

____________________ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

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

A ____ index is based on 0 and 1 bits to represent a given condition.

Operational data and decision support data serve the same purpose.

To support a(n)____________________ adequately,the DBMS might be required to use advanced hardware,such as multiple disk arrays,and even more importantly,to support multiple-processor technologies,such as a symmetric multiprocessor (SMP)or a massively parallel processor (MPP).

The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

In a typical star schema,each dimension record is related to thousands of ____ records.