Chapter 13 Flashcards
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
Analyzing decision support data to generate information is part of ____.
data warehousing
very large database systems
-business intelligence
distributed processing
A data mart is part of the “____” section of the business intelligence framework.
People
Management
Processes
-Governance
____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
DBMS
OLAP
Data warehousing
-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
____ provide a unified, single point of entry for information distribution.
Decision support systems
-Portals
Data warehouses
Dashboards
Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
decision support system
portal
-data warehouse
dashboard
BusinessObjects is a(n) ____ tool.
-OLAP
data visualization
data mining
data warehouse
____ 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
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
A characteristic of decision support data is ____.
-high query activity
high update volumes
highly normalized
low aggregation level
In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data warehouses.
megabytes
gigabytes
terabytes
-petabytes
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
____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
Data networks
-Data marts
Data cubes
OLAPs
There are 12 rules that define a(n) ____.
-data warehouse
multidimensional cube
OLAP tool
star schema
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 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
____ 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
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
A characteristic of operational data is ____.
summarized data
hundreds of gigabytes
-high normalization
historic data
The decision support database query optimizer must be enhanced to support non-normalized structures.
true
The BI architecture is composed of data, people, processes, technology, and the management of such components.
true
A data store is used by the data analyst to create the queries that access the database.
false
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
Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
false
The data warehouse development life cycle differs from classical systems development.
true
Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
-metadata
facts
information
rules
Data mining is part of the “____” section of the business intelligence framework.
People
Management
-Processes
Governance
____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
DBMS
OLAP
Data warehousing
-MDM
____ 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 is captured from the OLTP system and placed on the ____ on a near-real time basis.
decision support system
portal
-data warehouse
dashboard
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
A characteristic of operational data is ____.
summarized data
hundreds of gigabytes
-high normalization
historic data
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
