IS290 EXAM#3 Chapter 8

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

Retail and sales BI decisions

What is a dimension? A particular entity of information. A particular single repository. A particular attribute of information. A particular relational database.

A particular attribute of information.

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? Operations management BI decisions Banking BI decisions Retail and sales BI decisions Insurance BI decisions

Banking BI decisions

A data warehouse is a ______ collection of information - gathered from many different _____ databases - that supports business-analysis activities and decision-making tasks. Logical; transactional Physical; operational Logical; operational Physical; transactional

Logical; operational

When does information cleansing occur in the data warehouse? During the ETL process and once it is in the data warehouse. On the information, once it is in the data warehouse. During the ETL process. During the ETL process and before it is in the data warehouse.

During the ETL process and once it is 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? Accessibility versus completeness. Accessibility versus complexity. Accuracy versus completeness. Accuracy versus complexity.

Accuracy versus completeness.

Which of the following does not draw a parallel between the challenges in business and the challenges of war? Responding to the resultant information. Collecting information. Accurate and complete information Discerning patterns and meaning in the information.

Accurate and complete information

Which of the following can be use BI to make informed decisions? Airline industry All of these Broadcasting industry Law enforcement industry

All of these

Which of the following occurs during data cleansing? All of these. Clean inaccurate data. Clean redundant records. Clean missing records.

All of these

Why would a business use a data warehouse that offers strategic level, external, integrated, and historical information? Decide key business issues. Make projections. Identify trends. All of these.

All of these.

What is information that people use to support their decision-making efforts? Information cleansing and scrubbing Data mining Business intelligence Data-mining tools

Business intelligence

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? Cube Block All of these Table

Cube

A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart? Information is multidimensional, meaning it contains a single layer of data in a table format. Information is multidimensional, meaning it contains layer of columns and rows. Information is two-dimensional, meaning it contains a single layer of data in a table format. Information is two-dimensional, meaning it contains layers of columns and rows.

Information is multidimensional, meaning it contains layer of columns and rows.

What do data warehouses support? OLAP and analytical processing OLTP OLAP Analytical processing

OLAP and analytical processing

All of the following are reasons why operational systems are not appropriate for business analysis except: Operational information is mainly current. Operational information frequently has quality issues. Operational systems do not include information from other operational applications. Operational systems are integrated.

Operational systems are integrated.

What is data mining? A particular attribute of information. Process of analyzing data to extract information not offered by the raw data alone. The common term for the representation of multidimensional information. 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.

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

Which of the following is not one of the parallels between challenges in business and those of war? Discerning patterns and meaning in the information Using tactical business intelligence Responding to the resultant information Collecting information

Using tactical business intelligence

Which of the following statements is true? The more accurate an organization wants to get its information, the less it costs. The more complete and accurate an organization wants to get its information, the more it costs. The less accurate an organization wants to get its information, the more it costs. The more complete an organization wants to gets its information, the less it costs.

The more complete and accurate an organization wants to get its information, the more it costs.

What is the primary purpose of a data warehouse? To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities. 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 aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities. To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

Why is Noodles & Company using business intelligence? To improve corporate processes. To track store quality. To improve financial analysis. To change the corporate culture.

To improve financial analysis.

Why is Ben & Jerry's using business intelligence? To improve financials. To create new flavors of ice cream. To manage distribution. To improve quality.

To improve quality.