Exam 13: Business Intelligence and Data Warehouses

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

Which of the following is a personal analytics vendor for BI applications?

In star schema representation,a fact table is related to each dimension table in a relationship.

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

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

Conceptually,MDBMS end users visualize the stored data as a three-dimensional cube known as a .

Tools focus on the strategic and tactical use of information.

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

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

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

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n).

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

Advanced OLAP feature become more useful when access to them is kept simple.

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

Fact and dimension tables are related by keys.

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

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

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

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

A is optimized for decision support and is generally represented by a data warehouse or a data mart.