Study
Homework Help
Writing
Blog
Pricing
Commerce and BusinessbackBusinessbackMISbackBusiness Driven TechnologybackPractice Set 2481back

Accessing Organizational Information-data Warehouse

This question bank verified by Studydeets

Questions Bank

All Questions
Filter by:
Question 1
Free
Multiple Choice

A data warehouse is a _________ collection of information - gathered from many different ___________ databases - that supports business-analysis activities and decision-making tasks.

Choose correct answer/s
A

physical; transactional

B

physical; operational

C

logical; transactional

D

logical; operational

Check answer
Question 2
Free
Multiple Choice

All of the following are reasons why operational systems are not appropriate for business analysis except:

Choose correct answer/s
A

Operational systems do not include information from other operational applications.

B

Operational systems are integrated.

C

Operational information is mainly current.

D

Operational information frequently has quality issues.

Check answer
Question 3
Free
Multiple Choice

What do data warehouses support?

Choose correct answer/s
A

OLAP

B

Analytical processing

C

OLTP

D

OLAP and analytical processing

Check answer
Question 4
Free
Multiple Choice

Which of the following describes ETL?

Choose correct answer/s
A

A process that extracts information from internal and external databases.

B

A process that transforms information using a common set of enterprise definitions.

C

A process that loads information into a data warehouse.

D

All of these.

Check answer
Question 5
Free
Multiple Choice

What is data mining?

Choose correct answer/s
A

The common term for the representation of multidimensional information.

B

A particular attribute of information.

C

Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

D

Process of analyzing data to extract information not offered by the raw data alone.

Check answer
Question 6
Multiple Choice

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

Choose correct answer/s
A
$500 million
B
$60 billion
C
$600 billion
D
It is impossible to determine.
To unlock the question
Question 7
Multiple Choice

When does information cleansing occur in the data warehouse?

Choose correct answer/s
A
During the ETL process.
B
On the information, once it is in the data warehouse.
C
During the ETL process and once it is in the data warehouse.
D
During the ETL process and before it is in the data warehouse.
To unlock the question
Question 8
Multiple Choice

Which of the following statements is true regarding customer information?

Choose correct answer/s
A
Customer information can exist in several operational systems.
B
Customer information in each operational system could change.
C
Customer information in each operational system can be different.
D
All of these
To unlock the question
Question 9
Multiple Choice

Which of the following occurs during data cleansing?

Choose correct answer/s
A
Clean missing records.
B
Clean redundant records.
C
Clean inaccurate data.
D
All of these.
To unlock the question
Question 10
Multiple Choice

Which of the following statements is true?

Choose correct answer/s
A
The more complete an organization wants to get its information, the less it costs.
B
The more accurate an organization wants to get its information, the less it costs.
C
The less accurate an organization wants to get its information, the more it costs.
D
The more complete and accurate an organization wants to get its information, the more it costs.
To unlock the question
Question 11
Multiple Choice

What is information that people use to support their decision-making efforts?

Choose correct answer/s
A
Information cleansing and scrubbing
B
Data-mining tools
C
Data mining
D
Business intelligence
To unlock the question
Question 12
Multiple Choice

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

Choose correct answer/s
A
Collecting information.
B
Discerning patterns and meaning in the information.
C
Accurate and complete information.
D
Responding to the resultant information.
To unlock the question
Question 13
Multiple Choice

Why is Ben & Jerry's using business intelligence?

Choose correct answer/s
A
To improve quality.
B
To create new flavors of ice cream.
C
To improve financials.
D
To manage distribution.
To unlock the question
Question 14
Multiple Choice

Why is Noodles & Company using business intelligence?

Choose correct answer/s
A
To improve financial analysis.
B
To improve corporate processes.
C
To track store quality.
D
To change the corporate culture.
To unlock the question
Question 15
Multiple Choice

Why would a business use a data warehouse that offers strategic level,external,integrated,and historical information?

Choose correct answer/s
A
Identify trends.
B
Make projections.
C
Decide key business issues.
D
All of these.
To unlock the question
Question 16
Multiple Choice

What is the primary purpose of a data warehouse?

Choose correct answer/s
A
To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B
To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C
To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
D
To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
To unlock the question
Question 17
Multiple Choice

Lands' End created an organization-wide data warehouse so all its employees could access organizational information.Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse,because it was simply too big,too complicated,and had too much irrelevant information.Lands' End knew there was valuable information in its data warehouse,and it had to find a way for its employees to easily access the information.What was Lands' End's solution?

Choose correct answer/s
A
Build a better, more efficient data warehouse.
B
Build a better, more efficient transactional database.
C
Build a data mart.
D
Build a data-driven website.
To unlock the question
Question 18
Multiple Choice

A relational database contains information in a series of two-dimensional tables.How is data contained in a data warehouse and data mart?

Choose correct answer/s
A
Information is multidimensional, meaning it contains a single layer of data in a table format.
B
Information is two-dimensional, meaning it contains a single layer of data in a table format.
C
Information is two-dimensional, meaning it contains layers of columns and rows.
D
Information is multidimensional, meaning it contains layers of columns and rows.
To unlock the question
Question 19
Multiple Choice

What is a dimension?

Choose correct answer/s
A
A particular attribute of information.
B
A particular entity of information.
C
A particular relational database.
D
A particular single repository.
To unlock the question
Question 20
Multiple Choice

A dimension is a particular attribute of information.Each layer in a data warehouse or data mart represents information according to an additional dimension.What is the common term for the representation of multidimensional information?

Choose correct answer/s
A
Table
B
Block
C
Cube
D
All of these
To unlock the question