MIS Chapter 9

7 September 2022
4.7 (114 reviews)
86 test answers
question
1. Which of the following accurately defines a dimension in an OLAP report? It is a characteristic of a measure It is an item that is processed in the OLAP report It is a data item of interest It is referred to a decision tree It is a branch in a decision tree
answer
It is a characteristic of a measure
question
2. Which of the following statements is TRUE about unsupervised data mining? Analysts do not create a model or hypothesis before running the analysis Neural networks are a popular unsupervised data mining application Unsupervised data mining requires tools such as regression analysis Data miners develop a model prior to the analysis and apply statistical techniques to data Hypotheses must be made before running the analysis
answer
Analysts do not create a model or hypothesis before running the analysis
question
3. In the context of knowledge management systems, ________ are rule-based systems that encode human knowledge in the form of If/Then rules. Expert networks Expert systems Intelligent systems Decision-making systems Waterfall systems
answer
Expert systems
question
4. ________ is the process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need it. Intellectual property protection Knowledge management Business process reengineering Repository management Industrial information exchange
answer
Knowledge management
question
5. ________ is defined as information containing patterns, relationships, and trends of various forms of data. Process mining Business process management Business intelligence Spatial intelligence Pattern recognition
answer
Business intelligence
question
6. Which of the following techniques determine sales patterns? Regression analysis Market-basket analysis Neural networks Cluster analysis Seasonal grouping
answer
Market-basket analysis
question
7. Which of the following is an example of a supervised data mining technique? Cluster analysis Market-basket analysis Regression analysis Click streaming Metadata matching
answer
Regression analysis
question
8. A decision tree analysis is a supervised data mining technique. True False
answer
False
question
9. A data ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of the business. Mart Mine Cube Model Conduit
answer
Mart
question
10. Data warehouses may include data that is purchased from outside sources. True False
answer
True
question
11. Which of the following statements is TRUE of source data for a business intelligence (BI) system? It refers to the organization's metadata It refers to data that the organization purchases from data vendors It refers to the detailed level of data It refers to the hierarchical arrangement of criteria that predict a classification or a value It refers to the relative strength of data's predictive capabilities
answer
It refers to data that the organization purchases from data vendors
question
12. An advantage of OLAP reports is their ability to let users drill down into the data True False
answer
True
question
13. A(n) ________ is a complicated set of possibly nonlinear equations. Data warehouse Neural network Expert system Online analytical processing (OLAP) cube Artificial intelligence
answer
Neural network
question
14. A data mart is larger than a data warehouse True False
answer
False
question
15. Which of the following terms is used as a synonym for data mining? Regression analysis Data warehousing Knowledge discovery in databases (KDD) Parallel processing in database (PPD) Data spelunking
answer
Knowledge discovery in databases (KDD)
question
16. ________ analysis is a way of analyzing and ranking customers according to their purchase patterns. Regression CRM Market-basket RFM Cluster analysis
answer
RFM
question
17. Report can change its format. Which term implies this capability? Processing Analytical Dimension Online Alteration
answer
Online
question
18. ________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge. Decision Support Systems (DSS) Online Analytical Processing (OLAP) systems Content Management Systems (CMS) Data Transfer Protocols (DTP) Document Delivery System (DDS)
answer
Content Management Systems (CMS)
question
19. Expert systems are rule-based systems that encode human knowledge in the form of If/Then rules. True False
answer
True
question
20. Data mining is the application of statistical techniques to find patterns and relationships among data for classification and prediction. True False
answer
True
question
21. ________ refers to the source, format, assumptions and constraints, and other facts about the data. Clickstream data Dimensional data Outsourced data Metadata Attributed data
answer
Metadata
question
22. Push publishing can deliver results according to a schedule or as a result of an event or particular data condition. True False
answer
True
question
23. OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data. True False
answer
True
question
24. Knowledge management was done only after the advent of social media. True False
answer
False
question
25. Which of the following observations about RFM and OLAP reports is TRUE? RFM reports are more generic than OLAP reports OLAP reports are more dynamic than RFM reports RFM reports have measures and dimensions RFM reports can drill down into the data to a greater extent than OLAP reports RFM reports are more easily manipulated than OLAP reports
answer
OLAP reports are more dynamic than RFM reports
question
26. Samuel, a researcher, deduces that single women between the ages of 25 and 30, who usually live in the suburbs and make thrifty purchases, prefer a particular brand of washing machines. In this case, Samuel uses ________ to understand customer behavior. Supervised data mining Cluster analysis Neural networks Market-basket analysis Metadata matching
answer
Cluster analysis
question
27. Which of the following is a fundamental category of business intelligence (BI) analysis? Automation Encapsulation Data hiding Data mining Cataloging
answer
Data mining
question
28. ________ is a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence. An OLAP application A reporting application A NoSQL application A trans enterprise application A classful application
answer
A reporting application
question
29. Matt, a sales analyst, predicts the sale of luxury cars by formulating an equation that uses variables such as the customer's age and monthly salary. Which of the following methods does Matt use in this case? BigData analysis Regression analysis Market-basket analysis Cluster analysis Analytical hierarchical analysis
answer
Regression analysis
question
30. In ________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model. Cluster analysis Unsupervised data mining Supervised data mining Click streaming Metadata matching
answer
Supervised data mining
question
31. ________ is a concept that computer systems will become sophisticated enough that they can adapt and create their own software and hence adapt their behavior without human assistance. Expert system The Singularity Knowledge management Business intelligence systems Moore's Law
answer
The Singularity
question
Cluster analysis is used to identify groups of entities that have similar characteristics True False
answer
True
question
It is better to have data with too coarse a granularity than too fine. True False
answer
False
question
In expert systems, the programs that process a set of rules are called expert system shells. True False
answer
True
question
A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves. Data link layer Data mine Data warehouse Data model Data bus
answer
Data warehouse
question
36. Data mart is another term used for a data warehouse. True False
answer
False
question
37. ________ requires the user to request business intelligence (BI) results. Push publishing Pull publishing Desktop publishing Accessible publishing Pulse publishing
answer
Pull publishing
question
Business intelligence (BI) systems have five standard components called hardware, software, data, procedures and people. True False
answer
True
question
Operational data is structured for fast and reliable transaction processing. True False
answer
True
question
40. In an unsupervised data mining technique, analysts do not create a model or hypothesis before running the analysis. True False
answer
True
question
41. An ________ and an OLAP report are the same thing. OLAP measure OLAP cube OLAP dimension OLAP array OLAP permutation
answer
OLAP cube
question
42. A particular BI analysis might require data from an ERP system, an e-commerce system, and a social networking application, but such a data collection will likely have relationships that are not represented in primary key/foreign key relationships. This is an example of ________. Missing values Inconsistent data Dirty data Data not integrated Septic data
answer
Data not integrated
question
43. Regression analysis measures the effect of a set of variables on another variable. True False
answer
True
question
44. A ________ is a hierarchical arrangement of criteria that predict a classification or a value. Value chain Cluster analysis Decision tree Neural network Sync path
answer
Decision tree
question
45. ________ includes a query language titled Pig. MapReduce Hadoop RFM Analysis Online analytical processing (OLAP) Korn shell
answer
Hadoop
question
46. ________ is a technique for harnessing the power of thousands of computers working in parallel. RFM analysis MapReduce Granularity Reposition Big data looping
answer
MapReduce
question
47. An OLAP report has measures and dimensions. Which of the following is an example of a dimension? Total sales Average sales Sales region Average cost Average net sales
answer
Sales region
question
48. In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________. Confidence Support Granularity Lift Loop
answer
Lift
question
49. ________ is the application of social media and related applications for the management and delivery of organizational knowledge resources. Business intelligence server management Hyper-social knowledge management Knowledge management protocol Online analytical processing Proto-social information management
answer
Hyper-social knowledge management
question
50. Which of the following statements is TRUE about data marts? A data mart is like a distributor in a supply chain, while a data warehouse can be compared to a retail store. Data mart users possess the data management expertise that data warehouse employees have. Data marts address the needs of a particular department or functional area of a business. Data marts are larger than data warehouses. Data marts contain only metadata for data warehouses.
answer
Data marts address the needs of a particular department or functional area of a business.
question
51. Which of the following is a basic operation used by reporting applications to produce business intelligence? Coalescing Transposing Dispersing Calculating Diffusing
answer
Calculating
question
52. Hadoop is an open-source program supported by the Apache Foundation that implements MapReduce on potentially thousands of computers. True False
answer
True
question
53. OLAP stands for ________. Online analytical processing Object-based lead analysis procedure Object-oriented analytical protocol Organizational lead analysis process Optimal linear analytical processing
answer
Online analytical processing
question
54. Granularity is a term that refers to the level of detail represented by the data. True False
answer
True
question
55. Judy is analyzing weekly sales transactions at a supermarket. She finds that the support value for bed sheets and pillow covers is 0.9. Given this information, which of the following statements is TRUE? The sale of bedsheets and pillow covers is lower than other items. Customers who buy bedsheets usually also buy pillow covers. The supermarket carries a large stock of bedsheets and pillow covers. Customers who buy bedsheets rarely also buy pillow covers. The sales of bed sheets far exceeds the sales of pillow covers.
answer
Customers who buy bedsheets usually also buy pillow covers.
question
56. The three primary activities in the business intelligence (BI) process are to acquire data, perform analysis, and publish results. True False
answer
True
question
57. Ajax Inc. is one of the customers of a well-known linen manufacturing company. Ajax has not ordered linen in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. Under the given circumstances, Ajax is most likely to have an RFM score of ________. 155 511 555 151 515
answer
155
question
58. ________ is an employee directory that includes not only the standard name, email, phone, and address but also organizational structure and expertise. A data library A data-linked library A subscriber directory A static directory A rich directory
answer
A rich directory
question
59. Which of the following phenomena states that the more attributes there are, the easier it is to build a model that fits the sample data? Attribute paradox Curse of dimensionality Uncertainty principle Economies of scale Murphy's law
answer
Curse of dimensionality
question
60. ________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data. Data entry Data acquisition Data mining Data encryption Data scrubbing
answer
Data acquisition
question
61. Knowledge management (KM) benefits organizations because it ________. Allows distributors to work within the company premises Allows suppliers to work according to the organizational policies Enables employees to solve problems and rectify mistakes later Improves process quality and increases team strength Improves data integrity, transmission, and value
answer
Improves process quality and increases team strength
question
62. An OLAP cube and an OLAP report are the same thing. True False
answer
True
question
63. BI servers use ________ to determine what results to send to which users and on which schedule. Expert systems Metadata RSS feeds Neural networks IP logs
answer
Metadata
question
64. Capturing customers' clicking behavior is referred to as ________. Clickstream data Dimensional data Outsourced data Metadata Attributed data
answer
Clickstream data
question
65. In the context of knowledge management systems, ________ are rule-based systems that encode human knowledge in the form of If/Then rules. Expert networks Expert systems Intelligent systems Decision-making systems Waterfall systems
answer
Expert systems
question
66. ________ delivers business intelligence to users without any request from the users. Push publishing Pull publishing Desktop publishing Accessible publishing Pulse publishing
answer
Push publishing
question
67. Opezim Plastics has been supplying raw materials to JM Toys for five years. JM Toys has an RFM score of 121. With reference to the score, how should the sales team at Opezim respond to JM Toys? The sales team should contact JM Toys immediately. The sales team should let go of JM Toys, for the loss will be minimal. The sales team should attempt to up-sell more expensive goods to JM Toys. The sales team should spend more time with JM Toys. The sales team should attempt to sell directly to the CEO.
answer
The sales team should let go of JM Toys, for the loss will be minimal.
question
68. In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X." Cross-selling Value added selling Break-even Double-sales Quid pro quo
answer
Cross-selling
question
69. The viewer of an OLAP report can change its format. Which term implies this capability? Processing Analytical Dimension Online Alteration
answer
Online
question
70. A business intelligence (BI) server extends alert/RSS functionality to support user subscriptions. True False
answer
True
question
71. Dynamic reports are business intelligence (BI) documents that are updated at the time they are requested. True False
answer
True
question
72. In market-basket terminology, ________ describes the probability that two items will be purchased together. support confidence lift dimension connection
answer
support
question
73. ________ analysis is a way of analyzing and ranking customers according to their purchasing patterns. Regression CRM Market-basket RFM Cluster analysis
answer
RFM
question
74. Achilles Gear has four major retail customers. Based on the following RFM scores of these customers, the sales team at Achilles' should attempt to up-sell more expensive sporting goods to ________. Five Star Stores with an RFM score of 214 Goalkeeper with an RFM score of 551 Pelican Stores with an RFM score of 113 Cable Sports Inc. with an RFM score of 545 WindyRiver Sports with an RFM score of 225
answer
Goalkeeper with an RFM score of 551
question
75. U.S. Steel Corp. is a well-known steel manufacturing company. SAMCROW, one of the customers of U.S. Steel Corp. holds an RFM score of 111. Which of the following characteristics relates SAMCROW with its RFM score? SAMCROW has ordered recently and orders frequently, but it orders the least expensive goods. SAMCROW has not ordered anything for a while, but when it did order in the past, it ordered frequently, and its orders were of the highest monetary value. SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items. SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods. SAMCROW has ordered recently, but orders infrequently, and it orders the most expensive goods.
answer
SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items.
question
76. The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format. accurate informal specific dynamic precise
answer
dynamic
question
77. In ________, statistical techniques can identify groups of entities that have similar characteristics. regression analysis cluster analysis supervised data mining neural networks metadata matching
answer
cluster analysis
question
78. Which of the following is an example of a measure in an OLAP report? customer type purchase date sales region average cost customer location
answer
average cost
question
When an area code changes the phone number for a given customer before the change will not match the customer's number afterward. This is an example of ________. Missing values Inconsistent data Dirty data Data not integrated Septic data
answer
Inconsistent data
question
________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction. Data optimization Database normalization Data mining Data warehousing Data clustering
answer
Data mining
question
A data mart is larger than a data warehouse. True False
answer
False
question
Problematic operational data is termed as ________. Metadata Rough data Dirty data Grandular data Septic data
answer
Dirty data
question
A sales report that is current at the time the user accessed it on a Web server is an example of a(n) ________. Static report Dynamic report Expert system Hybrid market report Temporal report
answer
Dynamic report
question
In expert systems, the programs that process a set of rules are called expert systems shells. True False
answer
True
question
Which of the following observations concerning expert systems is TRUE? These systems are not affected by any changes made to it. These systems have lived up to the high expectations set by their name. These systems are easy to develop and maintain.Correc These systems encode human knowledge in the form of If/Then rules. These systems are typically used by experts.
answer
These systems encode human knowledge in the form of If/Then rules.
question
Which of the following is an example of a measure in an OLAP report? customer type purchase date sales region average cost customer location
answer
average cost
1 of 86

Unlock all answers in this set

Unlock answers (82)
question
1. Which of the following accurately defines a dimension in an OLAP report? It is a characteristic of a measure It is an item that is processed in the OLAP report It is a data item of interest It is referred to a decision tree It is a branch in a decision tree
answer
It is a characteristic of a measure
question
2. Which of the following statements is TRUE about unsupervised data mining? Analysts do not create a model or hypothesis before running the analysis Neural networks are a popular unsupervised data mining application Unsupervised data mining requires tools such as regression analysis Data miners develop a model prior to the analysis and apply statistical techniques to data Hypotheses must be made before running the analysis
answer
Analysts do not create a model or hypothesis before running the analysis
question
3. In the context of knowledge management systems, ________ are rule-based systems that encode human knowledge in the form of If/Then rules. Expert networks Expert systems Intelligent systems Decision-making systems Waterfall systems
answer
Expert systems
question
4. ________ is the process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need it. Intellectual property protection Knowledge management Business process reengineering Repository management Industrial information exchange
answer
Knowledge management
question
5. ________ is defined as information containing patterns, relationships, and trends of various forms of data. Process mining Business process management Business intelligence Spatial intelligence Pattern recognition
answer
Business intelligence
question
6. Which of the following techniques determine sales patterns? Regression analysis Market-basket analysis Neural networks Cluster analysis Seasonal grouping
answer
Market-basket analysis
question
7. Which of the following is an example of a supervised data mining technique? Cluster analysis Market-basket analysis Regression analysis Click streaming Metadata matching
answer
Regression analysis
question
8. A decision tree analysis is a supervised data mining technique. True False
answer
False
question
9. A data ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of the business. Mart Mine Cube Model Conduit
answer
Mart
question
10. Data warehouses may include data that is purchased from outside sources. True False
answer
True
question
11. Which of the following statements is TRUE of source data for a business intelligence (BI) system? It refers to the organization's metadata It refers to data that the organization purchases from data vendors It refers to the detailed level of data It refers to the hierarchical arrangement of criteria that predict a classification or a value It refers to the relative strength of data's predictive capabilities
answer
It refers to data that the organization purchases from data vendors
question
12. An advantage of OLAP reports is their ability to let users drill down into the data True False
answer
True
question
13. A(n) ________ is a complicated set of possibly nonlinear equations. Data warehouse Neural network Expert system Online analytical processing (OLAP) cube Artificial intelligence
answer
Neural network
question
14. A data mart is larger than a data warehouse True False
answer
False
question
15. Which of the following terms is used as a synonym for data mining? Regression analysis Data warehousing Knowledge discovery in databases (KDD) Parallel processing in database (PPD) Data spelunking
answer
Knowledge discovery in databases (KDD)
question
16. ________ analysis is a way of analyzing and ranking customers according to their purchase patterns. Regression CRM Market-basket RFM Cluster analysis
answer
RFM
question
17. Report can change its format. Which term implies this capability? Processing Analytical Dimension Online Alteration
answer
Online
question
18. ________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge. Decision Support Systems (DSS) Online Analytical Processing (OLAP) systems Content Management Systems (CMS) Data Transfer Protocols (DTP) Document Delivery System (DDS)
answer
Content Management Systems (CMS)
question
19. Expert systems are rule-based systems that encode human knowledge in the form of If/Then rules. True False
answer
True
question
20. Data mining is the application of statistical techniques to find patterns and relationships among data for classification and prediction. True False
answer
True
question
21. ________ refers to the source, format, assumptions and constraints, and other facts about the data. Clickstream data Dimensional data Outsourced data Metadata Attributed data
answer
Metadata
question
22. Push publishing can deliver results according to a schedule or as a result of an event or particular data condition. True False
answer
True
question
23. OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data. True False
answer
True
question
24. Knowledge management was done only after the advent of social media. True False
answer
False
question
25. Which of the following observations about RFM and OLAP reports is TRUE? RFM reports are more generic than OLAP reports OLAP reports are more dynamic than RFM reports RFM reports have measures and dimensions RFM reports can drill down into the data to a greater extent than OLAP reports RFM reports are more easily manipulated than OLAP reports
answer
OLAP reports are more dynamic than RFM reports
question
26. Samuel, a researcher, deduces that single women between the ages of 25 and 30, who usually live in the suburbs and make thrifty purchases, prefer a particular brand of washing machines. In this case, Samuel uses ________ to understand customer behavior. Supervised data mining Cluster analysis Neural networks Market-basket analysis Metadata matching
answer
Cluster analysis
question
27. Which of the following is a fundamental category of business intelligence (BI) analysis? Automation Encapsulation Data hiding Data mining Cataloging
answer
Data mining
question
28. ________ is a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence. An OLAP application A reporting application A NoSQL application A trans enterprise application A classful application
answer
A reporting application
question
29. Matt, a sales analyst, predicts the sale of luxury cars by formulating an equation that uses variables such as the customer's age and monthly salary. Which of the following methods does Matt use in this case? BigData analysis Regression analysis Market-basket analysis Cluster analysis Analytical hierarchical analysis
answer
Regression analysis
question
30. In ________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model. Cluster analysis Unsupervised data mining Supervised data mining Click streaming Metadata matching
answer
Supervised data mining
question
31. ________ is a concept that computer systems will become sophisticated enough that they can adapt and create their own software and hence adapt their behavior without human assistance. Expert system The Singularity Knowledge management Business intelligence systems Moore's Law
answer
The Singularity
question
Cluster analysis is used to identify groups of entities that have similar characteristics True False
answer
True
question
It is better to have data with too coarse a granularity than too fine. True False
answer
False
question
In expert systems, the programs that process a set of rules are called expert system shells. True False
answer
True
question
A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves. Data link layer Data mine Data warehouse Data model Data bus
answer
Data warehouse
question
36. Data mart is another term used for a data warehouse. True False
answer
False
question
37. ________ requires the user to request business intelligence (BI) results. Push publishing Pull publishing Desktop publishing Accessible publishing Pulse publishing
answer
Pull publishing
question
Business intelligence (BI) systems have five standard components called hardware, software, data, procedures and people. True False
answer
True
question
Operational data is structured for fast and reliable transaction processing. True False
answer
True
question
40. In an unsupervised data mining technique, analysts do not create a model or hypothesis before running the analysis. True False
answer
True
question
41. An ________ and an OLAP report are the same thing. OLAP measure OLAP cube OLAP dimension OLAP array OLAP permutation
answer
OLAP cube
question
42. A particular BI analysis might require data from an ERP system, an e-commerce system, and a social networking application, but such a data collection will likely have relationships that are not represented in primary key/foreign key relationships. This is an example of ________. Missing values Inconsistent data Dirty data Data not integrated Septic data
answer
Data not integrated
question
43. Regression analysis measures the effect of a set of variables on another variable. True False
answer
True
question
44. A ________ is a hierarchical arrangement of criteria that predict a classification or a value. Value chain Cluster analysis Decision tree Neural network Sync path
answer
Decision tree
question
45. ________ includes a query language titled Pig. MapReduce Hadoop RFM Analysis Online analytical processing (OLAP) Korn shell
answer
Hadoop
question
46. ________ is a technique for harnessing the power of thousands of computers working in parallel. RFM analysis MapReduce Granularity Reposition Big data looping
answer
MapReduce
question
47. An OLAP report has measures and dimensions. Which of the following is an example of a dimension? Total sales Average sales Sales region Average cost Average net sales
answer
Sales region
question
48. In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________. Confidence Support Granularity Lift Loop
answer
Lift
question
49. ________ is the application of social media and related applications for the management and delivery of organizational knowledge resources. Business intelligence server management Hyper-social knowledge management Knowledge management protocol Online analytical processing Proto-social information management
answer
Hyper-social knowledge management
question
50. Which of the following statements is TRUE about data marts? A data mart is like a distributor in a supply chain, while a data warehouse can be compared to a retail store. Data mart users possess the data management expertise that data warehouse employees have. Data marts address the needs of a particular department or functional area of a business. Data marts are larger than data warehouses. Data marts contain only metadata for data warehouses.
answer
Data marts address the needs of a particular department or functional area of a business.
question
51. Which of the following is a basic operation used by reporting applications to produce business intelligence? Coalescing Transposing Dispersing Calculating Diffusing
answer
Calculating
question
52. Hadoop is an open-source program supported by the Apache Foundation that implements MapReduce on potentially thousands of computers. True False
answer
True
question
53. OLAP stands for ________. Online analytical processing Object-based lead analysis procedure Object-oriented analytical protocol Organizational lead analysis process Optimal linear analytical processing
answer
Online analytical processing
question
54. Granularity is a term that refers to the level of detail represented by the data. True False
answer
True
question
55. Judy is analyzing weekly sales transactions at a supermarket. She finds that the support value for bed sheets and pillow covers is 0.9. Given this information, which of the following statements is TRUE? The sale of bedsheets and pillow covers is lower than other items. Customers who buy bedsheets usually also buy pillow covers. The supermarket carries a large stock of bedsheets and pillow covers. Customers who buy bedsheets rarely also buy pillow covers. The sales of bed sheets far exceeds the sales of pillow covers.
answer
Customers who buy bedsheets usually also buy pillow covers.
question
56. The three primary activities in the business intelligence (BI) process are to acquire data, perform analysis, and publish results. True False
answer
True
question
57. Ajax Inc. is one of the customers of a well-known linen manufacturing company. Ajax has not ordered linen in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. Under the given circumstances, Ajax is most likely to have an RFM score of ________. 155 511 555 151 515
answer
155
question
58. ________ is an employee directory that includes not only the standard name, email, phone, and address but also organizational structure and expertise. A data library A data-linked library A subscriber directory A static directory A rich directory
answer
A rich directory
question
59. Which of the following phenomena states that the more attributes there are, the easier it is to build a model that fits the sample data? Attribute paradox Curse of dimensionality Uncertainty principle Economies of scale Murphy's law
answer
Curse of dimensionality
question
60. ________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data. Data entry Data acquisition Data mining Data encryption Data scrubbing
answer
Data acquisition
question
61. Knowledge management (KM) benefits organizations because it ________. Allows distributors to work within the company premises Allows suppliers to work according to the organizational policies Enables employees to solve problems and rectify mistakes later Improves process quality and increases team strength Improves data integrity, transmission, and value
answer
Improves process quality and increases team strength
question
62. An OLAP cube and an OLAP report are the same thing. True False
answer
True
question
63. BI servers use ________ to determine what results to send to which users and on which schedule. Expert systems Metadata RSS feeds Neural networks IP logs
answer
Metadata
question
64. Capturing customers' clicking behavior is referred to as ________. Clickstream data Dimensional data Outsourced data Metadata Attributed data
answer
Clickstream data
question
65. In the context of knowledge management systems, ________ are rule-based systems that encode human knowledge in the form of If/Then rules. Expert networks Expert systems Intelligent systems Decision-making systems Waterfall systems
answer
Expert systems
question
66. ________ delivers business intelligence to users without any request from the users. Push publishing Pull publishing Desktop publishing Accessible publishing Pulse publishing
answer
Push publishing
question
67. Opezim Plastics has been supplying raw materials to JM Toys for five years. JM Toys has an RFM score of 121. With reference to the score, how should the sales team at Opezim respond to JM Toys? The sales team should contact JM Toys immediately. The sales team should let go of JM Toys, for the loss will be minimal. The sales team should attempt to up-sell more expensive goods to JM Toys. The sales team should spend more time with JM Toys. The sales team should attempt to sell directly to the CEO.
answer
The sales team should let go of JM Toys, for the loss will be minimal.
question
68. In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X." Cross-selling Value added selling Break-even Double-sales Quid pro quo
answer
Cross-selling
question
69. The viewer of an OLAP report can change its format. Which term implies this capability? Processing Analytical Dimension Online Alteration
answer
Online
question
70. A business intelligence (BI) server extends alert/RSS functionality to support user subscriptions. True False
answer
True
question
71. Dynamic reports are business intelligence (BI) documents that are updated at the time they are requested. True False
answer
True
question
72. In market-basket terminology, ________ describes the probability that two items will be purchased together. support confidence lift dimension connection
answer
support
question
73. ________ analysis is a way of analyzing and ranking customers according to their purchasing patterns. Regression CRM Market-basket RFM Cluster analysis
answer
RFM
question
74. Achilles Gear has four major retail customers. Based on the following RFM scores of these customers, the sales team at Achilles' should attempt to up-sell more expensive sporting goods to ________. Five Star Stores with an RFM score of 214 Goalkeeper with an RFM score of 551 Pelican Stores with an RFM score of 113 Cable Sports Inc. with an RFM score of 545 WindyRiver Sports with an RFM score of 225
answer
Goalkeeper with an RFM score of 551
question
75. U.S. Steel Corp. is a well-known steel manufacturing company. SAMCROW, one of the customers of U.S. Steel Corp. holds an RFM score of 111. Which of the following characteristics relates SAMCROW with its RFM score? SAMCROW has ordered recently and orders frequently, but it orders the least expensive goods. SAMCROW has not ordered anything for a while, but when it did order in the past, it ordered frequently, and its orders were of the highest monetary value. SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items. SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods. SAMCROW has ordered recently, but orders infrequently, and it orders the most expensive goods.
answer
SAMCROW has not ordered anything for a while and it did not order frequently, but when it did order, it bought the least expensive items.
question
76. The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format. accurate informal specific dynamic precise
answer
dynamic
question
77. In ________, statistical techniques can identify groups of entities that have similar characteristics. regression analysis cluster analysis supervised data mining neural networks metadata matching
answer
cluster analysis
question
78. Which of the following is an example of a measure in an OLAP report? customer type purchase date sales region average cost customer location
answer
average cost
question
When an area code changes the phone number for a given customer before the change will not match the customer's number afterward. This is an example of ________. Missing values Inconsistent data Dirty data Data not integrated Septic data
answer
Inconsistent data
question
________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction. Data optimization Database normalization Data mining Data warehousing Data clustering
answer
Data mining
question
A data mart is larger than a data warehouse. True False
answer
False
question
Problematic operational data is termed as ________. Metadata Rough data Dirty data Grandular data Septic data
answer
Dirty data
question
A sales report that is current at the time the user accessed it on a Web server is an example of a(n) ________. Static report Dynamic report Expert system Hybrid market report Temporal report
answer
Dynamic report
question
In expert systems, the programs that process a set of rules are called expert systems shells. True False
answer
True
question
Which of the following observations concerning expert systems is TRUE? These systems are not affected by any changes made to it. These systems have lived up to the high expectations set by their name. These systems are easy to develop and maintain.Correc These systems encode human knowledge in the form of If/Then rules. These systems are typically used by experts.
answer
These systems encode human knowledge in the form of If/Then rules.
question
Which of the following is an example of a measure in an OLAP report? customer type purchase date sales region average cost customer location
answer
average cost