Exam 15: Databases for Decision Support

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

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

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

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

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

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

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

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

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

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

Describe the use of SQL in relation to ROLAP.

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

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

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

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

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

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

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

____________________ is a method or process of government.

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