Exam 13: Business Intelligence and Data Warehouses

Data warehouses usually have one fact table.

In a typical star schema,each dimension record is related to thousands of ____ records.

____________________ is a method or process of government.

Operational data and decision support data serve the same purpose.

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

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

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

What is a data mart? Why do some organizations prefer to create a data mart rather than a data warehouse?

There are 12 rules that define a(n)____.

Facts can be computed or derived at run time.

To provide better performance,some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

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

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

In 2008,Wal-Mart,the world's largest company,had over four ____ of data in its data warehouses.

In a star schema,dimensions are normally stored in ____.

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

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Business ____________________ are the central units of operation in a business.

A ____ index is based on 0 and 1 bits to represent a given condition.

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