Deck 9: Business Intelligence Systems

Question 1

BI analysis is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

Answer 1

False

Question 2

________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

A)Data manipulation
B)BI analysis
C)Publish results
D)Data acquisition

Answer 2

D

Question 3

The purchasing pattern of an individual never change.

Answer 3

False

Question 4

Project management is one of the few domains in which business intelligence is rarely used.

Question 5

Problem solving requires project management.

Question 6

________ requires users to request business intelligence results.

A)Push publishing
B)Pull publishing
C)Data acquisition
D)Data mining

Question 7

The three fundamental categories of BI analysis are reporting, data mining, and BigData.

Question 8

Which of the following statements is true of business intelligence (BI)systems?

A)Business intelligence systems are primarily used for developing software systems and data mining applications.
B)The four standard components of business intelligence systems are software, procedures, applications, and programs.
C)The software component of a business intelligence system is called an intelligence database.
D)Business intelligence systems analyze an organization's past performance to make predictions.

Question 9

What are the three primary activities in the business intelligence process?

Question 10

The data that an organization purchases from data vendors can act as the source data for a business intelligence system.

Question 11

________ process operational and other data in organizations to analyze past performance and make predictions.

A)Virtualization techniques
B)Live migration techniques
C)Business intelligence systems
D)Windowing systems

Question 12

________ is the process of delivering business intelligence to users without any request from the users.

A)Push publishing
B)Pull publishing
C)Data acquisition
D)Data mining

Question 13

How does business intelligence help marketers identify changes in the purchasing patterns of customers?

Question 14

As information systems, BI systems have three standard components.

Question 15

The patterns, relationships, and trends identified by BI systems are called business intelligence.

Question 16

The use of business intelligence (BI)for identifying changes in the purchasing patterns of customers is a labor-intensive process.

Question 17

Which of the following is a fundamental category of business intelligence (BI)analysis?

A)data acquisition
B)reporting
C)push publishing
D)pull publishing

Question 18

Which of the following activities in the business intelligence process involves delivering business intelligence to the knowledge workers who need it?

A)data acquisition
B)BI analysis
C)publish results
D)data mining

Question 19

Push publishing requires a user to request BI results.

Question 20

What are business intelligence systems?

Question 21

The source, format, assumptions and constraints, and other facts concerning certain data are called ________.

A)metadata
B)data structures
C)microdata
D)network packets

Question 22

The granularity in clickstream data is too coarse.

Question 23

If the granularity of certain data is too coarse, the data can be separated into constituent parts using statistical techniques.

Question 24

The use of an organization's operational data as the source data for a business intelligence system is not usually recommended because it ________.

A)is not possible to create reports based on operational data
B)is not possible to perform business intelligence analyses on operational data
C)requires considerable processing and can drastically reduce system performance
D)considers only the external data and not the internal data regarding the organization's functions

Question 25

The more attributes there are in a sample data, the easier it is to build a model that fits the sample data, but that is worthless as a predictor.Which of the following best explains this phenomenon?

A)the free rider problem
B)the curse of dimensionality
C)the tragedy of the commons
D)the zero-sum game

Question 26

A data warehouse is a facility for managing an organization's business intelligence data.

Question 27

Users in a data mart obtain data that pertain to a particular business function from a ________.

A)data room
B)data center
C)datasheet
D)data warehouse

Question 28

________ refers to the level of detail represented by data.

A)Abstraction
B)Granularity
C)Dimensionality
D)Aggregation

Question 29

External data purchased from outside resources are not included in data warehouses.

Question 30

Differentiate between push publishing and pull publishing.

Question 31

Problematic data are termed ________.

A)random data
B)macro data
C)vague data
D)dirty data

Question 32

Data inconsistencies can occur from the nature of a business activity.

Question 33

Placing business intelligence (BI)applications on operational servers can dramatically reduce system performance.

Question 34

Which of the following problems is particularly common for data that have been gathered over time?

A)wrong granularity
B)lack of integration
C)lack of consistency
D)missing values

Question 35

Which of the following statements is true of a data warehouse?

A)A data warehouse is larger than a data mart.
B)A data warehouse functions like a retail store in a supply chain.
C)Users in a data warehouse obtain data pertaining to a business function from a data mart.
D)Data analysts who work with a data warehouse are experts in a particular business function.

Question 36

A ________ is a facility for managing an organization's business intelligence data.

A)datasheet
B)dataspace
C)data warehouse
D)data table

Question 37

Data granularity refers to the amount of data represented by data.

Question 38

A ________ is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of a business.

A)data mart
B)data room
C)datasheet
D)dataspace

Question 39

Which of the following statements is true of data with granularity?

A)It can be too fine or too coarse and also have wrong granularity.
B)If granularity is too coarse, data can be made finer by summing and combining.
C)It is not possible to have a wrong granularity for a data.
D)If granularity is too coarse, data can be separated into constituent parts using regression.

Question 40

A ________ is designed to extract data from operational systems and other sources, clean the data, and store and catalog that data for processing by business intelligence tools.

A)data mart
B)data center
C)data room
D)data warehouse

Question 41

The curse of dimensionality states that the more attributes there are, the more difficult it is to build a model that fits the sample data.

Question 42

________ techniques emerged from the combined discipline of statistics, mathematics, artificial intelligence, and machine-learning.

A)Push publishing
B)Pull publishing
C)Data mining
D)Exception reporting

Question 43

Data marts are data collections that address the needs of a particular department or functional area of a business.

Question 44

________ are reports produced when something out of predefined bounds occurs.

A)Exception reports
B)Static reports
C)Dynamic reports
D)Subscription reports

Question 45

What are the functions of a data warehouse?

Question 46

________ is the process of sorting, grouping, summing, filtering, and formatting structured data.

A)Push publishing
B)Publish results
C)Cloud computing
D)Reporting analysis

Question 47

Data analysts who work with data warehouses are experts at data management, data cleaning, data transformation, and data relationships.

Question 48

An advantage of data warehouses is the low cost required to create, staff, and operate them.

Question 49

Explain the functions of a data warehouse.

Question 50

What is clickstream data?

Question 51

The goal of ________, a type of business intelligence analysis, is to create information about past performance.

A)push publishing
B)data mining
C)reporting analyses
D)BigData

Question 52

Which of the following refers to data in the form of rows and columns?

A)granulated data
B)structured data
C)micro data
D)coarse data

Question 53

Data marts are usually larger than data warehouses.

Question 54

Users in a data mart obtain data that pertain to a particular business function from a data warehouse.

Question 55

Explain the curse of dimensionality.

Question 56

Which of the following statements is true of unsupervised data mining?

A)Analysts apply unsupervised data mining techniques to estimate the parameters of a developed model.
B)Analysts create hypotheses only after performing an analysis.
C)Regression analysis is the most commonly used unsupervised data mining technique.
D)Data miners develop models prior to performing an analysis.

Question 57

________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.

A)Data encryption
B)Data warehousing
C)Data mining
D)Data decryption

Question 58

What is data granularity?

Question 59

How is a data warehouse different from a data mart?

Question 60

________ is an unsupervised data mining technique in which statistical techniques identify groups of entities that have similar characteristics.

A)Cluster analysis
B)Content indexing
C)Regression analysis
D)Cloud computing

Question 61

In the ________ phase, a BigData collection is broken into pieces and hundreds or thousands of independent processors search these pieces for something of interest.

A)crash
B)break
C)reduce
D)map

Question 62

Structured data is data in the form of rows and columns.

Question 63

________ is an open source program supported by the Apache Foundation that manages thousands of computers and that implements MapReduce.

A)Hadoop
B)BigData
C)Linux
D)Apache Wave

Question 64

The results generated in the map phase are combined in the ________ phase.

A)pig
B)control
C)reduce
D)construct

Question 65

BigData refers to data that have great variety and may have structured data as well as different formats.

Question 66

Which of the following statements is true of BigData?

A)BigData contains only structured data.
B)BigData has low velocity and is generated slowly.
C)BigData cannot store graphics, audio, and video files.
D)BigData refers to data sets that are at least a petabyte in size.

Question 67

What is unsupervised data mining?

Question 68

Cluster analysis measures the impact of a set of variables on another variable.

Question 69

Regression analysis is used to identify groups of entities that have similar characteristics.

Question 70

________ is used to measure the impact of a set of variables on another variable during data mining.

A)Cluster analysis
B)Context indexing
C)Cloud computing
D)Regression analysis

Question 71

BigData has low velocity and is generated slowly.

Question 72

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

Question 73

Regression analysis is used in ________.

A)progress reporting
B)bug reporting
C)supervised data mining
D)unsupervised data mining

Question 74

BigData has volume, velocity, and variation characteristics that far exceed those of traditional reporting and data mining.

Question 75

What is data mining?

Question 76

In the case of ________, data miners develop models prior to conducting analyses and then apply statistical techniques to data to estimate parameters of the models.

A)pull publishing techniques
B)supervised data mining
C)push publishing techniques
D)unsupervised data mining

Question 77

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

Question 78

Explain supervised data mining.

Question 79

Which of the following statements is true of Hadoop?

A)Hadoop is written in C++ and runs on Linux.
B)Hadoop includes a query language called Big.
C)Hadoop is an open source program that implements MapReduce.
D)Technical skills are not required to run and use Hadoop.

Question 80

Reporting analysis is used primarily for classifying and predicting BI data.