Question 1

Data mining is the process of analysing data to find hidden patterns and discover new insights not offered by the raw ___________ alone.

Accepted Answer

The answer of Data mining is the process of analysing...

Question 2

All of the following are business-critical integrity constraints,except

Accepted Answer

A)  System does not allow an entry for an order for a non-existent customer
B)  System does not allow returns of fresh produce after 15 days past delivery
C)  System does not allow shipping a product to a customer who does not have a valid address
D)  Systems does not allow shipping of a non-existent product to a customerE) All of the above
F) A) and D)

Question 3

Which of the following is true in regards to the elimination of redundant data?

Accepted Answer

A)  Uses additional hard disk space
B)  Makes performing information updates harder
C)  Improves information quality
D)  All the answers are correctE) C) and D)
F) All of the above

Question 4

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)  To create an entity
B)  To create physical relationships
C)  To create logical relationships
D)  To create an attributeE) A) and B)
F) B) and C)

Question 5

What are the three common forms for mining structured and unstructured data?

Accepted Answer

A)  Cluster analysis, association detection, statistical analysis
B)  Cluster analysis, association detection, disassociation detection
C)  Cluster analysis statistical detection, statistical analysis
D)  Association detection, market-basket analysis, market-basket associationE) B) and D)
F) C) and D)

Question 6

Explain the four primary traits that determine the value of information.

Accepted Answer

•Information type-transactional or analy...

Question 7

What is a field that uniquely identifies a given record in a table?

Accepted Answer

A)  Foreign key
B)  Primary key
C)  Data mining key
D)  DBMS keyE) A) and B)
F) A) and C)

Question 8

What are rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)  Information integrity
B)  Integrity constraint
C)  Business-critical integrity constraint
D)  Relational integrity constraintE) A) and C)
F) A) and D)

Question 9

Which of the below is not an example of an advantage of using a relational database?

Accepted Answer

A)  Increased information quality
B)  Increased flexibility
C)  Decreased information redundancy
D)  Decreased information securityE) A) and B)
F) A) and C)

Question 10

Define data mining,and explain the three common forms for mining structured and unstructured data.

Accepted Answer

Data mining is the process of analysing ...

Question 11

Enterprise systems are often available as a generic,but highly customisable,group of programs for business functions,but which function would not usually be included?

Accepted Answer

A)  Inconsistent data definitions
B)  Lack of data standards
C)  Increased data quality
D)  Inadequate data usefulnessE) A) and C)
F) A) and D)

Question 12

If a manager identifies numerous data integrity issues he or she should consider the reports generated from that data as invalid and not use them when making decisions.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

Accepted Answer

A)  Clustering objective analysis
B)  Statistical analysis
C)  Entity modelling
D)  Market basket analysisE) B) and C)
F) A) and B)

Question 14

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Accepted Answer

A)  Transactional information
B)  Analytical information
C)  Timeliness
D)  QualityE) B) and C)
F) A) and B)

Question 15

Explain enterprise application integration.

Accepted Answer

Enterprise application integration (EAI)...

Question 16

Define a data warehouse and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection...

Question 17

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Accepted Answer

A) True 
 B)False

Question 18

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behaviour and guide decision making.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not a common form of data mining?

Accepted Answer

A)  Division organisation
B)  Classification
C)  Estimation
D)  ClusteringE) A) and D)
F) B) and C)

Question 20

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Accepted Answer

A)  Data mining tools
B)  Structured example language
C)  Query-by-example tool
D)  Relational query toolE) B) and D)
F) A) and C)

Exam 8: Data and Business Intelligence

Define a data warehouse and provide a few reasons it can make a manager more effective.

Correct AnswerverifiedA data warehouse is a logical collection...View AnswerShow Answer

Explain the four primary traits that determine the value of information.

Correct Answerverified•Information type-transactional or analy...View AnswerShow Answer

All of the following are business-critical integrity constraints,except

Correct AnswerverifiedShow Answer

Which of the following is true in regards to the elimination of redundant data?

Correct AnswerverifiedShow Answer

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behaviour and guide decision making.

Correct AnswerverifiedShow Answer

Explain enterprise application integration.

Correct AnswerverifiedEnterprise application integration (EAI)...View AnswerShow Answer

What are rules that enforce basic and fundamental information-based constraints?

Correct AnswerverifiedShow Answer

Which of the below is not an example of an advantage of using a relational database?

Correct AnswerverifiedShow Answer

What is a field that uniquely identifies a given record in a table?

Correct AnswerverifiedShow Answer

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

Correct AnswerverifiedShow Answer

What are the three common forms for mining structured and unstructured data?

Correct AnswerverifiedShow Answer

Define data mining,and explain the three common forms for mining structured and unstructured data.

Correct AnswerverifiedData mining is the process of analysing ...View AnswerShow Answer

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Correct AnswerverifiedShow Answer

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Correct AnswerverifiedShow Answer

If a manager identifies numerous data integrity issues he or she should consider the reports generated from that data as invalid and not use them when making decisions.

Correct AnswerverifiedShow Answer

Which of the following is not a common form of data mining?

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

Enterprise systems are often available as a generic,but highly customisable,group of programs for business functions,but which function would not usually be included?

Correct AnswerverifiedShow Answer

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Correct AnswerverifiedShow Answer

Data mining is the process of analysing data to find hidden patterns and discover new insights not offered by the raw ___________ alone.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A data warehouse is a logical collection...
View Answer

Correct Answer
verified
•Information type-transactional or analy...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Enterprise application integration (EAI)...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining is the process of analysing ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified