logo image

CIS Ch 13 Business Intelligence and Data Warehouses

A data store is used by the data analyst to create the queries that access the database.
False
Operational data and decision support data serve the same purpose.
False
Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
False
Facts can be computed or derived at run time.
True
Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.
True
It is a relatively easy task to provide a precise list of characteristics of data-mining tools.
False
In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.
True
Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.

metadata
facts
information
rules

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

data warehousing
very large database systems
business intelligence
distributed processing

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

People
Management
Processes
Governance

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

DBMS
OLAP
Data warehousing
MDM

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

data store
ETL tools
data visualization tool
data analysis tool

data store
____ provide a unified, single point of entry for information distribution.

Decision support systems
Portals
Data warehouses
Dashboards

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

decision support system
portal
data warehouse
dashboard

Data warehouses
BusinessObjects is a(n) ____ tool.

OLAP
data visualization
data mining
data warehouse

OLAP
____ systems provided no data extraction/integration process.

Third-generation Mobile BI and cloud-based
First-generation BI
First-generation departmental decision support
Traditional mainframe-based online transaction processing

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 ____.

usability
dimensionality
transaction processing
sparsity

dimensionality
A characteristic of decision support data is ____.

high query activity
high update volumes
highly normalized
low aggregation level

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

megabytes
gigabytes
terabytes
petabytes

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

volatility
time-variation
subject-orientation
integration

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

Data networks
Data marts
Data cubes
OLAPs

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

data warehouse
multidimensional cube
OLAP tool
star schema

data warehouse
The BI architecture is composed of data, people, processes, technology, and the management of such components.
True
To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.
True
The decision support database query optimizer must be enhanced to support non-normalized structures.
True
The data warehouse development life cycle differs from classical systems development.
True
Data mining is part of the “____” section of the business intelligence framework.

People
Management
Processes
Governance

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

Data stores
ETL tools
Data visualization tools
Data analysis tools

Data visualization tools
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.

OLAP
data mining
governance
networking

governance
A characteristic of operational data is ____.

summarized data
hundreds of gigabytes
high normalization
historic data

high normalization

Need essay sample on "CIS Ch 13 Business Intelligence and Data Warehouses"? 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