Question 1

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

Accepted Answer

A)  Online database processing (OLDP) 
B)  Online transaction processing (OLTP) 
C)  Online data processing (OLDP) 
D)  Online record processing (OLRP) 
E)  Online analytic processing (OLAP) 
A)  Online database processing (OLDP) 
B)  Online transaction processing (OLTP) 
C)  Online data processing (OLDP) 
D)  Online record processing (OLRP) 
E)  Online analytic processing (OLAP) E

Question 2

A data warehouse will usually consist of

Accepted Answer

A)  large air-conditioned buildings. 
B)  thousands of boxes of paper files. 
C)  a few fast servers and very large storage devices. 
D)  the same data as the company's operational data. 
E)  only government related information. 
A)  large air-conditioned buildings. 
B)  thousands of boxes of paper files. 
C)  a few fast servers and very large storage devices. 
D)  the same data as the company's operational data. 
E)  only government related information. C

Question 3

________ encapsulate the knowledge of human experts in the form of if-then rules.

Accepted Answer

A)  Data mining systems 
B)  Expert systems 
C)  Business intelligence applications 
D)  Reporting systems 
E)  CRM systems 
A)  Data mining systems 
B)  Expert systems 
C)  Business intelligence applications 
D)  Reporting systems 
E)  CRM systems B

Question 4

A data warehouse 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 5

While data may be collected in OLTP, the fact that data may not be used to improve decision making refers to (the)

Accepted Answer

A)  data overload challenge. 
B)  information overload. 
C)  data resource challenge. 
D)  data integrity challenge. 
E)  knowledge challenge. 
A)  data overload challenge. 
B)  information overload. 
C)  data resource challenge. 
D)  data integrity challenge. 
E)  knowledge challenge.

Question 6

In an OLAP system, a measure is (are)

Accepted Answer

A)  a data item of interest. 
B)  a report. 
C)  data items that are summed. 
D)  processed data. 
E)  a characteristic of a dimension. 
A)  a data item of interest. 
B)  a report. 
C)  data items that are summed. 
D)  processed data. 
E)  a characteristic of a dimension.

Question 7

If you need to identify groups of entities that have similar characteristics, you need to perform (a)

Accepted Answer

A)  cluster analysis. 
B)  regression analysis. 
C)  neural network analysis. 
D)  online analytical processing. 
E)  grouping analysis. 
A)  cluster analysis. 
B)  regression analysis. 
C)  neural network analysis. 
D)  online analytical processing. 
E)  grouping analysis.

Question 8

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

________ integrate data from multiple sources, and process those data by sorting, grouping, summing, averaging, and comparing.

Accepted Answer

A)  Reporting systems 
B)  Supplier relationship management systems 
C)  Business intelligence systems 
D)  Expert systems 
E)  Customer relationship management systems 
A)  Reporting systems 
B)  Supplier relationship management systems 
C)  Business intelligence systems 
D)  Expert systems 
E)  Customer relationship management systems

Question 10

________ data mining happens when analysts create a data model or hypothesis before running the analysis.

Accepted Answer

The answer of ________ data mining happens when analysts create...

Question 11

Your local burger joint wants to reap the benefits of improved decision making by using its sales data. In order to do this, it must

Accepted Answer

A)  use reporting systems as part of its complete information systems. 
B)  incorporate data-mining products as part of its complete information systems. 
C)  follow best practices and adopt an ERP. 
D)  adopt an expert system into its existing information system. 
E)  adopt knowledge management systems into its existing information system. 
A)  use reporting systems as part of its complete information systems. 
B)  incorporate data-mining products as part of its complete information systems. 
C)  follow best practices and adopt an ERP. 
D)  adopt an expert system into its existing information system. 
E)  adopt knowledge management systems into its existing information system.

Question 12

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 13

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

Accepted Answer

A)  Managers are aware of the data they need. 
B)  There is too much information. 
C)  There is too much uncertainty in making any decisions. 
D)  Computer speed doubles every 18 months. 
E)  Managers suffer from a lack of training. 
A)  Managers are aware of the data they need. 
B)  There is too much information. 
C)  There is too much uncertainty in making any decisions. 
D)  Computer speed doubles every 18 months. 
E)  Managers suffer from a lack of training.

Question 14

The purpose of a business intelligence system is to provide information that

Accepted Answer

A)  improves decision making. 
B)  can be summarized. 
C)  is less granular. 
D)  follows privacy legislation. 
E)  has only one level of complexity. 
A)  improves decision making. 
B)  can be summarized. 
C)  is less granular. 
D)  follows privacy legislation. 
E)  has only one level of complexity.

Question 15

Data-mining systems use heuristic techniques to process data to find hidden patterns and relationships among the data.

Accepted Answer

A) True 
 B)False

Question 16

________ is a statistical technique that identifies groups of entities that have similar characteristics.

Accepted Answer

The answer of ________ is a statistical technique that identifies...

Question 17

If you are collecting data electronically and processing the transaction online, then you are using (a) ________.

Accepted Answer

A)  online analytical processing (OLAP) 
B)  online transaction processing (OLTP) 
C)  data warehouse 
D)  data-mining 
E)  database management system (DBMS) 
A)  online analytical processing (OLAP) 
B)  online transaction processing (OLTP) 
C)  data warehouse 
D)  data-mining 
E)  database management system (DBMS)

Question 18

________ is the application of statistical techniques to find patterns and relationships in data and to predict outcomes.

Accepted Answer

A)  Data mining 
B)  Data warehousing 
C)  Data depositing 
D)  Data marting 
E)  Databasing 
A)  Data mining 
B)  Data warehousing 
C)  Data depositing 
D)  Data marting 
E)  Databasing

Question 19

Systems that focus on making data collected in OLTP to support decision making are often referred to as decision support systems.

Accepted Answer

A) True 
 B)False

Question 20

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.

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

A data warehouse will usually consist of

________ encapsulate the knowledge of human experts in the form of if-then rules.

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

While data may be collected in OLTP, the fact that data may not be used to improve decision making refers to (the)

In an OLAP system, a measure is (are)

If you need to identify groups of entities that have similar characteristics, you need to perform (a)

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

________ integrate data from multiple sources, and process those data by sorting, grouping, summing, averaging, and comparing.

________ data mining happens when analysts create a data model or hypothesis before running the analysis.

Your local burger joint wants to reap the benefits of improved decision making by using its sales data. In order to do this, it must

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

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

The purpose of a business intelligence system is to provide information that

Data-mining systems use heuristic techniques to process data to find hidden patterns and relationships among the data.

________ is a statistical technique that identifies groups of entities that have similar characteristics.

If you are collecting data electronically and processing the transaction online, then you are using (a) ________.

________ is the application of statistical techniques to find patterns and relationships in data and to predict outcomes.

Systems that focus on making data collected in OLTP to support decision making are often referred to as decision support systems.

Data-mining techniques include

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

Exam 12: Decision Making and Business Intelligence

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

A data warehouse will usually consist of

________ encapsulate the knowledge of human experts in the form of if-then rules.

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

While data may be collected in OLTP, the fact that data may not be used to improve decision making refers to (the)

In an OLAP system, a measure is (are)

If you need to identify groups of entities that have similar characteristics, you need to perform (a)

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

________ integrate data from multiple sources, and process those data by sorting, grouping, summing, averaging, and comparing.

________ data mining happens when analysts create a data model or hypothesis before running the analysis.

Your local burger joint wants to reap the benefits of improved decision making by using its sales data. In order to do this, it must

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

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

The purpose of a business intelligence system is to provide information that

Data-mining systems use heuristic techniques to process data to find hidden patterns and relationships among the data.

________ is a statistical technique that identifies groups of entities that have similar characteristics.

If you are collecting data electronically and processing the transaction online, then you are using (a) ________.

________ is the application of statistical techniques to find patterns and relationships in data and to predict outcomes.

Systems that focus on making data collected in OLTP to support decision making are often referred to as decision support systems.

Data-mining techniques include

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Using Microsoft Access 2013

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters