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 41

Multiple Choice

Review LaterAdd Note

Review Later

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

A) Normalization
B) Meta modeling
C) Replication
D) Partitioning

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

Operational data and decision support data serve the same purpose.

Decision support data tends to be non-normalized, _____, and pre-aggregated.

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

A data store is used by data analysts to create queries that access the database.

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

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

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

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

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

The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.