CH 13 MC – Flashcards
40 test answers
Unlock all answers in this set
Unlock answers 40question
____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.
answer
MDM
Unlock the answer
question
The ____ contains business data extracted from the operational database and from external data sources.
answer
data store
Unlock the answer
question
____ are in charge of presenting the data to the end user in a variety of ways.
answer
Data visualization tools
Unlock the answer
question
____ provide a unified, single point of entry for information distribution.
answer
Portals
Unlock the answer
question
Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
answer
data warehouse
Unlock the answer
question
BusinessObjects is a(n) ____ tool.
answer
OLAP
Unlock the answer
question
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.
answer
governance
Unlock the answer
question
____ systems provided no data extraction/integration process.
answer
Traditional mainframe-based online transaction processing
Unlock the answer
question
From the data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.
answer
dimensionality
Unlock the answer
question
A characteristic of decision support data is ____.
answer
high query activity
Unlock the answer
question
A characteristic of operational data is ____.
answer
high normalization
Unlock the answer
question
In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.
answer
petabytes
Unlock the answer
question
Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
answer
integration
Unlock the answer
question
____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
answer
Data marts
Unlock the answer
question
There are 12 rules that define a(n) ____.
answer
data warehouse
Unlock the answer
question
The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
answer
dimensions
Unlock the answer
question
Computed or derived facts are sometimes called ____ to differentiate them from stored facts.
answer
metrics
Unlock the answer
question
In a star schema, dimensions are normally stored in ____.
answer
dimension tables
Unlock the answer
question
In a star schema, attributes are often used to search, filter, or classify ____.
answer
facts
Unlock the answer
question
The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.
answer
time
Unlock the answer
question
The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.
answer
aggregation
Unlock the answer
question
Fact and dimension tables are related by ____ keys.
answer
foreign
Unlock the answer
question
In a typical star schema, each dimension record is related to thousands of ____ records.
answer
fact
Unlock the answer
question
A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
answer
snowflake
Unlock the answer
question
____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
answer
Partitioning
Unlock the answer
question
In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
answer
GUI
Unlock the answer
question
The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
answer
normalization
Unlock the answer
question
Decision support data tend to be non-normalized, ____, and pre-aggregated.
answer
duplicated
Unlock the answer
question
The ____ schema is designed to optimize data query operations rather than data update operations.
answer
star
Unlock the answer
question
ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
answer
SQL
Unlock the answer
question
A ____ index is based on 0 and 1 bits to represent a given condition.
answer
bitmapped
Unlock the answer
question
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.
answer
data cube
Unlock the answer
question
A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
answer
matrix
Unlock the answer
question
What is one of the main characteristics of OLAP systems?
answer
They support client/server architecture
Unlock the answer
question
What is a characteristic of ROLAP?
answer
It uses the star schema
Unlock the answer
question
A(n) ____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
answer
materialized view
Unlock the answer
