FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Accessing Organizational Information-Data Warehouse

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

What is the primary purpose of a data warehouse?

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.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

What is a dimension?

A) A particular attribute of information.
B) A particular entity of information.
C) A particular relational database.
D) A particular single repository.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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?

What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use,credit card spending by new customers,and which kinds of customers will best respond to new loan offers?

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent,incorrect,or incomplete information.

A(n)___________ is the common term for the representation of multidimensional information.

Which of the following describes ETL?

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

The Data Warehousing Institute estimates that low-quality information costs U.S.businesses $60 billion annually.

When does information cleansing occur in the data warehouse?

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?

Explain the problem associated with business intelligence.Describe the solution to this business problem.

What types of BI decisions include forecasting claim amounts and medical coverage costs,classifying the most important elements that affect medical coverage; predicting which customers will buy new insurance policies?

A dimension is a particular attribute of information.

What types of BI decisions include predicting sales,determining correct inventory levels,and distribution schedules among outlets,and loss prevention?

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

Identify the importance of ensuring the cleanliness of information throughout an organization.

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?

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

The primary purpose of a data warehouse is to perform transactional processes.