Exam 13: Business Intelligence and Data Warehouses

____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

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

When you ____________________ data,you are aggregating the data to a higher level.

To tie a KPI to the strategic master plan of an organization,a KPI will be compared to a desired goal within a specific time frame.

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

A data mart is part of the "____" section of the business intelligence framework.

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

BI is a comprehensive endeavor because it encompasses all business processes within an organization.

In a star schema,attributes are often used to search,filter,or classify ____.

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

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

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

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

OLAP systems share four main characteristics.What are they?

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

What is a characteristic of MOLAP?

What is one of the main characteristics of OLAP systems?

SAP is a portal vendor.

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

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