Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Intro to Database Systems > Chapter 13 > Flashcards

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.

A

true

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.

A

true

25
Q

The data warehouse development life cycle differs from classical systems development.

A

true

26
Q

Data mining is part of the “____” section of the business intelligence framework.

A

People

Management

-Processes

Governance

27
Q

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

A

Data stores

ETL tools

-Data visualization tools

Data analysis tools

28
Q

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.

A

OLAP

data mining

-governance

networking

29
Q

A characteristic of operational data is ____.

A

summarized data

hundreds of gigabytes

-high normalization

historic data

30
Q

The decision support database query optimizer must be enhanced to support non-normalized structures.

A

true

31
Q

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

A

true

32
Q

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

A

false

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

A

true

34
Q

The decision support database query optimizer must be enhanced to support non-normalized structures.

A

true

35
Q

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

A

false

36
Q

The data warehouse development life cycle differs from classical systems development.

A

true

37
Q

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

A

-metadata

facts

information

rules

38
Q

Data mining is part of the “____” section of the business intelligence framework.

A

People

Management

-Processes

Governance

39
Q

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

A

DBMS

OLAP

Data warehousing

-MDM

40
Q

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

A

Data stores

ETL tools

-Data visualization tools

Data analysis tools

41
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

42
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

43
Q

A characteristic of operational data is ____.

A

summarized data

hundreds of gigabytes

-high normalization

historic data

44
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

Intro to Database Systems (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions