IS 290 Chapter 8 – Flashcards
Unlock all answers in this set
Unlock answersquestion
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?
answer
Accuracy versus completeness.
question
A data warehouse is a _________ collection of information - gathered from many different ___________ databases - that supports business-analysis activities and decision-making tasks.
answer
logical; operational
question
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?
answer
Cube
question
All of the following are reasons why operational systems are not appropriate for business analysis except:
answer
Operational systems do not include information from other operational applications, *Operational systems are integrated, Operational information is mainly current, Operational information frequently has quality issues.
question
A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart?
answer
Information is multidimensional, meaning it contains layers of columns and rows.
question
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?
answer
Build a data mart.
question
What do data warehouses support?
answer
OLAP and analytical processing
question
What does the Data Warehousing Institute estimate that low-quality information costs U.S. businesses annually?
answer
$600 billion
question
What is a dimension?
answer
A particular attribute of information.
question
What is data mining?
answer
Process of analyzing data to extract information not offered by the raw data alone.
question
What is information that people use to support their decision-making efforts?
answer
Business intelligence
question
What is the primary purpose of a data warehouse?
answer
To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
question
What is the primary problem most organizations face today concerning information?
answer
Data rich, information poor
question
What types of BI decisions include predicting sales, determining correct inventory levels, and distribution schedules among outlets, and loss prevention?
answer
Retail and sales BI decisions
question
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?
answer
Banking BI decisions
question
What types of BI decisions include forecasting claim amounts and medical coverage costs, classifying the most important elements that affect medical coverage
answer
predicting which customers will buy new insurance policies? ;Insurance BI decisions
question
When does information cleansing occur in the data warehouse?
answer
During the ETL process and once it is in the data warehouse.
question
Which of the following describes ETL?
answer
A process that extracts information from internal and external databases, A process that transforms information using a common set of enterprise definitions, A process that loads information into a data warehouse, *All of these.
question
Which of the following statements is true regarding customer information?
answer
Customer information can exist in several operational systems, Customer information in each operational system could change, Customer information in each operational system can be different, *All of these
question
Which of the following occurs during data cleansing?
answer
Clean missing records, Clean redundant records, Clean inaccurate data, *All of these.
question
Which of the following statements is true?
answer
The more complete and accurate an organization wants to get its information, the more it costs.
question
Which of the following does not draw a parallel between the challenges in business and the challenges of war?
answer
Accurate and complete information.
question
Which of the following is not one of the parallels between challenges in business and those of war?
answer
Using tactical business intelligence
question
Which of the following can use BI to make informed decisions?
answer
Law enforcement industry, Airline industry, Broadcasting industry, *All of these
question
Why is Ben & Jerry's using business intelligence?
answer
To improve quality.
question
Why is Noodles & Company using business intelligence?
answer
To improve financial analysis.
question
Why would a business use a data warehouse that offers strategic level, external, integrated, and historical information?
answer
Identify trends, Make projections, Decide key business issues, *All of these.
