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 1

Short Answer

Review LaterAdd Note

Review Later

____________________ is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

Correct Answer

verified

Business intelligence BI

Question 2

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Data is captured from the OLTP system and placed on the ____ on a near-real time basis.

Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.

What is a data mart? Why do some organizations prefer to create a data mart rather than a data warehouse?

____________________ use Web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

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

Monitoring results to evaluate outcomes of the business decisions is outside the scope of BI.

In most implementations, the data warehouse and OLAP are stand-alone, independent environments.

In practice, _________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.

____________________ is a method or process of government.

The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

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

Describe the use of SQL in relation to ROLAP.

Computed or derived facts are sometimes called ____ to differentiate them from stored facts.

In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.

Analyzing decision support data to generate information is part of ____.

Decision support data tend to be non-normalized, ____, and pre-aggregated.

MDM's main goal is to provide a partial and segmented definition of all data within an organization.

Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data.