IS290 EXAM#3 Chapter 8

24 July 2022
4.7 (114 reviews)
21 test answers

Unlock all answers in this set

Unlock answers (17)
question
Which of the following occurs during data cleansing? All of these. Clean inaccurate data. Clean redundant records. Clean missing records.
answer
All of these
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? Operations management BI decisions Banking BI decisions Retail and sales BI decisions Insurance BI decisions
answer
Banking BI decisions
question
What do data warehouses support? OLAP and analytical processing OLTP OLAP Analytical processing
answer
OLAP and analytical processing
question
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.
answer
Accuracy versus completeness.
question
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
answer
Retail and sales BI decisions
question
Why is Ben & Jerry's using business intelligence? To improve financials. To create new flavors of ice cream. To manage distribution. To improve quality.
answer
To improve quality.
question
Why is Noodles & Company using business intelligence? To improve corporate processes. To track store quality. To improve financial analysis. To change the corporate culture.
answer
To improve financial analysis.
question
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.
answer
Accurate and complete information
question
What is information that people use to support their decision-making efforts? Information cleansing and scrubbing Data mining Business intelligence Data-mining tools
answer
Business intelligence
question
What is a dimension? A particular entity of information. A particular single repository. A particular attribute of information. A particular relational database.
answer
A particular attribute of information.
question
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.
answer
Operational systems are integrated.
question
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
answer
Using tactical business intelligence
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? Cube Block All of these Table
answer
Cube
question
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.
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 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.
answer
Process of analyzing data to extract information not offered by the raw data alone.
question
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.
answer
Information is multidimensional, meaning it contains layer of columns and rows.
question
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.
answer
The more complete and accurate an organization wants to get its information, the more it costs.
question
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.
answer
All of these.
question
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.
answer
During the ETL process and once it is in the data warehouse.
question
Which of the following can be use BI to make informed decisions? Airline industry All of these Broadcasting industry Law enforcement industry
answer
All of these
question
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
answer
Logical; operational