Question 1

Which of the following stores information about a person,place,thing,transaction,or event,and is usually referred to as a table?

Accepted Answer

A)   Entity
B)   Extraction
C)   Attribute
D)   Foreign keyE) A) and D)
F) None of the above

Question 2

Source data identifies the primary location where data is collected.It can include invoices,spreadsheets,time-sheets,transactions,and electronic sources such as other databases.

Accepted Answer

A) True 
 B)False

Question 3

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Accepted Answer

A)   4% lower,6% higher
B)   4% higher,6% lower
C)   4% higher,6% higher
D)   4% lower,6% lowerE) A) and D)
F) C) and D)

Question 4

A data warehouse is a _________ collection of information,gathered from many different ___________ databases,that supports business analysis activities and decision-making tasks.

Accepted Answer

A)   logical; operational
B)   physical; operational
C)   logical; transactional
D)   physical; transactionalE) A) and B)
F) C) and D)

Question 5

Which of the following is an examples of external databases in the data warehouse model?

Accepted Answer

A)   Marketing,sales,inventory,and billing
B)   Data mart 1,data mart 2,and data mart 3
C)   Competitor and industry information,mailing lists,and stock market analysis
D)   Marketing information,sales information,and stock market analysisE) B) and C)
F) A) and B)

Question 6

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Accepted Answer

A) True 
 B)False

Question 7

Reports for each sales person,product,and part are examples of detail (or fine)information granularities.

Accepted Answer

A) True 
 B)False

Question 8

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Accepted Answer

A) True 
 B)False

Question 9

What determines which things go together?

Accepted Answer

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

Question 10

Entities are the data elements associated with an attribute.

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

The four primary traits of the value of information include type,timeliness,quality,and governance.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following encompasses all of the information contained within a single business process or unit of work,and its primary purpose is to support daily operational tasks?

Accepted Answer

A)   Targeted information
B)   Analytical information
C)   Productive information
D)   Transactional informationE) C) and D)
F) A) and B)

Question 14

Which of the following is not one of the five characteristics common to high-quality information?

Accepted Answer

A)   Accuracy
B)   Completeness
C)   Quantity
D)   ConsistencyE) A) and B)
F) None of the above

Question 15

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

Accepted Answer

Extraction,transformation,and loading (E...

Question 16

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

A)   Structured query language
B)   Relational query language
C)   Structured elements
D)   Data mining toolsE) B) and D)
F) All of the above

Question 17

What analyzes unstructured data associated with websites to identify consumer behavior and website navigation?

Accepted Answer

A)   Social media analytics
B)   Speech analytics
C)   Text analytics
D)   Web analyticsE) B) and D)
F) B) and C)

Question 18

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 19

Which of the below questions can be answered using business intelligence?

Accepted Answer

A)   Where has the business been?
B)   Where is the business now?
C)   Where is the business going?
D)   All of these choicesE) All of the above
F) A) and B)

Question 20

What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken,in effect paralyzing the outcome?

Accepted Answer

A)   Distributed computing
B)   Advanced analytics
C)   Analysis paralysis
D)   Data artistE) C) and D)
F) A) and D)

Exam 6: Data: Business Intelligence

Which of the following asks users to write lines of code to answer questions against a database?

Correct AnswerverifiedShow Answer

What analyzes unstructured data associated with websites to identify consumer behavior and website navigation?

Correct AnswerverifiedShow Answer

Which of the following is not one of the five characteristics common to high-quality information?

Correct AnswerverifiedShow Answer

Which of the below questions can be answered using business intelligence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to perform transactional processes.

Correct AnswerverifiedShow Answer

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

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

What occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken,in effect paralyzing the outcome?

Correct AnswerverifiedShow Answer

The four primary traits of the value of information include type,timeliness,quality,and governance.

Correct AnswerverifiedShow Answer

Entities are the data elements associated with an attribute.

Correct AnswerverifiedShow Answer

Which of the following is an examples of external databases in the data warehouse model?

Correct AnswerverifiedShow Answer

Reports for each sales person,product,and part are examples of detail (or fine)information granularities.

Correct AnswerverifiedShow Answer

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Correct AnswerverifiedShow Answer

Which of the following encompasses all of the information contained within a single business process or unit of work,and its primary purpose is to support daily operational tasks?

Correct AnswerverifiedShow Answer

A data warehouse is a _________ collection of information,gathered from many different ___________ databases,that supports business analysis activities and decision-making tasks.

Correct AnswerverifiedShow Answer

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.

Correct AnswerverifiedShow Answer

Which of the following stores information about a person,place,thing,transaction,or event,and is usually referred to as a table?

Correct AnswerverifiedShow Answer

Source data identifies the primary location where data is collected.It can include invoices,spreadsheets,time-sheets,transactions,and electronic sources such as other databases.

Correct AnswerverifiedShow Answer

Web mining analysis describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Correct AnswerverifiedShow Answer

What determines which things go together?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Extraction,transformation,and loading (E...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

A data warehouse is a _ collection of information,gathered from many different ___ databases,that supports business analysis activities and decision-making tasks.

Correct Answer
verified

Data-driven decision management is usually undertaken as a way to gain a competitive advantage.A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _ productivity rates and ____ profits.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified