Exam 15: Databases for Decision Support

The BI architecture is composed of data, people, processes, technology, and the management of such components.

A characteristic of operational data is ____.

____ provide a unified, single point of entry for information distribution.

____ are in charge of presenting the data to the end user in a variety of ways.

Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.

The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

SAP is a portal vendor.

A(n) ____________________ uses special proprietary techniques to store data in matrix-like n-dimensional arrays.

____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.

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

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

A(n) ______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business.

Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.

From the data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.

______________________________ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.

The decision support database query optimizer must be enhanced to support non-normalized structures.

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

Creating a data warehouse is a simple exercise that takes little time, money, or effort.

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