Question 1

An OLAP report has

Accepted Answer

A)  measures and dimensions. 
B)  averages. 
C)  dimensions. 
D)  measures and averages. 
E)  measures. 
A)  measures and dimensions. 
B)  averages. 
C)  dimensions. 
D)  measures and averages. 
E)  measures.

Question 2

OLAP provides the ability to sum,count,average,and perform other simple arithmetic operations on groups of data.

Accepted Answer

A) True 
 B)False

Question 3

With cluster analysis,analysts create a model or hypothesis before running the analysis.

Accepted Answer

A) True 
 B)False

Question 4

Billy Beane is generally credited with introducing

Accepted Answer

A)  new methods of scouting players for the National Hockey League. 
B)  scientific and statistical techniques that capture more data for major league baseball. 
C)  market-basket analysis in major leage baseball. 
D)  developing OLTP software. 
E)  real-time processing to business processes 
A)  new methods of scouting players for the National Hockey League. 
B)  scientific and statistical techniques that capture more data for major league baseball. 
C)  market-basket analysis in major leage baseball. 
D)  developing OLTP software. 
E)  real-time processing to business processes

Question 5

________ systems integrate data from a variety of sources,process that data,and produce and deliver formatted reports to users.

Accepted Answer

A)  Data-mining 
B)  Reporting 
C)  Web service 
D)  XML 
E)  RFP 
A)  Data-mining 
B)  Reporting 
C)  Web service 
D)  XML 
E)  RFP

Question 6

Clickstream data is often ___________ and much of it has to be discarded.

Accepted Answer

A)  incomplete or inaccurate data. 
B)  too coarse. 
C)  inconsistent data. 
D)  missing value. 
E)  too fine. 
A)  incomplete or inaccurate data. 
B)  too coarse. 
C)  inconsistent data. 
D)  missing value. 
E)  too fine.

Question 7

Experts in a communications company believe that cell phone usage on weekends is determined by the age of the customer and the number of months the customer has the cell phone account.Which of the following technique could be used to analyze the data?

Accepted Answer

A)  Regression analysis 
B)  Unsupervised data-mining 
C)  Neural networks 
D)  Cluster analysis 
E)  Market-based analysis 
A)  Regression analysis 
B)  Unsupervised data-mining 
C)  Neural networks 
D)  Cluster analysis 
E)  Market-based analysis

Question 8

Discovering patterns and relationships in data is the purpose of data mining.

Accepted Answer

A) True 
 B)False

Question 9

Operational data may not be suitable for more sophisticated analyses.What are the problems with operational data? What is a data warehouse and how is it designed to go beyond these issues?

Accepted Answer

Basic reports and simple OLAP analyses c

Question 10

A data warehouse contains a special database that stores the ________,which records its source,history,and format of the data.

Accepted Answer

A)  dimensional data 
B)  clickstream data 
C)  metadata 
D)  media format 
E)  dirty data 
A)  dimensional data 
B)  clickstream data 
C)  metadata 
D)  media format 
E)  dirty data

Question 11

Using specific examples,describe data granularity.

Accepted Answer

Data granularity refers to the

Question 12

________ create value from intellectual capital by collecting and sharing human knowledge of products,product uses,best practices,and other critical knowledge with employees,managers,customers,suppliers,and other who need it.

Accepted Answer

A)  CRM applications 
B)  Expert Systems 
C)  Business intelligence systems 
D)  Data mining systems 
E)  Knowledge management systems 
A)  CRM applications 
B)  Expert Systems 
C)  Business intelligence systems 
D)  Data mining systems 
E)  Knowledge management systems

Question 13

With supervised data mining,data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

Accepted Answer

A) True 
 B)False

Question 14

A data mart is a data collection that is created to address the needs of a particular business function,problem,or opportunity.

Accepted Answer

A) True 
 B)False

Question 15

Neural networks are a supervised data-mining technique.

Accepted Answer

A) True 
 B)False

Question 16

Data-mining techniques include

Accepted Answer

A)  supplier relationship management. 
B)  data warehousing. 
C)  data marting. 
D)  market basket analysis. 
E)  customer relationship management. 
A)  supplier relationship management. 
B)  data warehousing. 
C)  data marting. 
D)  market basket analysis. 
E)  customer relationship management.

Question 17

The hyper abundance of information is sometimes called

Accepted Answer

A)  data abundance. 
B)  Moore's Law. 
C)  the Ackoff principle. 
D)  information overload. 
E)  dirty data. 
A)  data abundance. 
B)  Moore's Law. 
C)  the Ackoff principle. 
D)  information overload. 
E)  dirty data.

Question 18

To realize a competitive advantage from data an organization must

Accepted Answer

A)  collect the data. 
B)  view data as a liability. 
C)  use the data to make better decisions. 
D)  view data as an asset. 
E)  analyze the data. 
A)  collect the data. 
B)  view data as a liability. 
C)  use the data to make better decisions. 
D)  view data as an asset. 
E)  analyze the data.

Question 19

Which of the following is an assumption about information systems that Ackoff disputed?

Accepted Answer

A)  Computer speed doubles every 18 months. 
B)  There is too much uncertainty in making any decision. 
C)  Managers have no problem making decisions if they get the data they need. 
D)  Managers that make decisions do not get irrelevant data. 
E)  There is too much information. 
A)  Computer speed doubles every 18 months. 
B)  There is too much uncertainty in making any decision. 
C)  Managers have no problem making decisions if they get the data they need. 
D)  Managers that make decisions do not get irrelevant data. 
E)  There is too much information.

Question 20

When an area code changes in a database,the phone number for a given customer before the change will not match the customer's number after the change.This is an example of

Accepted Answer

A)  too fine data. 
B)  too coarse data. 
C)  missing values. 
D)  incomplete or inaccurate data. 
E)  inconsistent data. 
A)  too fine data. 
B)  too coarse data. 
C)  missing values. 
D)  incomplete or inaccurate data. 
E)  inconsistent data.

An OLAP report has

OLAP provides the ability to sum,count,average,and perform other simple arithmetic operations on groups of data.

With cluster analysis,analysts create a model or hypothesis before running the analysis.

Billy Beane is generally credited with introducing

________ systems integrate data from a variety of sources,process that data,and produce and deliver formatted reports to users.

Clickstream data is often ___________ and much of it has to be discarded.

Experts in a communications company believe that cell phone usage on weekends is determined by the age of the customer and the number of months the customer has the cell phone account.Which of the following technique could be used to analyze the data?

Discovering patterns and relationships in data is the purpose of data mining.

Operational data may not be suitable for more sophisticated analyses.What are the problems with operational data? What is a data warehouse and how is it designed to go beyond these issues?

A data warehouse contains a special database that stores the ________,which records its source,history,and format of the data.

Using specific examples,describe data granularity.

________ create value from intellectual capital by collecting and sharing human knowledge of products,product uses,best practices,and other critical knowledge with employees,managers,customers,suppliers,and other who need it.

With supervised data mining,data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

A data mart is a data collection that is created to address the needs of a particular business function,problem,or opportunity.

Neural networks are a supervised data-mining technique.

Data-mining techniques include

The hyper abundance of information is sometimes called

To realize a competitive advantage from data an organization must

Which of the following is an assumption about information systems that Ackoff disputed?

When an area code changes in a database,the phone number for a given customer before the change will not match the customer's number after the change.This is an example of

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Database Design and Entity Relationships

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters

Exam 8: Decision Making and Business Intelligence

An OLAP report has

OLAP provides the ability to sum,count,average,and perform other simple arithmetic operations on groups of data.

With cluster analysis,analysts create a model or hypothesis before running the analysis.

Billy Beane is generally credited with introducing

________ systems integrate data from a variety of sources,process that data,and produce and deliver formatted reports to users.

Clickstream data is often ___________ and much of it has to be discarded.

Experts in a communications company believe that cell phone usage on weekends is determined by the age of the customer and the number of months the customer has the cell phone account.Which of the following technique could be used to analyze the data?

Discovering patterns and relationships in data is the purpose of data mining.

Operational data may not be suitable for more sophisticated analyses.What are the problems with operational data? What is a data warehouse and how is it designed to go beyond these issues?

A data warehouse contains a special database that stores the ________,which records its source,history,and format of the data.

Using specific examples,describe data granularity.

________ create value from intellectual capital by collecting and sharing human knowledge of products,product uses,best practices,and other critical knowledge with employees,managers,customers,suppliers,and other who need it.

With supervised data mining,data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

A data mart is a data collection that is created to address the needs of a particular business function,problem,or opportunity.

Neural networks are a supervised data-mining technique.

Data-mining techniques include

The hyper abundance of information is sometimes called

To realize a competitive advantage from data an organization must

Which of the following is an assumption about information systems that Ackoff disputed?

When an area code changes in a database,the phone number for a given customer before the change will not match the customer's number after the change.This is an example of

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Database Design and Entity Relationships

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters