IS290 EXAM#3 Chapter 8 – Flashcards

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

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

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

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.

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

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

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

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.

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

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

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.

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

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

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.

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.

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.

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.

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.

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.

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

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