Question 1

List and describe the various benefits an organization can expect to receive from BI deployment?

Accepted Answer

Direct quantifiable benefits include wor...

Question 2

Which of the following segments a heterogeneous population of records into a number of more homogeneous subgroups?

Accepted Answer

A)   Classification
B)   Estimation
C)   Affinity grouping
D)   ClusteringE) A) and B)
F) A) and C)

Question 3

A(n) _______________ key is a field that uniquely identifies a given entity in a table.

Accepted Answer

The answer of A(n) _______________ key is a field that...

Question 4

______ integrity is a measure of the quality of data.

Accepted Answer

The answer of ______ integrity is a measure of the...

Question 5

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

The answer of _____________ cleansing or scrubbing is the process...

Question 6

A birth date of 31/02/1991 is an example of ______ but _______ information.

Accepted Answer

A)   complete; inaccurate
B)   accurate; incomplete
C)   incomplete; accurate
D)   complete; accurateE) A) and C)
F) A) and B)

Question 7

The computer program used to manage and query a database is known as a:

Accepted Answer

A)   Database
B)   Business Intelligence
C)   Schema
D)   Database Management SystemE) B) and C)
F) A) and D)

Question 8

Data mining approaches decision making with these different activities in mind:

Accepted Answer

A)   Classification
B)   Estimation
C)   Affinity grouping
D)   All of these choices are correct.E) A) and B)
F) A) and C)

Question 9

Which of the following is correct in reference to a database?

Accepted Answer

A)   A database can support only one logical view
B)   A database can support many physical views
C)   A database can support many logical views
D)   A database can support up to 3 logical viewsE) C) and D)
F) All of the above

Question 10

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)   To create a database
B)   To create physical relationships
C)   To create logical relationships
D)   All of these choices are correct.E) B) and D)
F) All of the above

Question 11

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Accepted Answer

Subject-oriented means that information ...

Question 12

List the four primary sources of low-quality information.

Accepted Answer

(1) Online customers intentionally enter...

Question 13

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)   Association detection
B)   Market basket analysis
C)   Cluster analysis
D)   Intelligent agentE) A) and C)
F) B) and D)

Question 14

Having a data-driven website enables the site to grow faster than would be possible with a static site.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following database structures offers a flexible way of representing objects and their relationships?

Accepted Answer

A)   Hierarchical database
B)   Network database
C)   Relational database model
D)   All of these choices are correct.E) A) and B)
F) A) and C)

Question 16

Data warehousing is about extending the transformation of data into _________.

Accepted Answer

The answer of Data warehousing is about extending the transformation...

Question 17

_______ are predictions made on the basis of time series information.

Accepted Answer

The answer of _______ are predictions made on the basis...

Question 18

Most professionals consider a collection of data to constitute a database must have the following properties:

Accepted Answer

A)   Data Integrity
B)   Data Quality
C)   Data Shared Access
D)   All of these choices are correct.E) A) and B)
F) A) and C)

Question 19

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

Accepted Answer

A)   Association detection
B)   Market basket analysis
C)   Cluster analysis
D)   Intelligent agentE) All of the above
F) B) and D)

Question 20

What refers to how well a system can adapt to increased demands?

Accepted Answer

A)   Scalability
B)   Performance
C)   Redundancy
D)   Information integrityE) A) and B)
F) B) and C)

Exam 4: Ethics and Information Security

The computer program used to manage and query a database is known as a:

Correct AnswerverifiedShow Answer

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Correct AnswerverifiedSubject-oriented means that information ...View AnswerShow Answer

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

Correct AnswerverifiedShow Answer

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Correct AnswerverifiedShow Answer

Which of the following segments a heterogeneous population of records into a number of more homogeneous subgroups?

Correct AnswerverifiedShow Answer

List and describe the various benefits an organization can expect to receive from BI deployment?

Correct AnswerverifiedDirect quantifiable benefits include wor...View AnswerShow Answer

List the four primary sources of low-quality information.

Correct Answerverified(1) Online customers intentionally enter...View AnswerShow Answer

______ integrity is a measure of the quality of data.

Correct AnswerverifiedShow Answer

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Correct AnswerverifiedShow Answer

A birth date of 31/02/1991 is an example of ______ but _______ information.

Correct AnswerverifiedShow Answer

_______ are predictions made on the basis of time series information.

Correct AnswerverifiedShow Answer

Data warehousing is about extending the transformation of data into _________.

Correct AnswerverifiedShow Answer

What refers to how well a system can adapt to increased demands?

Correct AnswerverifiedShow Answer

Having a data-driven website enables the site to grow faster than would be possible with a static site.

Correct AnswerverifiedShow Answer

Which of the following is correct in reference to a database?

Correct AnswerverifiedShow Answer

Which of the following database structures offers a flexible way of representing objects and their relationships?

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

Data mining approaches decision making with these different activities in mind:

Correct AnswerverifiedShow Answer

Most professionals consider a collection of data to constitute a database must have the following properties:

Correct AnswerverifiedShow Answer

A(n) _______________ key is a field that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Subject-oriented means that information ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Direct quantifiable benefits include wor...
View Answer

Correct Answer
verified
(1) Online customers intentionally enter...
View Answer

Correct Answer
verified

Correct Answer
verified

A birth date of 31/02/1991 is an example of but _ information.

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