Question 1

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.E) A) and C)
F) B) and C)

Question 2

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 issueE) B) and C)
F) A) and B)

Question 3

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 barriersE) A) and B)
F) B) and D)

Question 4

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 5

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 theseE) A) and B)
F) B) and C)

Question 6

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 7

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 customersE) B) and D)
F) All of the above

Question 8

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 analyticsE) A) and B)
F) A) and C)

Question 9

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 theseE) None of the above
F) C) and D)

Question 10

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 toolE) B) and C)
F) A) and B)

Question 11

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 12

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

Accepted Answer

Extraction, transformation, and loading ...

Question 13

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 miningE) All of the above
F) None of the above

Question 14

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 associationE) B) and C)
F) A) and D)

Question 15

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 16

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 theseE) A) and B)
F) A) and C)

Question 17

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 18

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 theseE) A) and B)
F) C) and D)

Question 19

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 warehouseE) B) and C)
F) A) and B)

Question 20

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedExtraction, transformation, and loading ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is data redundancy?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

When does information cleansing occur in the data warehouse?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

A data miner contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Extraction, transformation, and loading ...
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