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

Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.

A) schemas
B) attributes
C) metrics
D) dimensions

E) A) and B)
F) All of the above

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

To deliver efficient decision support, OLAP tools must have advanced data _____ features.

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

_____ are numeric measurements (values) that represent a specific business aspect or activity.

Relational data warehouses use the star schema design technique to handle multidimensional data.

Fact and dimension tables are related by _____ keys.

Data visualization has its roots in the _____ sciences, which focus on how the human brain receives, interprets, organizes, and processes information.

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

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

_____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

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

Multidimensional data analysis techniques include advanced computational functions.

To support a(n) _____ adequately, the DBMS might be required to support advanced storage technologies, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

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

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

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

A data _____ is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

_____ means to decompose data into more atomic components or data at lower levels of aggregation.

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

In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as _____.

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.