Exam 3 Part 2b – Flashcards
Unlock all answers in this set
Unlock answersquestion
A credit card provider uses a software to determine the likelihood of customers defaulting on their payments. The software assigns a credit score to each customer based on their past transactional records. This software is an example of a ________ system. A) project management B) business intelligence C) collaboration D) budgeting
answer
B) business intelligence
question
Which of the following statements is true about business intelligence systems? A) They help identify patterns in mountains of data. B) Their use by private organizations is restricted by law. C) They require highly trained analysts to uncover data patterns. D) They are expensive to acquire due to the rising cost of data storage.
answer
A) They help identify patterns in mountains of data
question
Which of the following is an effectiveness objective of the BI process? A) storing and retrieving data B) assessing current conditions C) working with budget constraints D) staying within time limits
answer
B) assessing curent conditions
question
Which of the following is an efficiency objective of the BI process? A) informing business personnel B) assessing current conditions C) predicting future events D) meeting time constraints
answer
D) meeting time constraints
question
Which of the following statements is true of a BI system? A) A BI server is capable of delivering output in a variety of formats. B) Operational databases are incompatible for use with BI systems. C) Data collected for BI systems are unsuitable for storage in data warehouses. D) General-purpose BI software is used irrespective of the analysis method employed.
answer
A) A BI server is capable of delivering output in a variety of formats
question
The special repository for business intelligence applications is called a ________. A) data warehouse B) data matrix C) data array D) data set
answer
A) data warehouse
question
In BI terms, operational databases are often referred to as ________. A) data warehouses B) online transactional processing systems C) data matrices D) online analytical processing systems
answer
B) online transactional processing systems
question
Which of the following is referred to as an online analytical processing system? A) the data set B) the traditional database C) the operational database D) the data warehouse
answer
D) the data warehouse
question
Which of the following statements is true of the reporting process? A) It applies simple operations to reveal patterns in data. B) It creates unstructured reports and delivers them to users. C) It involves the use of sophisticated statistical techniques. D) Its objective is better prediction.
answer
A) It applies simple operations to reveal patterns in data
question
Which of the following types of analyses is used in the reporting process? A) market basket analysis B) RFM analysis C) cluster analysis D) regression analysis
answer
B) RFM analysis
question
A digital dashboard is a(n) ________. A) electronic input device used in business intelligence systems B) information system that is used to enter data into databases C) visualization that is customized for a particular user D) digital device in the central processing unit of a BI system
answer
C) visualization that is customized for a particular user
question
A(n) ________ analysis is used to analyze and rank customers according to their purchasing patterns. A) regression B) cluster C) RFM D) market basket
answer
C) RFM
question
Which of the following statements is true about RFM analysis? A) It ranks customers based on their purchasing power. B) It uses more than a single attribute to sort the customers. C) It uses unsorted data to produce an RFM score. D) It identifies groups of entities that have similar characteristics.
answer
B) It uses more than a single attribute to sort the customers
question
The supermarket from which Robert purchases groceries gives him an RFM score of 115 (R=1; F=1; M=5, on a scale of 1 to 5). Based on this information, which of the following is a valid conclusion? A) Robert recently made a big purchase at the supermarket. B) Robert does not shop frequently at the supermarket. C) Robert has not purchased anything from the supermarket recently. D) Robert frequently purchases inexpensive items from the supermarket.
answer
D) Robert frequently purchases inexpensive items from the supermarket
question
An RFM score of 555 (R=5; F=5; M=5, on a scale of 1 to 5) assigned to a customer indicates that the customer ________. A) buys expensive items frequently B) has not purchased anything recently but buys frequently C) has not purchased anything recently D) buys inexpensive items frequently
answer
C) has not purchased anything recently
question
In an RFM analysis, what will be the M score of a customer who spends the least amount of money, when rated on a scale of 1 to 5? A) 5 B) 1 C) 0 D) 2
answer
A) 5
question
________ provides the ability to analyze data using basic operations such as sorting, grouping, filtering, and calculating but, the operation is typically repeated. A) OLAP B) PERT C) Market basket analysis D) Regression analysis
answer
A) OLAP
question
Drilling down into data means ________. A) changing the format of stored data B) grouping data into clusters C) dividing the data into more detail D) downsizing a database by deleting files
answer
C) dividing the data into more details
question
An OLAP measure is a(n) ________. A) characteristic of an OLAP report B) data item to be processed in an OLAP report C) attribute of an OLAP report D) RMF score for an OLAP report
answer
B) data item to be processed in an OLAP report
question
An OLAP ________ is a characteristic or attribute of an info cube. A) cube B) dimension C) dashboard D) cluster
answer
B) dimension
question
An OLAP report that displays information using three dimensions is called a(n) ________. A) warehouse B) dashboard C) cluster D) info cube
answer
D) info cube
question
An organization uses a business intelligence system to predict products that tend to be purchased together. This is an example of a(n) ________ process. A) reporting B) information extracting C) evaluating D) data mining
answer
D) data mining
question
Which of the following statements is true regarding the data mining process? A) It consolidates data into multiple data warehouses. B) Its activities are entirely different from those in the reporting process. C) It uses simple statistical techniques for data analysis. D) Its objective is better prediction of various outcomes.
answer
D) Its objective is better prediction of various outcomes.
question
Regression analysis is an example of a ________ analysis process. A) data mining B) market basket C) reporting D) visualization
answer
A) data mining
question
________ analysis is a type of data mining analysis which measures the impact of a set of variables on another variable. A) Market basket B) RFM C) Cluster D) Regression
answer
D) Regression
question
Regression analysis is used to ________. A) rank customers according to their purchasing patterns B) predict future performance C) identify groups of entities that have similar characteristics D) perform basic operations
answer
B) predict future performance
question
Which of the following is used to predict cross-selling opportunities? A) RFM analysis B) cluster analysis C) regression analysis D) market basket analysis
answer
D) market basket analysis
question
A retail store wants to identify the types of products that they should bundle together on sale. Which of the following types of analysis would be most suitable for this purpose? A) market basket B) RFM C) cluster D) OLAP
answer
A) market basket
question
Selling products in addition to what customers request is called ________. A) hard-selling B) down-selling C) up-selling D) cross-selling
answer
D) cross-selling
question
Margin Retails, a local supermarket, stocks up aftershave products next to the shaving creams predicting that consumers purchasing the shaving creams are most likely to purchase the aftershaves. In this case Margin's analysis technique is typically based on ________. A) hard-selling B) soft-selling C) cross-selling D) up-selling
answer
C) cross-selling
question
Which of the following is an example of unsupervised data mining? A) OLAP analysis B) RFM analysis C) market basket analysis D) regression analysis
answer
C) market basket analysis
question
Which of the following is true about unsupervised data mining? A) Activities are different from a reporting activity. B) Analysts do not create a model before running the analysis. C) Statistical analysis is applied to data prior to the analysis. D) Statistical tools used are simple and easy to understand.
answer
B) Analysts do not create a model before running the analysis
question
Which of the following is an example of supervised data mining? A) regression analysis B) PERT C) CPM D) market basket analysis
answer
A) regression analysis
question
Which of the following is true about supervised data mining? A) Statistics used are simple and easy. B) It is used for predicting cross-selling opportunities. C) Analysts develop a model prior to the analysis. D) Patterns found are explained by a hypothesis.
answer
C) Analysts develop a model prior to the analysis
question
________ is the creation of images or diagrams that communicate a data pattern in a highly readable format. A) Phishing B) Simulation C) Visualization D) Augmented reality
answer
C) Visualization
question
A sales manager uses a bar chart to describe sales projections to his associates. This scenario exemplifies ________. A) phishing B) visualization C) simulation D) augmented reality
answer
B) visualization
question
Which of the following processes supported by BI information systems refers to the selection of a choice among available options and can be done individually or in a group? A) decision making B) knowledge management C) phishing D) pharming
answer
A) decision making
question
________ is a rule-based system that acquires and stores human knowledge in the form of If/Then rules. A) MapReduce B) Disparate system C) Expert system D) Big Data
answer
C) Expert system
question
Which of the following is an objective of the NBO process? A) to create value from intellectual capital and to share knowledge B) to predict the number of customers who will accept an offer C) to select a choice among a set of available options D) to connect the power of multiple computers working in parallel
answer
B) to predict the number of customers who will accept an offer
question
Which of the following is a feature of Big Data? A) It is accessed slowly due to its large size. B) It consists of unstructured data. C) Its datasets are at least a petabyte in size. D) It is generated slowly.
answer
C) Its datasets are at least a petabyte in size.
question
Because of the massive volume of Big Data, it has to be processed using the ________. A) traditional technique B) relational database C) SQL database D) MapReduce technique
answer
D) MapReduce technique
question
________ is an open-source program supported by the Apache Foundation that implements MapReduce on potentially thousands of computers. A) Hadoop B) HTTP Server C) Struts D) ActiveMQ
answer
A) Hadoop
question
The database operations in a MapReduce system are slow as the system keeps the data in ________. A) magnetic tapes B) temporary memory C) secondary storage D) main memory
answer
C) secondary storage
question
With the introduction of SAP HANA, the database operations of Big Data systems are faster when compared to MapReduce systems. Which of the following statements justifies this improvement? A) The system now uses a relational database technology. B) SQL statements are used to access data from secondary storage. C) A solid-state memory device is used to store data. D) The tasks in the system are divided into multiple servers.
answer
C) A solid-state memory device is used to store data.
question
Data that are problematic for business intelligence are termed ________. A) clustered data B) intrinsic data C) dirty data D) granular data
answer
C) dirty data
question
An organization uses SAP financial management software to store accounting details and Microsoft CRM software to record customer transactions. Managers face problems when they have to make decisions based on both sets of data, as the data are stored on two different platforms. Such data are referred to as ________ data. A) nonintegrated B) dirty C) granular D) meta
answer
A) nonintegrated
question
Granularity refers to the ________. A) problems that persist within data B) level of detail of the data C) inconsistencies within data D) patterns derived from operational data
answer
B) level of detail of the data
question
________ include the activities of a customer on a Web site. A) Real-time data B) Clickstream data C) Spam mails D) Rootkits
answer
B) Clickstream data
question
Which of the following BI-related problems is most commonly associated with organizational leaders? A) mistaking data for information B) resisting BI use because the system may change their jobs C) underestimating the cost of producing a BI report D) overselling the potential of a BI system
answer
D) overselling the potential of a BI system
question
The SAP OLAP database is referred to as ________. A) online transactional system B) operational database C) business object D) data warehouse
answer
D) data warehouse
question
The collection of operational process data that SAP uses is referred to as ________. A) online analytical processing B) market basket analysis C) data harvesting D) online transactional processing
answer
D) online transactional processing
question
Which of the following is a factor that will impact the growth of business intelligence in the future? A) mobile devices B) structured data sources C) legacy systems D) scarce data volume
answer
A) mobile devices
question
Which of the following is most likely to cause a technology backlash with the growth of business intelligence? A) communication costs B) consumer privacy C) data volume D) unstructured data
answer
B) consumer privacy
