Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 information

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What is another term for information cleansing?

Accepted Answer

A) Information mining 
B) Information scrubbing 
C) Information scrapping 
D) Information marts

Question 5

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.

Question 6

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 management

Question 7

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.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Variety includes different forms of structured and unstructured data.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

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

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.

Question 14

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 costs

Question 15

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.

Question 16

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

Accepted Answer

The answer of Describe a database, a database management system,...

Question 17

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 18

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

Question 19

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 analytics

Question 20

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

Accepted Answer

A) Uniqueness 
B) Accuracy 
C) Consistency 
D) Timeliness

Exam 6: Data: Business Intelligence

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

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?

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

What is another term for information cleansing?

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

What occurs when the same data element has different values?

What are information integrity issues?

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

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

Variety includes different forms of structured and unstructured data.

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

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

What is being accomplished by affinity grouping?

How would the insurance industry use business intelligence?

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

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

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

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?

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?

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