Exam 13: Business Intelligence and Data Warehouses

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

From the data analyst's point of view,decision support data differ from operational data in three main areas: time span,granularity,and ____.

What is a characteristic of ROLAP?

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

The mainframe environment enables an OLAP system to be divided into several components that define its architecture.

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

BusinessObjects is a(n)____ tool.

Decision support data tend to be non-normalized,____,and pre-aggregated.

A characteristic of decision support data is ____.

Analyzing decision support data to generate information is part of ____.

Periodicity,usually expressed as current year only,previous years,or all years,provides information about the time span of the data stored in the table.

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

Because a data cube's dimensions are predefined,all cells are populated.

In a typical ____________________ schema,each dimension record is related to thousands of fact records.

OLAP systems are designed to use both operational and data ____________________ data.

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

Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

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

Fact and dimension tables are related by ____ keys.

Data mining is part of the "____" section of the business intelligence framework.