Question 1

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

Accepted Answer

An information policy specifies the orga...

Question 2

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.F) C) and D)
G) D) and E) C

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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.F) B) and E)
G) D) and E)

Question 5

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 6

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 tableF) D) and E)
G) C) and D)

Question 7

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 forecastF) A) and B)
G) B) and E)

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 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 miningF) All of the above
G) A) and B)

Question 12

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 duplicationF) All of the above
G) B) and E)

Question 13

________ 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 qualityF) B) and E)
G) A) and D)

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.F) C) and D)
G) A) and E)

Question 15

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)  HadoopF) B) and E)
G) None of the above

Question 16

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)  ForecastingF) None of the above
G) B) and C)

Question 17

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 18

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)  DBMSF) A) and D)
G) A) and C) B

Question 19

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

Accepted Answer

A) True 
 B)False

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.F) A) and B)
G) A) and C)

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

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

Correct Answer
verified
An information policy specifies the orga...
View Answer

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

Correct Answer
verified
C

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Data mining uncovers hidden relationship...
View Answer

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?

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
The select operation creates a subset co...
View Answer

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified
B

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

Correct Answer
verified

The logical view of a database:

Correct Answer
verified

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

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

Correct AnswerverifiedAn information policy specifies the orga...View AnswerShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedData mining uncovers hidden relationship...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe select operation creates a subset co...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

The logical view of a database:

Correct AnswerverifiedShow Answer

Correct Answer
verified
An information policy specifies the orga...
View Answer

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining uncovers hidden relationship...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The select operation creates a subset co...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified