Question 1

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

Accepted Answer

A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting 
A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting

Question 2

In a table for customers,the information about a single customer resides in a single:

Accepted Answer

A) field. 
B) row. 
C) column. 
D) table. 
E) entity. 
A) field. 
B) row. 
C) column. 
D) table. 
E) entity.

Question 3

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Accepted Answer

A) True 
 B)False

Question 4

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Accepted Answer

A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data defining. 
E) optimization. 
A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data defining. 
E) optimization.

Question 5

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

A) True 
 B)False

Question 6

Microsoft Access's data dictionary displays all of the following information about a field except the:

Accepted Answer

A) size of the field. 
B) format of the field. 
C) description of the field. 
D) type of the field. 
E) the organization within the organization that is responsible for maintaining the data. 
A) size of the field. 
B) format of the field. 
C) description of the field. 
D) type of the field. 
E) the organization within the organization that is responsible for maintaining the data.

Question 7

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

Accepted Answer

A) Database server software 
B) Application server software 
C) Web browser software 
D) Data mining software 
E) Web server software 
A) Database server software 
B) Application server software 
C) Web browser software 
D) Data mining software 
E) Web server software

Question 9

In-memory computing relies primarily on a computer's disk drives for data storage.

Accepted Answer

A) True 
 B)False

Question 10

In data mining,which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

Accepted Answer

A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting 
A) Associations 
B) Sequences 
C) Classifications 
D) Clustering 
E) Forecasting

Question 11

Which of the following is not one of the techniques used in web mining?

Accepted Answer

A) Content mining 
B) Structure mining 
C) Server mining 
D) Usage mining 
E) Data mining 
A) Content mining 
B) Structure mining 
C) Server mining 
D) Usage mining 
E) Data mining

Question 12

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security?

Accepted Answer

A) Data dictionary 
B) Data definition diagram 
C) Entity-relationship diagram 
D) Relationship dictionary 
E) Data table 
A) Data dictionary 
B) Data definition diagram 
C) Entity-relationship diagram 
D) Relationship dictionary 
E) Data table

Question 13

Which of the following is a specialized language that programmers use to add and change data in the database?

Accepted Answer

A) Data access language 
B) Data manipulation language 
C) Structured query language 
D) Data definition language 
E) DBMS 
A) Data access language 
B) Data manipulation language 
C) Structured query language 
D) Data definition language 
E) DBMS

Question 14

A field identified in a record as holding the unique identifier for that record is called the:

Accepted Answer

A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) key attribute. 
A) primary key. 
B) key field. 
C) primary field. 
D) unique ID. 
E) key attribute.

Question 15

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is the most prominent data manipulation language today?

Accepted Answer

A) Access 
B) DB2 
C) SQL 
D) Crystal Reports 
E) NoSQL 
A) Access 
B) DB2 
C) SQL 
D) Crystal Reports 
E) NoSQL

Question 17

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

Accepted Answer

A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast 
A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast

Question 18

OLAP can manage and handle queries with very large sets of data.

Accepted Answer

A) True 
 B)False

Question 19

You have been hired by a furniture leasing company to implement its first business intelligence systems and infrastructure.To prepare for your initial report,describe the types of data the firm can use to support business intelligence and the systems that you will implement to support both power users and casual users,and explain how these systems or tools work together.

Accepted Answer

All types of data can be used for their

Question 20

Which of the following is not a method for performing a data quality audit?

Accepted Answer

A) Surveying entire data files 
B) Surveying samples from data files 
C) Surveying data definition and query files 
D) Surveying end users about their perceptions of data quality 
E) Surveying managers about their perceptions of data quality 
A) Surveying entire data files 
B) Surveying samples from data files 
C) Surveying data definition and query files 
D) Surveying end users about their perceptions of data quality 
E) Surveying managers about their perceptions of data quality

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

In a table for customers,the information about a single customer resides in a single:

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Microsoft Access's data dictionary displays all of the following information about a field except the:

Multiple data marts are combined and streamlined to create a data warehouse.

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

In-memory computing relies primarily on a computer's disk drives for data storage.

In data mining,which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

Which of the following is not one of the techniques used in web mining?

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security?

Which of the following is a specialized language that programmers use to add and change data in the database?

A field identified in a record as holding the unique identifier for that record is called the:

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Which of the following is the most prominent data manipulation language today?

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

OLAP can manage and handle queries with very large sets of data.

Which of the following is not a method for performing a data quality audit?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence:

In data mining,which of the following involves using a series of existing values to determine what other future values will be?

In a table for customers,the information about a single customer resides in a single:

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Microsoft Access's data dictionary displays all of the following information about a field except the:

Multiple data marts are combined and streamlined to create a data warehouse.

Which of the following is software that handles all application operations between browser-based computers and a company's back-end business applications or databases?

In-memory computing relies primarily on a computer's disk drives for data storage.

In data mining,which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules?

Which of the following is not one of the techniques used in web mining?

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage,physical representation,ownership,authorization,and security?

Which of the following is a specialized language that programmers use to add and change data in the database?

A field identified in a record as holding the unique identifier for that record is called the:

You can use text mining tools to analyze unstructured data,such as memos and legal cases.

Which of the following is the most prominent data manipulation language today?

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

OLAP can manage and handle queries with very large sets of data.

Which of the following is not a method for performing a data quality audit?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems,organizations,and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters