Accessing Organizational Complete Test Bank Ch.7 nan

Business Driven Technology, 8e (Baltzan)

Chapter 7 Accessing Organizational Information—Data Warehouses

1) What is it called when a manager has so much data and information that they cannot make a decision?

A) Data rich, information poor

B) Data rich, content poor

C) Data rich, communication poor

D) Data rich, intelligence

2) Which of the below questions can be answered using business intelligence?

A) Where has the business been?

B) Where is the business now?

C) Where is the business going?

D) All of the choices are correct.

3) What is information that people use to support their decision-making efforts?

A) Information cleansing and scrubbing

B) Data-mining tools

C) Data mining

D) Business intelligence

4) A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.

A) Logical, operational

B) Physical, operational

C) Logical, transactional

D) Physical, transactional

5) Which of the following is incorrect in terms of data warehousing and business intelligence?

A) Does not include information from other operational applications

B) Operational systems are integrated

C) Operational information is mainly current

D) Operational information frequently has quality issues

6) What do data warehouses support?

A) OLAP

B) Analytical processing

C) OLTP

D) OLAP and analytical processing

7) The primary purpose of a data warehouse is to ________.

A) Combine strategic information

B) Organize departments

C) Interface between the computer and employees

D) All of the choices are correct

8) Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

A) Information scaling

B) Streamlining data points

C) Standardizing information

D) Standardizing protocols

9) Why were data warehouses created?

A) Numbers and types of operational databases increased as businesses grew

B) Many companies had information scattered across multiple systems with different formats

C) Completing reporting requests from numerous operational systems took days or weeks

D) All of the choices are correct

10) What is extraction, transformation, and loading?

A) It is a process of entering data, tracking data, and loading it into a database

B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse

C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube

D) It is a process that is performed at the beginning of the data mining model

11) Which of the following describes ETL?

A) A process that extracts information from internal and external databases

B) A process that transforms information using a common set of enterprise definitions

C) A process that loads information into a data warehouse

D) All of the choices are correct

12) Which of the following statements is true regarding customer information?

A) Customer information can exist in several operational systems

B) Customer information in each operational system could change

C) Customer information in each operational system can be different

D) All of the choices are correct

13) Which of the following occurs during data cleansing?

A) Clean missing records

B) Clean redundant records

C) Clean inaccurate data

D) All of the choices are correct

14) Which of the following occurs during data cleansing?

A) Clean data marts

B) Clean redundant customer data

C) Clean accurate data

D) Clean correct data

15) Which of the following statements is true?

A) The more complete an organization wants to get its information, the less it costs

B) The more accurate an organization wants to get its information, the less it costs

C) The less accurate an organization wants to get its information, the more it costs

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

16) What is the ultimate outcome of a data warehouse?

A) Data goals

B) Data relationships

C) Data marketing

D) Data marts

17) Which of the following contains a subset of data warehouse information?

A) Data miner

B) Data mart

C) Data pool

D) Data analyzing tool

18) What is another term for information cleansing?

A) Information mining

B) Information scrubbing

C) Information scrapping

D) Information marts

19) What determines the accuracy and completeness of organizational data?

A) Data quantity audit

B) Data quality audit

C) Data intelligence audit

D) Data accuracy audit

20) Which of the following is not an information cleansing activity?

A) Identifies redundant records

B) Identifies inaccurate or incomplete data

C) Identifies missing records or attributes

D) Identifies sales trends

21) Which of the following is a problem associated with dirty data?

A) Duplicate data

B) Incorrect data

C) Violates business rules

D) All of the choices are correct

22) Which of the following is a problem associated with dirty data?

A) Duplicate data

B) Correct data

C) Accurate data

D) All of the choices are correct

23) Which of the following is a problem associated with dirty data?

A) Inaccurate data

B) Misleading data

C) Non-formatted data

D) All of the choices are correct

24) Which of the following is a problem associated with dirty data?

A) Non-formatted data

B) Misleading data

C) Incorrect data

D) All of the choices are correct

25) Which of the following is a problem associated with dirty data?

A) Formatted data

B) Misleading data

C) Correct data

D) All of the choices are correct

26) A central location in which data is stored and managed is called a data mart.

27) A repository is a central location in which data is stored and managed.

28) A data mart contains a subset of data warehouse information.

29) Data aggregation is the collection of data from various sources for the purpose of data processing.

30) One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

31) The complete removal of dirty data from a source is practical and possible.

32) According to Gartner Inc., dirty data is an MIS problem, not a business problem.

33) Dirty data is erroneous or flawed data.

34) A data warehouse is a central location in which data is stored and managed.

35) A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

36) The primary purpose of a data warehouse is to perform transactional processes.

37) The primary purpose of a data warehouse is to combine information.

38) Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

39) A data miner contains a subset of data warehouse information.

40) ETL, within a data warehouse model, stands for exit, track, and load.

41) ETL stands for extraction, transformation, and loading.

42) Within the data warehouse model, the external databases could include competitor information, industry information, mailing lists, and stock market analysis.

43) Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

44) Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

45) Many firms complete data quality audits to determine the accuracy and completeness of its data.

46) Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

47) In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

48) A comparative analysis can compare two or more data sets to identify patterns and trends.

49) Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

50) A data set is an organized collection of data. 

51) The financial industry uses business intelligence to predict hardware failures.

52) The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

53) Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

54) Competitive monitoring can compare two or more data sets to identify patterns and trends.

55) A data broker is an individual item on a graph or a chart.

56) A data lake is a business that collects personal information about consumers and sells that information to other organizations.

57) A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

58) While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

59) Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

60) Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

61) Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

62) A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

63) A data point is an individual item on a graph or chart.

64) Organizational data includes simple structured data elements in a database.

65) A data set is an individual item on a graph or chart.

66) Which of the following are examples of external databases in the data warehouse model?

A) Marketing, sales, inventory, and billing

B) Data mart 1, data mart 2, and data mart 3

C) Competitor and industry information, mailing lists, and stock market analysis

D) Marketing information, sales information, and stock market analysis

67) Which of the following is an example of an external database in the data warehouse model?

A) Marketing information

B) Sales information

C) Competitor information

D) All of these

68) Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

A) Marketing, sales, inventory, and billing

B) Data mart 1, data mart 2, data mart 3

C) Competitor and industry information, mailing lists, and stock market analysis

D) Marketing information, and stock market analysis numbers

69) What are the primary differences between a data warehouse and a data mart?

A) Data warehouses make quick decisions; data marts make slow decisions

B) Data warehouse tackle ethical issues; data marts tackle hypothetical issues

C) Data warehouses have a more organization wide focus; data marts have functional focus

D) Data warehouses have a physical focus; data marts have logical focus.

70) What is erroneous or flawed data?

A) Dirty data

B) Information cleansing

C) Information Scrubbing

D) ETL

71) Which of the following is a problem associated with dirty data?

A) Inaccurate data

B) Non-integrated data

C) Violates business rules data

D) All of these

72) Which of the following is a problem associated with dirty data?

A) Accurate data

B) Integrated data

C) Violates business rules data

D) All of these

73) Business analysis is difficult from operational databases. Which of the following is a reason why?

A) Every department has its own method for recording data.

B) Data standards do not apply across departments.

C) The data, if available, were often incorrect or incomplete.

D) All of these.

74) Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?

A) Inconsistent data definitions

B) Lack of data standards

C) Effective direct data access

D) Poor data quality

75) Which of the following is not a dirty data problem?

A) Duplicate data.

B) Inaccurate data.

C) Specific data.

D) Non-integrated data.

76) Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

A) Oracle.

B) SAS.

C) Ascential Software.

D) McAffee.

77) What is erroneous or flawed data?

A) Data set

B) Dirty data

C) Data map

D) Data point

78) What is an organized collection of data?

A) Data set.

B) Dirty data.

C) Data map.

D) Data point.

79) Which of the following questions can be answered using business intelligence?

A) Where has the business been?

B) Where is the business now?

C) Where is the business going?

D) All of these.

80) How would the banking industry use business intelligence?

A) Analyze popular vacation locations with current flight listings

B) Understand customer credit card usage and nonpayment rates

C) Compare the demographics of patients with critical illnesses

D) Predict claim amounts and medical coverage costs

81) How would the health care industry use business intelligence?

A) Analyze popular vacation locations with current flight listings

B) Understand customer credit card usage and nonpayment rates

C) Compare the demographics of patients with critical illnesses

D) Predict claim amounts and medical coverage costs

82) How would the insurance industry use business intelligence?

A) Analyze popular vacation locations with current flight listings

B) Understand customer credit card usage and nonpayment rates

C) Compare the demographics of patients with critical illnesses

D) Predict claim amounts and medical coverage costs

83) How would the law enforcement industry use business intelligence?

A) Track crime patterns, locations, and criminal behavior

B) Analyze customer demographics

C) Predict sales, inventory levels, and distribution

D) Predict hardware failures

84) How would the marketing industry use business intelligence?

A) Track crime patterns, locations, and criminal behavior

B) Analyze customer demographics

C) Predict sales, inventory levels, and distribution

D) Predict hardware failures

85) How would the retail industry use business intelligence?

A) Track crime patterns, locations, and criminal behavior

B) Analyze customer demographics

C) Predict sales, inventory levels, and distribution

D) Predict hardware failures

86) How would the technology industry use business intelligence?

A) Track crime patterns, locations, and criminal behavior

B) Analyze customer demographics

C) Predict sales, inventory levels, and distribution

D) Predict hardware failures

87) What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

A) Data set

B) Dirty data

C) Data map

D) Data point

88) What is an individual item on a graph or a chart?

A) Data set

B) Dirty data

C) Data map

D) Data point

89) What is a central location in which data is stored and managed?

A) Repository

B) Data warehouse

C) Data aggregation

D) Data broker

90) What is a collection of data from various sources for the purpose of data processing?

A) Repository

B) Data warehouse

C) Data aggregation

D) Data broker

91) What is a business that collects personal information about consumers and sells that information to other organizations?

A) Repository

B) Data warehouse

C) Data aggregation

D) Data broker

92) ________ can compare two or more data sets to identify patterns and trends.

A) Comparative analysis

B) Competitive monitoring

C) Data-driven decision management

D) Competitive analysis

93) BI can help managers with ________, where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

A) Comparative analysis

B) Competitive monitoring

C) Data-driven decision management

D) Source data

94) Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

A) Comparative analysis

B) Competitive monitoring

C) Data-driven decision management

D) Source data

95) Which of the following identifies the primary location where data is collected?

A) Comparative analysis

B) Competitive monitoring

C) Data-driven decision management

D) Source data

96) What is a storage repository that holds a vast amount of raw data in its original format until the business needs it?

A) Data broker

B) Data lake

C) Data map

D) Data point

97) What is a data broker?

A) A business that collects personal information about consumers and sells that information to other organizations

B) A storage repository that holds a vast amount of raw data in its original format until the business needs it

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

98) What is a data lake?

A) A business that collects personal information about consumers and sells that information to other organizations

B) A storage repository that holds a vast amount of raw data in its original format until the business needs it

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

99) What is a data map?

A) A business that collects personal information about consumers and sells that information to other organizations

B) A storage repository that holds a vast amount of raw data in its original format until the business needs it

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

100) What is data-driven decision management?

A) A business that collects personal information about consumers and sells that information to other organizations

B) A storage repository that holds a vast amount of raw data in its original format until the business needs it

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

101) What is source data?

A) Identifies the primary location where data is collected

B) A storage repository that holds a vast amount of raw data in its original format until the business needs it

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

102) What is a data point?

A) Identifies the primary location where data is collected

B) An individual item on a graph or chart

C) A technique for establishing a match, or balance, between the source data and the target data warehouse

D) An approach to business governance that values decisions that can be backed up with verifiable data

103) Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

A) Analyze popular vacation locations with current flight listings

B) Understand customer credit card usage and nonpayment rates

C) Compare the demographics of patients with critical illnesses

D) All of these are examples of how industries use business intelligence

104) Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

A) Predict claim amounts and medical coverage costs

B) Track crime patterns, locations, and criminal behavior

C) Identify the primary locations where data is collected

D) Predict sales, inventory levels, and distribution

105) Which of the following questions is an example of how managers can use BI to answer tough business questions?

A) Where has the business been?

B) Where is the business now?

C) Where is the business going?

D) All of these.

106) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

A) A historical perspective offers important variables for determining trends and patterns.

B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.

C) Setting strategic direction is critical for planning and creating solid business strategies.

D) None of these.

107) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

A) A historical perspective offers important variables for determining trends and patterns.

B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.

C) Setting strategic direction is critical for planning and creating solid business strategies.

D) None of these.

108) Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?

A) A historical perspective offers important variables for determining trends and patterns.

B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.

C) Setting strategic direction is critical for planning and creating solid business strategies.

D) None of these.

109) Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had ________ productivity rates and ________ profits.

A) 4% lower, 6% higher

B) 4% higher, 6% lower

C) 4% higher, 6% higher

D) 4% lower, 6% lower

110) Business analysis is different from operational databases. Which of the following is not a reason why?

A) Every department has its own method for recording data.

B) When sharing data, the data matches with the data warehouse and users get the data they need.

C) The data is of poor quality.

D) The data collected is not always useful for intended purposes.

111) Business analysis is different from operational databases. Which of the following is not a reason why?

A) Every department has its own method for recording data.

B) Data stored in operational databases did not allow users direct access.

C) The data is standardized.

D) The data collected is not always useful for intended purposes.

112) What does standardization of data elements accomplish?

A) Greater accuracy

B) Completeness and completeness

C) Increases the quality of information

D) All of these

113) In which ways does a data warehouse enable business users to be more effective?

A) Analyzing trends

B) Identifying financial issues

C) Understanding competitors

D) All of these

114) Businesses collect a tremendous amount of ________ information as part of their routine operations.

A) operational

B) transactional

C) aggregate

D) comparative

115) Bethany Walsh is a business manager at Dixon Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

A) Data point

B) Information cleansing

C) Dashboard

D) Data set

116) Define a data warehouse and provide a few reasons it can make a manager more effective.

117) Explain ETL and the role of a data mart in business.

118) Identify the advantages of using business intelligence to support managerial decision making.