Exam 13: Business Intelligence and Data Warehouses

Facts can be computed or derived at run time.

A characteristic of decision support data is ____.

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

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

MOLAP is a logical choice for companies that already use relational databases for their operational data.

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

Data ____ implies that all business entities,data elements,data characteristics,and business metrics are described in the same way throughout the enterprise.

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

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

____________________ is a method or process of government.

A(n)____ is a dynamic table that not only contains the SQL query command to generate the rows,but also stores the actual rows.

Decision support data are a snapshot of the operational data at a given point in time.

The mainframe environment enables an OLAP system to be divided into several components that define its architecture.

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

The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.

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

Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data.

____________________ are qualifying characteristics that provide additional perspectives to a given fact.

In multidimensional terms,the ability to focus on slices of the cube to perform a more detailed analysis is known as ____________________.

Analyzing decision support data to generate information is part of ____.