Question 1

Segment customers based on postal codes is a kind of:

Accepted Answer

A)   Cluster Analysis
B)   Association Detection
C)   Statistical Analysis
D)   All of these choices are correct.E) A) and B)
F) A) and C)

Question 2

In the relational database model, what are characteristics or properties of an entity class?

Accepted Answer

A)   Entity
B)   Entity class
C)   Attribute
D)   Attribute classE) A) and B)
F) A) and C)

Question 3

Which of the following uses a DBMS to interact with a database?

Accepted Answer

A)   Users of accounting programs
B)   Users of human resource programs
C)   Users of marketing programs
D)   All of these choices are correct.E) A) and B)
F) C) and D)

Question 4

Which of the following measures how quickly a system performs a certain process or transaction?

Accepted Answer

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

Question 5

The central concept of a database is that of a collection of records.

Accepted Answer

A) True 
 B)False

Question 6

Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.

Accepted Answer

The answer of Customer ID, Customer Name, Contact Name, and...

Question 7

All of the following are advantages of database-stored information, except:

Accepted Answer

A)   Increased flexibility
B)   Increased performance
C)   Increased information redundancy
D)   Increased information integrityE) All of the above
F) B) and D)

Question 8

What is a primary key?

Accepted Answer

A)   A field (or group of fields)  that uniquely identifies a given entity in a table
B)   A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C)   Characteristics or properties of an entity class
D)   A field (or group of fields)  that uniquely identifies a given attribute in a tableE) A) and D)
F) A) and C)

Question 9

Explain why an organization cannot achieve 100 percent accurate and complete information.

Accepted Answer

Achieving perfect information is almost ...

Question 10

The primary purpose of a data warehouse is to aggregate transactional data into analytical information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following describes ETL?

Accepted Answer

A)   A process that extracts information from internal and external databases
B)   A process that transforms information using a common set of enterprise definitions
C)   A process that loads information into a data warehouse
D)   All of these choices are correct.E) C) and D)
F) A) and D)

Question 12

The trade-off for perfect information lies in accuracy versus _____.

Accepted Answer

The answer of The trade-off for perfect information lies in...

Question 13

Which of the following occurs during data (or information)  cleansing?

Accepted Answer

A)   Clean missing records
B)   Clean redundant records
C)   Clean inaccurate data
D)   All of these choices are correct.E) None of the above
F) A) and B)

Question 14

To manage and organize various tables within the relational database model, developers must identify primary keys and foreign keys and use them to create _____.

Accepted Answer

logical re...

Question 15

Data warehousing is about extending the transformation of transactional data into ______ information.

Accepted Answer

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

Question 16

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

Accepted Answer

A)   Uses additional hard disk space
B)   Makes performing information updates harder
C)   Improves information quality
D)   All of these choices are correct.E) A) and C)
F) C) and D)

Question 17

Data-mining tools apply algorithms to information sets to uncover inherent trends and patterns in the information, which analysts use to develop new business strategies.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are reasons why operational systems are not appropriate for business analysis, except:

Accepted Answer

A)   Does not include information from other operational applications
B)   Operational systems are integrated
C)   Operational information is mainly current
D)   Operational information frequently has quality issuesE) A) and B)
F) None of the above

Question 19

Which of the following determines values for an unknown continuous variable behaviour?

Accepted Answer

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

Question 20

Identify the importance of ensuring the cleanliness of information throughout an organization.

Accepted Answer

An organization must maintain high quali...

Exam 4: Ethics and Information Security

In the relational database model, what are characteristics or properties of an entity class?

Correct AnswerverifiedShow Answer

Which of the following determines values for an unknown continuous variable behaviour?

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

Correct AnswerverifiedShow Answer

The trade-off for perfect information lies in accuracy versus _____.

Correct AnswerverifiedShow Answer

Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.

Correct AnswerverifiedShow Answer

Identify the importance of ensuring the cleanliness of information throughout an organization.

Correct AnswerverifiedAn organization must maintain high quali...View AnswerShow Answer

All of the following are advantages of database-stored information, except:

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to aggregate transactional data into analytical information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

Correct AnswerverifiedShow Answer

All of the following are reasons why operational systems are not appropriate for business analysis, except:

Correct AnswerverifiedShow Answer

The central concept of a database is that of a collection of records.

Correct AnswerverifiedShow Answer

To manage and organize various tables within the relational database model, developers must identify primary keys and foreign keys and use them to create _____.

Correct Answerverifiedlogical re...View AnswerShow Answer

Segment customers based on postal codes is a kind of:

Correct AnswerverifiedShow Answer

Which of the following occurs during data (or information) cleansing?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following measures how quickly a system performs a certain process or transaction?

Correct AnswerverifiedShow Answer

Data-mining tools apply algorithms to information sets to uncover inherent trends and patterns in the information, which analysts use to develop new business strategies.

Correct AnswerverifiedShow Answer

What is a primary key?

Correct AnswerverifiedShow Answer

Explain why an organization cannot achieve 100 percent accurate and complete information.

Correct AnswerverifiedAchieving perfect information is almost ...View AnswerShow Answer

Data warehousing is about extending the transformation of transactional data into ______ information.

Correct AnswerverifiedShow Answer

Which of the following uses a DBMS to interact with a database?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An organization must maintain high quali...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
logical re...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Achieving perfect information is almost ...
View Answer

Correct Answer
verified

Correct Answer
verified