Question 1

Data mining is a tool for allowing users to

Accepted Answer

A)   quickly compare transaction data gathered over many years.
B)   find hidden relationships in data.
C)   obtain online answers to ad hoc questions in a rapid amount of time.
D)   summarize massive amounts of data into much smaller, traditional reports.E) A) and B)
F) B) and C)

Question 2

A DBMS makes the

Accepted Answer

A)   physical database available for different logical views.
B)   logical database available for different analytical views.
C)   physical database available for different analytical views.
D)   logical database available for different physical views.E) B) and C)
F) A) and D)

Question 3

In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 4

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 5

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Accepted Answer

A)   information policy.
B)   data definition file.
C)   data quality audit.
D)   data governance policy.E) C) and D)
F) A) and B)

Question 6

OODBMS are slower than relational DBMS.

Accepted Answer

A) True 
 B)False

Question 7

Data ________ describes a situation in which the same attribute of a data entity may have different values.

Accepted Answer

The answer of Data ________ describes a situation in which...

Question 8

The technique of using data mining, historical data, and assumptions about future conditions is called ________.

Accepted Answer

predictive...

Question 9

In a relational database, a record is referred to in technical terms as a(n)

Accepted Answer

A)   tuple.
B)   row.
C)   entity.
D)   field.E) A) and B)
F) A) and C)

Question 10

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)   select, from, and join.E) All of the above
F) A) and B)

Question 11

In ________, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

The answer of In ________, a data mining tool discovers...

Question 12

A data warehouse is composed of

Accepted Answer

A)   historical data from legacy systems.
B)   current data.
C)   internal and external data sources.
D)   historic and current internal data.E) B) and C)
F) A) and B)

Question 13

A characteristic or quality describing an entity is called a(n)

Accepted Answer

A)   field.
B)   tuple.
C)   key field.
D)   attribute.E) C) and D)
F) A) and C)

Question 14

The tool that enables users to view the same data in different ways using multiple dimensions is

Accepted Answer

A)   predictive analysis.
B)   SQL.
C)   OLAP.
D)   data mining.E) A) and C)
F) A) and B)

Question 15

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because

Accepted Answer

A)   a data mart typically focuses on a single subject area or line of business.
B)   all the information is historical.
C)   a data mart uses a Web interface.
D)   all of the information belongs to a single company.E) B) and D)
F) B) and C)

Question 16

You work for an national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Accepted Answer

A)   identifying associations.
B)   identifying clusters.
C)   identifying sequences.
D)   classification.E) B) and D)
F) A) and B)

Question 17

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A)   the entity CUSTOMER with the attribute PRODUCT
B)   the entity CUSTOMER with the attribute PURCHASE
C)   the entity PRODUCT with the attribute PURCHASE
D)   the entity PRODUCT with the attribute CUSTOMERE) A) and C)
F) A) and B)

Question 18

The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called

Accepted Answer

A)   data administration.
B)   database administration.
C)   information policy administration.
D)   data auditing.E) B) and D)
F) B) and C)

Question 19

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

Accepted Answer

A)   batch processing
B)   data redundancy
C)   data independence
D)   online processingE) All of the above
F) B) and C)

Question 20

A field identified in a table as holding the unique identifier of the table's records is called the

Accepted Answer

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

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

In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

Correct AnswerverifiedShow Answer

A field identified in a table as holding the unique identifier of the table's records is called the

Correct AnswerverifiedShow Answer

The tool that enables users to view the same data in different ways using multiple dimensions is

Correct AnswerverifiedShow Answer

The technique of using data mining, historical data, and assumptions about future conditions is called ________.

Correct Answerverifiedpredictive...View AnswerShow Answer

In a relational database, a record is referred to in technical terms as a(n)

Correct AnswerverifiedShow Answer

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

Correct AnswerverifiedShow Answer

Data mining is a tool for allowing users to

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You work for an national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Correct AnswerverifiedShow Answer

In ________, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Correct AnswerverifiedShow Answer

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

OODBMS are slower than relational DBMS.

Correct AnswerverifiedShow Answer

A characteristic or quality describing an entity is called a(n)

Correct AnswerverifiedShow Answer

A DBMS makes the

Correct AnswerverifiedShow Answer

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because

Correct AnswerverifiedShow Answer

Data ________ describes a situation in which the same attribute of a data entity may have different values.

Correct AnswerverifiedShow Answer

Which of the following best illustrates the relationship between entities and attributes?

Correct AnswerverifiedShow Answer

The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called

Correct AnswerverifiedShow Answer

A data warehouse is composed of

Correct AnswerverifiedShow Answer

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
predictive...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified