FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Business Intelligence and Data Warehouses

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) data warehouse
B) multidimensional cube
C) OLAP tool
D) star schema

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) SQL view
B) materialized view
C) star schema
D) data cube

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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.

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

Fact and dimension tables are related by keys.

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

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

Tools focus on the strategic and tactical use of information.

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

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

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

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

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

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

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

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

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

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

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