Deck 11: Business Intelligence and Is

Question 1

Typically in a BI system,analysis begins with a massive volume of data being scaled down to a small set if the analysis looks promising.

Answer 1

False

Question 2

To use BI applications,businesses should avoid depending on traditional transactional databases.

Answer 2

True

Question 3

Data mining is the first step of a BI activity supported by business intelligence information systems.

Answer 3

False

Question 4

BI systems restrain from combining operational data with data from other sources before storing them in the repository.

Question 5

When users do BI analysis by themselves,it is called self-service BI.

Question 6

One of the applications of the data mining process is to predict products that tend to be purchased together.

Question 7

An RFM analysis considers how recently a customer has ordered and how much the customer has spent.

Question 8

BI systems are reducing their capacity to help businesses identify important patterns in data.

Question 9

The data mining process can predict the likelihood of various outcomes of a particular event.

Question 10

A BI server is used by an analyst to analyze data and produce the output.

Question 11

The data mining process has the same activities as the reporting process.

Question 12

A typical business intelligence database is large in volume.

Question 13

Market basket analysis is a technique used to segment the customer base.

Question 14

Data that is analyzed once using slicing and dicing cannot be reanalyzed.

Question 15

The objective of most business intelligence processes is to inform.

Question 16

The primary objective of a reporting process is predicting patterns and relationships in data.

Question 17

The efficiency objective of business intelligence is to inform someone in the business.

Question 18

With an OLAP report,it is possible to drill down into data.

Question 19

A data warehouse is specially designed to sort and retrieve large volumes of data.

Question 20

Operational data are often structured in a way that readily supports BI analysis.

Question 21

With the advent of business intelligence,companies can more accurately predict the rate that offers will be accepted.

Question 22

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

Question 23

Traditional techniques cannot be used to process Big Data.

Question 24

MapReduce systems access the data stored in the secondary storage using SQL systems.

Question 25

Leaders can contribute to BI pushback by overselling the potential of a BI system.

Question 26

Big Data information systems are similar in data and software in comparison to routine-sized databases.

Question 27

Using the MapReduce techniques,pieces of data are integrated to form a huge chunk of information.

Question 28

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.

Question 29

Market basket analysis predicts cross-selling opportunities.

Question 30

Business intelligence will continue to expand as Big Data matures.

Question 31

Rules cannot be programmed into business intelligence applications.

Question 32

The decision-making process is one of the most frequently occurring processes in an organization.

Question 33

Organizations implementing SAP can choose to write additional code to accomplish tasks that SAP does not provide.

Question 34

The operational data collected by SAP is known as business objects.

Question 35

With unsupervised data mining,analysts typically create a model or hypothesis before running the analysis.

Question 36

Granularity refers to the inconsistencies and missing values that exist within data.

Question 37

For BI applications,a few missing data points is better than no data at all.

Question 38

Clickstream data is used to track everything the customer does at a Web site.

Question 39

Dashboards can be used to monitor business processes and indicate abnormal conditions with clear signs.

Question 40

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

Question 41

An OLAP report that displays information using three dimensions is called a(n)________.

A) warehouse
B) dashboard
C) cluster
D) info cube

Question 42

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

Question 43

An OLAP ________ is a characteristic or attribute of an info cube.

A) cube
B) dimension
C) dashboard
D) cluster

Question 44

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

Question 45

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.

Question 46

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

Question 47

________ 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

Question 48

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.

Question 49

A(n)________ analysis is used to analyze and rank customers according to their purchasing patterns.

A) regression
B) cluster
C) RFM
D) market basket

Question 50

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.

Question 51

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.

Question 52

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

Question 53

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

Question 54

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.

Question 55

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

Question 56

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

Question 57

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

Question 58

The special repository for business intelligence applications is called a ________.

A) data warehouse
B) data matrix
C) data array
D) data set

Question 59

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

Question 60

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

Question 61

Which of the following is used to predict cross-selling opportunities?

A) RFM analysis
B) cluster analysis
C) regression analysis
D) market basket analysis

Question 62

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

Question 63

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

Question 64

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.

Question 65

________ 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

Question 66

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

Question 67

Selling products in addition to what customers request is called ________.

A) hard-selling
B) down-selling
C) up-selling
D) cross-selling

Question 68

________ 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

Question 69

________ 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

Question 70

Which of the following is an example of supervised data mining?

A) regression analysis
B) PERT
C) CPM
D) market basket analysis

Question 71

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

Question 72

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

Question 73

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

Question 74

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.

Question 75

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

Question 76

Regression analysis is an example of a ________ analysis process.

A) data mining
B) market basket
C) reporting
D) visualization

Question 77

________ 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

Question 78

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.

Question 79

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

Question 80

Which of the following is an example of unsupervised data mining?

A) OLAP analysis
B) RFM analysis
C) market basket analysis
D) regression analysis