Question 1

Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization?

Accepted Answer

A)  Levels, forms, granularities
B)  Levels, forms, data
C)  Levels, formats, granularities
D)  Data, formats, granularitiesE) A) and D)
F) B) and C)

Question 2

Describe a database, a database management system, and the relational database model.

Accepted Answer

A database maintains information about v...

Question 3

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 the above.E) All of the above
F) A) and D)

Question 4

What is another term for information cleansing?

Accepted Answer

A)  Information mining
B)  Information scrubbing
C)  Information scrapping
D)  Information martsE) A) and B)
F) A) and C)

Question 5

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following implies that information is current with respect to the business requirement?

Accepted Answer

A)  Uniqueness
B)  Accuracy
C)  Consistency
D)  TimelinessE) A) and C)
F) A) and B)

Question 7

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)  Statistical detection
B)  Cluster analysis
C)  Association detection
D)  Social media analyticsE) A) and D)
F) None of the above

Question 8

Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?

Accepted Answer

A)  Inconsistent data definitions.
B)  Lack of data standards.
C)  Effective direct data access.
D)  Poor data quality.E) A) and B)
F) B) and D)

Question 9

Accurate information asks if there is an incorrect value in the information.

Accepted Answer

A) True 
 B)False

Question 10

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) All of the above
F) A) and C)

Question 11

What is being accomplished by affinity grouping?

Accepted Answer

A)  Determines values for an unknown continuous variable behavior or estimated future value.
B)  Determines which things go together.
C)  Segments a heterogeneous population of more homogeneous subgroups.
D)  Assigns records to one of a predefined set of classes.E) C) and D)
F) None of the above

Question 12

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 13

Social media analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Accepted Answer

A) True 
 B)False

Question 14

Variety includes different forms of structured and unstructured data.

Accepted Answer

A) True 
 B)False

Question 15

A data set is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 16

What are information integrity issues?

Accepted Answer

A)  Occurs when the same data element has different values.
B)  Occurs when a system produces incorrect, inconsistent, or duplicate data.
C)  Refers to the overall management of the availability, usability, integrity, and security of company data.
D)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.E) A) and B)
F) All of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What occurs when the same data element has different values?

Accepted Answer

A)  Information inconsistency
B)  Information integrity issues
C)  Data governance
D)  Master data managementE) B) and C)
F) B) and D)

Question 19

Consistent information asks if the aggregate or summary information in agreement with detailed information.

Accepted Answer

A) True 
 B)False

Question 20

How would the insurance industry use business intelligence?

Accepted Answer

A)  Analyze popular vacation locations with current flight listings
B)  Understand customer credit card usage and nonpayment rates
C)  Compare the demographics of patients with critical illnesses
D)  Predict claim amounts and medical coverage costsE) A) and B)
F) A) and C)

Exam 6: Data: Business Intelligence

Data elements can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Correct AnswerverifiedShow Answer

What is being accomplished by affinity grouping?

Correct AnswerverifiedShow Answer

Consistent information asks if the aggregate or summary information in agreement with detailed information.

Correct AnswerverifiedShow Answer

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Correct AnswerverifiedShow Answer

What occurs when the same data element has different values?

Correct AnswerverifiedShow Answer

What are information integrity issues?

Correct AnswerverifiedShow Answer

Social media analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Correct AnswerverifiedShow Answer

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

Accurate information asks if there is an incorrect value in the information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is another term for information cleansing?

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

Which of the following implies that information is current with respect to the business requirement?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data set is an individual item on a graph or chart.

Correct AnswerverifiedShow Answer

Variety includes different forms of structured and unstructured data.

Correct AnswerverifiedShow Answer

Describe a database, a database management system, and the relational database model.

Correct AnswerverifiedA database maintains information about v...View AnswerShow Answer

How would the insurance industry use business intelligence?

Correct AnswerverifiedShow Answer

Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization?

Correct AnswerverifiedShow Answer

Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?

Correct AnswerverifiedShow 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
A database maintains information about v...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified