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 21

Multiple Choice

Review LaterAdd Note

Review Later

The basic star schema has four components: facts, , attributes, and attribute hierarchies.

A) keys
B) relationships
C) cubes
D) dimensions

E) A) and C)
F) A) and D)

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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

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

ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

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

functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

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

Business intelligence tools use the data warehouse data as the raw materials for data analytics to generate business knowledge.

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

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in ?n-dimensional arrays.

can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

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

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

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

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

A data _____ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

_____ provide a unified, single point of entry for information distribution.