Question 1

When does information cleansing occur in the data warehouse?

Accepted Answer

A) During the ETL process 
B) On the information, once it is in the data warehouse 
C) During the ETL process and once it is in the data warehouse 
D) During the ETL process and before it is in the data warehouse 
A) During the ETL process 
B) On the information, once it is in the data warehouse 
C) During the ETL process and once it is in the data warehouse 
D) During the ETL process and before it is in the data warehouse

Question 2

Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except:

Accepted Answer

A) Inability to accurately track customers 
B) Inability to identify selling opportunities 
C) Success of the organization depends on appreciating and leveraging the low-quality information 
D) Lost revenue opportunities from marketing to nonexistent customers 
A) Inability to accurately track customers 
B) Inability to identify selling opportunities 
C) Success of the organization depends on appreciating and leveraging the low-quality information 
D) Lost revenue opportunities from marketing to nonexistent customers

Question 3

Explain ETL and the role of a data mart in business.

Accepted Answer

Extraction, transformation, and loading

Question 4

Which of the following refers to the extent of detail within the information?

Accepted Answer

A) Knowledge information 
B) Information granularity 
C) Chance information 
D) Information analytics 
A) Knowledge information 
B) Information granularity 
C) Chance information 
D) Information analytics

Question 5

Which of the following defines the relationship between variables along with the nature and frequency of the relationship?

Accepted Answer

A) Association detection 
B) Masking detection tool 
C) Cluster grouping 
D) Blocking barriers 
A) Association detection 
B) Masking detection tool 
C) Cluster grouping 
D) Blocking barriers

Question 6

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A) Data inconsistency issue 
B) Data integrity issue 
C) Data control issue 
D) Data mining issue 
A) Data inconsistency issue 
B) Data integrity issue 
C) Data control issue 
D) Data mining issue

Question 7

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 8

A data-driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Accepted Answer

The answer of A data-driven _________ is an interactive website...

Question 9

Which of the following contains a subset of data warehouse information?

Accepted Answer

A) Data miner 
B) Data mart 
C) Data pool 
D) Data analyzing tool 
A) Data miner 
B) Data mart 
C) Data pool 
D) Data analyzing tool

Question 10

A ___________ database model stores information in the form of logically related two-dimensional tables.

Accepted Answer

The answer of A ___________ database model stores information in...

Question 11

Which of the following occurs during data cleansing?

Accepted Answer

A) Clean missing records 
B) Clean redundant records 
C) Clean inaccurate data 
D) All of these 
A) Clean missing records 
B) Clean redundant records 
C) Clean inaccurate data 
D) All of these

Question 12

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

Accepted Answer

A) A database can be relational or network. 
B) Database information is accessed by logical structure. 
C) Database information is accessed by physical structure. 
D) Database users can have different views of information. 
A) A database can be relational or network. 
B) Database information is accessed by logical structure. 
C) Database information is accessed by physical structure. 
D) Database users can have different views of information.

Question 13

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

Question 14

What is data redundancy?

Accepted Answer

A) Duplication of data 
B) Storing the same data in multiple places 
C) Storing duplicate data in multiple places 
D) All of these 
A) Duplication of data 
B) Storing the same data in multiple places 
C) Storing duplicate data in multiple places 
D) All of these

Question 15

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 16

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following offers an advantage of using a data-driven website?

Accepted Answer

A) Easy to eliminate human errors 
B) Easy to manage content 
C) Easy to store large amounts of data 
D) All of these 
A) Easy to eliminate human errors 
B) Easy to manage content 
C) Easy to store large amounts of data 
D) All of these

Question 18

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

A) True 
 B)False

Question 19

What are the three common forms for mining structured and unstructured data?

Accepted Answer

A) Cluster analysis, association detection, and statistical analysis 
B) Cluster analysis, association detection, and disassociation detection 
C) Cluster analysis statistical detection, and statistical analysis 
D) Association detection, market-basket analysis, and market-basket association 
A) Cluster analysis, association detection, and statistical analysis 
B) Cluster analysis, association detection, and disassociation detection 
C) Cluster analysis statistical detection, and statistical analysis 
D) Association detection, market-basket analysis, and market-basket association

Question 20

What is another term for data that do not exist in a fixed location?

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

When does information cleansing occur in the data warehouse?

Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except:

Explain ETL and the role of a data mart in business.

Which of the following refers to the extent of detail within the information?

Which of the following defines the relationship between variables along with the nature and frequency of the relationship?

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

A foreign key provides details about data.

A data-driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Which of the following contains a subset of data warehouse information?

A ___________ database model stores information in the form of logically related two-dimensional tables.

Which of the following occurs during data cleansing?

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

Which of the following describes ETL?

What is data redundancy?

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

A data miner contains a subset of data warehouse information.

Which of the following offers an advantage of using a data-driven website?

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

What are the three common forms for mining structured and unstructured data?

What is another term for data that do not exist in a fixed location?

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

When does information cleansing occur in the data warehouse?

Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except:

Explain ETL and the role of a data mart in business.

Which of the following refers to the extent of detail within the information?

Which of the following defines the relationship between variables along with the nature and frequency of the relationship?

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

A foreign key provides details about data.

A data-driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Which of the following contains a subset of data warehouse information?

A ___________ database model stores information in the form of logically related two-dimensional tables.

Which of the following occurs during data cleansing?

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

Which of the following describes ETL?

What is data redundancy?

Within the data warehouse model, the external databases could include competitor information, industry information, and stock market analysis.

A data miner contains a subset of data warehouse information.

Which of the following offers an advantage of using a data-driven website?

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

What are the three common forms for mining structured and unstructured data?

What is another term for data that do not exist in a fixed location?

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