MIS 4330 CHAPTER 13 QUZ

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

Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.

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

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

Operational data and decision support data serve the same purpose.

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

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

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.

Multidimensional data analysis techniques include advanced computational functions.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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