Chapter 13 (MC)

1.Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.

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

3.Data mining is part of the “____” section of the business intelligence framework.

4.A data mart is part of the “____” section of the business intelligence framework.

5.____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.

6.The ____ contains business data extracted from the operational database and from external data sources.

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

8.____provide a unified, single point of entry for information distribution.

9.Data is captured from the OLTP system and placed on the ____ on a near-real time basis.

10.BusinessObjects is a(n) ____ tool

11.Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.

12.____ systems provided no data extraction/integration process.

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

14.A characteristic of decision support data is ____.

15.A characteristic of operational data is ____.

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

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

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

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

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

21.Computed or derived facts are sometimes called ____to differentiate them from stored facts.

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

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

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

25.The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____and drilldown/roll up data analysis

26.Fact and dimension tables are related by ____ keys.

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

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

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

30.In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.

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

32.Decision support data tend to be non-normalized, ____, and pre-aggregated.

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

34.ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.

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

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

37.A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.

38.What is one of the main characteristics of OLAP systems?

39.What is a characteristic of ROLAP?

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