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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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).

_____ 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.

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

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

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

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

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

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

Fact and dimension tables are related by _____ keys.

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

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

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

_____ 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.

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

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

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