Question 1

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 2

What is a great example of using cluster analysis in business to create target-marketing strategies?

Accepted Answer

A)  Google search
B)  First name information
C)  Zip code segmentation
D)  Last name associationsE) None of the above
F) A) and B)

Question 3

Which of the following represents the different information granularities?

Accepted Answer

A)  Detail, summary, aggregate
B)  Document, presentation, spreadsheet, database
C)  Individual, department, enterprise
D)  None of theseE) A) and D)
F) All of the above

Question 4

Which of the following represent the four primary traits that help determine the value of information?

Accepted Answer

A)  Information type, information timeliness, information quality, and information governance
B)  Information statistics, information tracking, information quality, and information governance
C)  Information type, information chance, information analytics, and information policy
D)  Information timeliness, information quality, information quantity, and information governance policyE) A) and B)
F) A) and C)

Question 5

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants its information to be, the less it costs.
B)  The more accurate an organization wants its information to be, the less it costs.
C)  The less accurate an organization wants its information to be, the more it costs.
D)  The more complete and accurate an organization wants its information to be, the more it costs.E) A) and B)
F) B) and D)

Question 6

There are three primary data models for organizing information: the hierarchical, network, and relational database models.

Accepted Answer

A) True 
 B)False

Question 7

What analyzes unstructured data to find trends and patterns in words and sentences?

Accepted Answer

A)  Structured data
B)  Unstructured data
C)  Text mining
D)  Web miningE) A) and D)
F) C) and D)

Question 8

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 9

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Accepted Answer

A)  Data model
B)  Data element
C)  Data mining tool
D)  Data mart toolE) None of the above
F) A) and B)

Question 10

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 modeling
D)  Market basket analysisE) A) and C)
F) All of the above

Question 11

Information is everywhere in an organization.Information ____________ refers to the extent of detail within the information.

Accepted Answer

The answer of Information is everywhere in an organization.Information ____________...

Question 12

Two of the challenges businesses faced before data warehouses were lack of data standards and poor data _________.

Accepted Answer

The answer of Two of the challenges businesses faced before...

Question 13

Information cleansing or __________ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

The answer of Information cleansing or __________ is a process...

Question 14

When discovering trends and seasonal variations in transactional information, use a ________________ forecast to change the transactional information by units of time, such as transforming weekly information into monthly or seasonal information or hourly information and into daily information.

Accepted Answer

A)  Analytical graphing
B)  Association detection
C)  Market basket
D)  Time-seriesE) C) and D)
F) A) and D)

Question 15

What are the rules that help ensure the quality of information?

Accepted Answer

A)  Information integrity
B)  Integrity constraints
C)  Relational integrity constraints
D)  Business-critical integrity constraintsE) A) and D)
F) None of the above

Question 16

Which of the following are examples of transactional information?

Accepted Answer

A)  Airline ticket, sales receipts, and packing slips
B)  Trends and sales statistics
C)  Product sales results, grocery receipts, and growth projections
D)  Airline tickets and sales growth spreadsheetsE) C) and D)
F) B) and C)

Question 17

The five common characteristics of high quality include accurate, complete, __________, timely and unique.

Accepted Answer

The answer of The five common characteristics of high quality...

Question 18

What is the ultimate outcome of a data warehouse?

Accepted Answer

A)  Data goals
B)  Data relationships
C)  Data marketing
D)  Data martsE) B) and D)
F) B) and C)

Question 19

Which of the following represents the different information levels?

Accepted Answer

A)  Detail, summary, aggregate
B)  Document, presentation, spreadsheet, database
C)  Individual, department, enterprise
D)  None of theseE) A) and D)
F) None of the above

Question 20

Data redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

A) True 
 B)False

Exam 6: Data: 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

Which of the following are examples of transactional information?

Correct AnswerverifiedShow Answer

The five common characteristics of high quality include accurate, complete, __________, timely and unique.

Correct AnswerverifiedShow Answer

Information is everywhere in an organization.Information ____________ refers to the extent of detail within the information.

Correct AnswerverifiedShow Answer

Information cleansing or __________ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

One of the advantages found in a relational database is increased information redundancy.

Correct AnswerverifiedShow Answer

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Correct AnswerverifiedShow Answer

Data redundancy is the duplication of data, or the storage of the same data in multiple places.

Correct AnswerverifiedShow Answer

What is a great example of using cluster analysis in business to create target-marketing strategies?

Correct AnswerverifiedShow Answer

Which of the following represents the different information granularities?

Correct AnswerverifiedShow Answer

Which of the following statements is true?

Correct AnswerverifiedShow Answer

What analyzes unstructured data to find trends and patterns in words and sentences?

Correct AnswerverifiedShow Answer

Which of the following represent the four primary traits that help determine the value of information?

Correct AnswerverifiedShow Answer

What are the rules that help ensure the quality of information?

Correct AnswerverifiedShow Answer

When discovering trends and seasonal variations in transactional information, use a ________________ forecast to change the transactional information by units of time, such as transforming weekly information into monthly or seasonal information or hourly information and into daily information.

Correct AnswerverifiedShow Answer

What is the ultimate outcome of a data warehouse?

Correct AnswerverifiedShow Answer

Two of the challenges businesses faced before data warehouses were lack of data standards and poor data _________.

Correct AnswerverifiedShow Answer

Which of the following represents the different information levels?

Correct AnswerverifiedShow Answer

There are three primary data models for organizing information: the hierarchical, network, and relational database models.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A data warehouse is a logical collection...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified