CH 13 MC – Flashcards

Unlock all answers in this set

Unlock answers
question
Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
answer
metadata
question
Analyzing decision support data to generate information is part of ____.
answer
business intelligence
question
Data mining is part of the "____" section of the business intelligence framework.
answer
Processes
question
A data mart is part of the "____" section of the business intelligence framework.
answer
Governance
question
____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.
answer
MDM
question
The ____ contains business data extracted from the operational database and from external data sources.
answer
data store
question
____ are in charge of presenting the data to the end user in a variety of ways.
answer
Data visualization tools
question
____ provide a unified, single point of entry for information distribution.
answer
Portals
question
Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
answer
data warehouse
question
BusinessObjects is a(n) ____ tool.
answer
OLAP
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
question
____ systems provided no data extraction/integration process.
answer
Traditional mainframe-based online transaction processing
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
question
A characteristic of decision support data is ____.
answer
high query activity
question
A characteristic of operational data is ____.
answer
high normalization
question
In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.
answer
petabytes
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
question
____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
answer
Data marts
question
There are 12 rules that define a(n) ____.
answer
data warehouse
question
The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
answer
dimensions
question
Computed or derived facts are sometimes called ____ to differentiate them from stored facts.
answer
metrics
question
In a star schema, dimensions are normally stored in ____.
answer
dimension tables
question
In a star schema, attributes are often used to search, filter, or classify ____.
answer
facts
question
The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.
answer
time
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
question
Fact and dimension tables are related by ____ keys.
answer
foreign
question
In a typical star schema, each dimension record is related to thousands of ____ records.
answer
fact
question
A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
answer
snowflake
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
question
In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
answer
GUI
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
question
Decision support data tend to be non-normalized, ____, and pre-aggregated.
answer
duplicated
question
The ____ schema is designed to optimize data query operations rather than data update operations.
answer
star
question
ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
answer
SQL
question
A ____ index is based on 0 and 1 bits to represent a given condition.
answer
bitmapped
question
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.
answer
data cube
question
A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
answer
matrix
question
What is one of the main characteristics of OLAP systems?
answer
They support client/server architecture
question
What is a characteristic of ROLAP?
answer
It uses the star schema
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
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New