Chapter 13 Flashcards

1
Q

A data store is used by the data analyst to create the queries that access the database.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Operational data and decision support data serve the same purpose.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Facts can be computed or derived at run time.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.

A

-metadata

facts

information

rules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

data warehousing

very large database systems

-business intelligence

distributed processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

People

Management

Processes

-Governance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

DBMS

OLAP

Data warehousing

-MDM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

-data store

ETL tools

data visualization tool

data analysis tool

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Decision support systems

-Portals

Data warehouses

Dashboards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

decision support system

portal

-data warehouse

dashboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

BusinessObjects is a(n) ____ tool.

A

-OLAP

data visualization

data mining

data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

____ systems provided no data extraction/integration process.

A

Third-generation Mobile BI and cloud-based

First-generation BI

First-generation departmental decision support

-Traditional mainframe-based online transaction processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

From the data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and ____.

A

usability

-dimensionality

transaction processing

sparsity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A characteristic of decision support data is ____.

A

-high query activity

high update volumes

highly normalized

low aggregation level

19
Q

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

A

megabytes

gigabytes

terabytes

-petabytes

20
Q

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

A

volatility

time-variation

subject-orientation

-integration

21
Q

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

A

Data networks

-Data marts

Data cubes

OLAPs

22
Q

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

A

-data warehouse

multidimensional cube

OLAP tool

star schema

23
Q

The BI architecture is composed of data, people, processes, technology, and the management of such components.

24
Q

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.

25
The data warehouse development life cycle differs from classical systems development.
true
26
Data mining is part of the “____” section of the business intelligence framework.
People Management -Processes Governance
27
____ 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
28
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
29
A characteristic of operational data is ____.
summarized data hundreds of gigabytes -high normalization historic data
30
The decision support database query optimizer must be enhanced to support non-normalized structures.
true
31
The BI architecture is composed of data, people, processes, technology, and the management of such components.
true
32
A data store is used by the data analyst to create the queries that access the database.
false
33
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
34
The decision support database query optimizer must be enhanced to support non-normalized structures.
true
35
Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
false
36
The data warehouse development life cycle differs from classical systems development.
true
37
Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
-metadata facts information rules
38
Data mining is part of the “____” section of the business intelligence framework.
People Management -Processes Governance
39
____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
DBMS OLAP Data warehousing -MDM
40
____ 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
41
Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
decision support system portal -data warehouse dashboard
42
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
43
A characteristic of operational data is ____.
summarized data hundreds of gigabytes -high normalization historic data
44
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