Exam 13: Business Intelligence and Data Warehouses

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

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

_____ functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

Operational data are commonly stored in many tables, and the stored data represents information about a given _____ only.

By default, the fact table's primary key is always formed by combining the superkeys pointing to the dimension tables to which they are related.

_____ are quantifiable measurements (numeric or scale based) that assess a company's effectiveness or success in reaching its strategic and operational goals.

In star schema representation, a fact table is related to each dimension table in a _____ relationship.

______ is a method or process of government.

The _____ hierarchy providesa top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

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

_____ tools focus on the strategic and tactical use of information.

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

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

The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.

_____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in _____ n-dimensional arrays.

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.

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

What is the difference between decision support data and operational data from the point of view of data analyst?

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