Chapter 13 review

Normalizing fact tables improves data access performance and saves data storage space.

False

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

Data visualization tools

Which type of data describes numeric facts or measures that can be can be counted, ordered, and aggregated?

quantitative

Queries against operational data typically are broad in scope and high in complexity.

False

Which of the following is a personal analytics vendor for BI applications?

MicroStrategy

A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.

False

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

True

The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.

False

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

materialized view

From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.

Dimensionality

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

business intelligence

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

portals

Decision support data tends to be non-normalized, _____, and pre-aggregated.

duplicated

Business intelligence (BI) architecture is composed of data, people, processes, and technology working together to facilitate and enhance a business's management and governance.

True

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

transaction

Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in a table.

True

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

facts

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

False

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a _____.

Data cube

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

integration

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

aggregation

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

partitioning

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

True

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

matrix-like

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

bitmapped

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

dimensions

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

data warehouse

The CUBE extension enables you to get a subtotal for each column listed in the expression, in addition to a grand total for the last column listed.

True

Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.

metrics

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

False

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.

False

Operational data and decision support data serve the same purpose.

False

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

Fact

Data visualization has its roots in the _____ sciences, which focus on how the human brain receives, interprets, organizes, and processes information.

cognitive

Multidimensional data analysis techniques include advanced computational functions.

True

Advanced OLAP feature become more useful when access to them is kept simple.

True

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

False

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

data warehouse

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

True

A _____ is optimized for decision support and is generally represented by a data warehouse or a data mart.

data store

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

many-to-one (M:1)

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

Normalization

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

True

The _____ schema must support complex (non-normalized) data representations.

decision support database

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

True

Relational data warehouses use the star schema design technique to handle multidimensional data.

True

Fact and dimension tables are related by _____ keys.

foreign

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

ROLAP

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

Data marts

A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.

snowflake