Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

What is the ultimate outcome of a data warehouse?

Accepted Answer

A) Data goals 
B) Data relationships 
C) Data marketing 
D) Data marts 
A) Data goals 
B) Data relationships 
C) Data marketing 
D) Data marts

Question 4

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-series 
A) Analytical graphing 
B) Association detection 
C) Market basket 
D) Time-series

Question 5

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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 associations 
A) Google search 
B) First name information 
C) Zip code segmentation 
D) Last name associations

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 tool 
A) Data model 
B) Data element 
C) Data mining tool 
D) Data mart tool

Question 10

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 mining 
A) Structured data 
B) Unstructured data 
C) Text mining 
D) Web mining

Question 11

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 12

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 policy 
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 policy

Question 13

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 these 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of these

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 these 
A) Detail, summary, aggregate 
B) Document, presentation, spreadsheet, database 
C) Individual, department, enterprise 
D) None of these

Question 16

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 analysis 
A) Clustering objective analysis 
B) Statistical analysis 
C) Entity modeling 
D) Market basket analysis

Question 17

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. 
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.

Question 18

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 spreadsheets 
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 spreadsheets

Question 19

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 constraints 
A) Information integrity 
B) Integrity constraints 
C) Relational integrity constraints 
D) Business-critical integrity constraints

Question 20

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...

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

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

What is the ultimate outcome of a data warehouse?

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.

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

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

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

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

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

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

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

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

Which of the following represents the different information levels?

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

Which of the following represents the different information granularities?

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

Which of the following statements is true?

Which of the following are examples of transactional information?

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

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

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters

Exam 6: Data: Business Intelligence

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

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

What is the ultimate outcome of a data warehouse?

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.

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

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

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

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

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

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

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

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

Which of the following represents the different information levels?

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

Which of the following represents the different information granularities?

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

Which of the following statements is true?

Which of the following are examples of transactional information?

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

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

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters