Question 1

In the context of data relationships,the term associations refers to:

Accepted Answer

A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers. 
A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers. C

Question 2

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 business intelligence systems,including operational,historical,machine-generated,Web/social data,audio and video data,and external data.The large datasets can be collected in a Hadoop cluster and used by an analytic platform to support power user queries,data mining,OLAP,etc.A data warehouse can be used to house all data,including smaller data sets and operational data,and be used to support casual use,for queries,reports,and digital dashboards,as well as support the analytic platforms.Smaller data marts can be created from the data warehouse to enable faster querying and typical queries from casual users.

Question 3

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 B

Question 4

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Accepted Answer

A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality 
A) Batch processing 
B) Data redundancy 
C) Data independence 
D) Online processing 
E) Data quality

Question 5

A physical view shows data as it is actually organized and structured on the data storage media.

Accepted Answer

A) True 
 B)False

Question 6

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences.You wish to find out if there are any particular activities that your customers engage in,or the types of purchases made in the month before or after purchasing select items from your store.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 7

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Accepted Answer

The select operation creates a subset co

Question 8

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Accepted Answer

A) Data normalization 
B) Data accuracy 
C) Data redundancy 
D) Data inconsistency 
E) Data duplication 
A) Data normalization 
B) Data accuracy 
C) Data redundancy 
D) Data inconsistency 
E) Data duplication

Question 9

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

A) True 
 B)False

Question 10

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 11

A record is a characteristic or quality used to describe a particular entity.

Accepted Answer

A) True 
 B)False

Question 12

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 13

All of the following are issues with the traditional file environment except:

Accepted Answer

A) data inconsistency. 
B) inability to develop specialized applications for functional areas. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing. 
A) data inconsistency. 
B) inability to develop specialized applications for functional areas. 
C) lack of flexibility in creating ad-hoc reports. 
D) poor security. 
E) data sharing.

Question 14

In a relational database,the three basic operations used to develop useful sets of data are:

Accepted Answer

A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select. 
A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select.

Question 15

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 16

Which of the following tools enables users to view the same data in different ways using multiple dimensions?

Accepted Answer

A) Predictive analysis 
B) SQL 
C) OLAP 
D) Data mining 
E) Hadoop 
A) Predictive analysis 
B) SQL 
C) OLAP 
D) Data mining 
E) Hadoop

Question 17

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 18

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A) True 
 B)False

Question 19

What is an information policy and why is it needed in a firm?

Accepted Answer

An information policy specifies the orga

Question 20

The logical view of a database:

Accepted Answer

A) displays the organization and structure of data on the physical storage media. 
B) includes a digital dashboard. 
C) allows the creation of supplementary reports. 
D) enables users to manipulate the logical structure of the database. 
E) presents data as they would be perceived by end users. 
A) displays the organization and structure of data on the physical storage media. 
B) includes a digital dashboard. 
C) allows the creation of supplementary reports. 
D) enables users to manipulate the logical structure of the database. 
E) presents data as they would be perceived by end users.

In the context of data relationships,the term associations refers to:

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

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

A physical view shows data as it is actually organized and structured on the data storage media.

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

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?

A record is a characteristic or quality used to describe a particular entity.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

All of the following are issues with the traditional file environment except:

In a relational database,the three basic operations used to develop useful sets of data are:

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 tools enables users to view the same data in different ways using multiple dimensions?

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

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

What is an information policy and why is it needed in a firm?

The logical view of a database:

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: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

In the context of data relationships,the term associations refers to:

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

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

A physical view shows data as it is actually organized and structured on the data storage media.

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

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?

A record is a characteristic or quality used to describe a particular entity.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

All of the following are issues with the traditional file environment except:

In a relational database,the three basic operations used to develop useful sets of data are:

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 tools enables users to view the same data in different ways using multiple dimensions?

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

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

What is an information policy and why is it needed in a firm?

The logical view of a database:

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: Enterprise Applications

E-Commerce: Digital Markets,digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters