Exam 13: Business Intelligence and Data Warehouses

can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

The CUBE extension enable you to get a grand total for each column listed in the expression

Relational data warehouses use multidimensional data schema support to handle multidimensional data.

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

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

Business intelligence is a framework that allows a business to transform data into information,information into knowledge,and knowledge into wisdom.

_____ makes a copy of a table and places it in a different location to improve access time.

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

A data warehouse designer must define common business dimensions that will be used by a data analyst to narrow a search,group information,or describe attributes.

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

The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.

Describe the use of SQL in relation to ROLAP.

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

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

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

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

Operational data and decision support data serve the same purpose.

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

Data warehouse data are organized and summarized by table,such as CUSTOMER and ADDRESS.

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