Ch8

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 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.

Business intelligence (BI) refers to applications and technologies that are used to gather, provide access to, and analyze data and information to support decision-making efforts. -True -False

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

What does the Data Warehousing Institute estimate that low-quality information costs U.S. businesses annually? -$5 million -$6 trillion -$6 billion -$600 billion

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

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

A cube is the common term for the representation of multidimensional information. -True -False

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

Which of the following is one of the principle BI enablers? -Technology, processes, and corporate culture -Technology, people, and corporate culture -Technology, people, and customer culture -Technology, processes, and customer culture

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 complexity -Accuracy versus complexity -Accuracy versus completeness -Accessibility versus completeness

Which of the following statements is true? -The more complete an organization wants to get its information, the less it costs -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

A dimension is a particular attribute of information. -True -False

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 solution? -Build a better, more efficient data warehouse -Build a data mart -Build a better, more efficient transactional database -Build a data-driven website

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 -Discerning patterns and meaning in the information -Accurate and complete information

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

Which of the following describes ETL? -A process that transforms information using a common set of enterprise definitions -A process that loads information into a data warehouse -A process that extracts information from internal and external databases -All of the above

With careful planning, 100% complete and accurate information is possible. -True -False

A data mart is a company that collects and sells external data for a data warehouse. -True -False

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

Which of the following is not one of the principal BI enablers? -Technology -Corporate processes -People -Corporate culture

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

Which of the following occurs during data cleansing? -Clean inconsistent information -Clean incorrect information -Clean incomplete information -All of the above

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

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

Which of the following statements is true regarding customer information? -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 the above

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 -Does not include information from other operational applications -Operational systems are integrated

The data warehouse is a location for all of a business's information. -True -False

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database. -True -False