Exam 13: Business Intelligence and Data Warehouses

_____ makes a copy of a table and places it in a different location to improve access time.

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

Decision support data tends to be non-normalized, _____, and pre-aggregated.

A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.

The data warehouse development life cycle differs from classical systems development.

In a star schema, attributes are often used to search, filter, or classify _____.

Decision support datais a snapshot of the operational data at a given point in time.

Operational data and decision support data serve the same purpose.

_____ are qualifying characteristics that provide additional perspectives to a given fact.

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

A data store is used by data analysts to create queries that access the database.

The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

The _____ schema must support complex (non-normalized) data representations.