Deck 12: Business Intelligence and IS

Question 1

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

Answer 1

True

Question 2

Assessment,in business,means to be informed about the likelihood of future events.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

Although data numbers are growing at impressive rates,the five main sources of data
remain the same.

Question 6

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

Question 7

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.

Question 8

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

Question 9

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

Question 10

The objective of most business intelligence processes is to inform.

Question 11

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

Question 12

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

Question 13

A typical business intelligence database is large in volume.

Question 14

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

Question 15

Business intelligence is a process of acquiring,analyzing,and publishing data with an
objective of discovering or revealing patterns in data that will inform a businessperson.

Question 16

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

Question 17

There is no BI,no informing,without procedures.

Question 18

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

Question 19

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

Question 20

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

Question 21

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

Question 22

A common analogy for a Hadoop system is a data lake.

Question 23

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

Question 24

With Big Data,the auditing process no longer needs to sample a subset of transactions;
it can examine every transaction.

Question 25

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

Question 26

Market basket analysis predicts cross-selling opportunities.

Question 27

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

Question 28

With the advent Next Best Offer (NBO),companies can more accurately predict the rate that offers will be accepted.

Question 29

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

Question 30

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

Question 31

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

Question 32

Before BI,B2C businesses had to write their own code to acquire and analyze customer data.

Question 33

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

Question 34

Analysis of jet engine data has led to remarkable reductions in engine failures over the past several decades.

Question 35

NoSQL databases have data redundancy,fewer controls,and require
programming skills.

Question 36

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

Question 37

Many cities are using advances in Big Data to provide services that improve transportation safety and reduce vehicle emissions.

Question 38

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

Question 39

Traditional techniques cannot be used to process Big Data.

Question 40

HANA can be used only with unstructured NoSQL databases.

Question 41

Scalability means that BI servers are:

A) efficient
B) modular
C) compatible
D) operational

Question 42

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 43

Business intelligence will continue to expand as Big Data matures.

Question 44

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

Question 45

Which of these is not another name for business intelligence?

A) business analytics
B) data science
C) predictive analytics
D) big data applications

Question 46

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

Question 47

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 48

Which of the following statements is true of a BI system?

A) A BI server can deliver 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

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 50

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

Question 51

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 52

Many of the Internet of Things will use radio-frequency identification (RFID)technology,

Question 53

Like all ERP systems,SAP consolidates operational data in an OLTP database.

Question 54

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 55

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

Question 56

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 57

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

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

Question 58

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 59

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 60

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 61

Regression analysis is an example of a ________ analysis process.

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

Question 62

______________classifies opinions about a business,product,or service,typically as either positive or negative.

A) Market Basket Analysis (MBA)
B) RFM analysis
C) Sentiment analysis
D) regression analysis

Question 63

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

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

Question 64

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 65

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

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 68

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 69

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 70

________ 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 71

________ provides the ability to analyze data using basic operations such as sorting,grouping,filtering,and calculating but,the operation is typically repeated.

A) Slicing and Dicing
B) PERT
C) Market basket analysis
D) Regression analysis

Question 72

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

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

Question 73

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 74

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 75

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 76

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 77

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 78

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

A) text mining
B) RFM analysis
C) market basket analysis
D) regression analysis

Question 79

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 80

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

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