Exam 13: Business Intelligence and Data Warehouses

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

The data warehouse development life cycle differs from classical systems development.

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

Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

OLAP systems share three main characteristics.What are they?

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

Once data enter the data warehouse,they are never removed.

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

ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.

A data ____________________ is a small,single-subject data warehouse subset that provides decision support to a small group of people.

The star schema is designed to optimize data query operations rather than data update operations.

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

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

A data store is used by the data analyst to create the queries that access the database.

____ systems provided no data extraction/integration process.

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

Because a data cube's dimensions are predefined,all cells are populated.

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

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

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