logo image

CH 13 MC

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

Need essay sample on "CH 13 MC"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy