FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Databases for Decision Support

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) attribute
B) fact
C) key
D) star

E) None of the above
F) B) and C)

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

The ____ schema is designed to optimize data query operations rather than data update operations.

A data mart is part of the "____" section of the business intelligence framework.

Data warehouses usually have one fact table.

To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

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

The ____ contains business data extracted from the operational database and from external data sources.

The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.

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

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

A characteristic of decision support data is ____.

MOLAP is a logical choice for companies that already use relational databases for their operational data.

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

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

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

___________________________________ are quantifiable measurements (numeric or scale based) that assess the company's effectiveness or success in reaching its strategic and operational goals.

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

In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.