Question 1

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

Accepted Answer

A) A database can support only one logical view. 
B) A database can support many physical views. 
C) A database can support many logical views. 
D) A database can support up to 3 logical views.

Question 2

What is analysis paralysis?

Accepted Answer

A) processes and manages algorithms across many machines in a computing environment 
B) focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization 
C) 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 
D) a business analytics specialist who uses visual tools to help people understand complex data

Question 3

What is data mining?

Accepted Answer

A) the common term for the representation of multidimensional information 
B) a particular attribute of information 
C) uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making 
D) process of analyzing data to extract information not offered by the raw data alone

Question 4

Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Accepted Answer

A) True 
 B)False

Question 5

Social media analytics analyzes text flowing across the Internet, including unstructured text from blogs and messages.

Accepted Answer

A) True 
 B)False

Question 6

What can present the results of large data analysis, looking for patterns and relationships that monitor changes in variables over time?

Accepted Answer

A) informing 
B) infographics 
C) data visualization 
D) business intelligence dashboards

Question 7

What is the primary problem with redundant information?

Accepted Answer

A) It is difficult to determine which values are the most current. 
B) It is often inconsistent. 
C) It is difficult to determine which values are the most accurate. 
D) All of these are correct.

Question 8

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals, and generating financial analysis across departments and the enterprise as a whole for the executive team to review.Ben's duties provide value-added to his company and would be categorized as occurring at the different information ________.

Accepted Answer

A) lists 
B) formats 
C) granularities 
D) levels

Question 9

What is information inconsistency?

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 10

Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?

Accepted Answer

A) data analysis tools 
B) electronic analysis tools 
C) data-mining tools 
D) data integrity tools

Question 11

What are rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A) information integrity 
B) integrity constraint 
C) business-critical integrity constraint 
D) relational integrity constraint

Question 12

What refers to the overall management of the availability, usability, integrity, and security of company data?

Accepted Answer

A) information inconsistency 
B) information integrity issues 
C) data governance 
D) master data management

Question 13

The four common characteristics of big data include variety, veracity, volume, velocity.

Accepted Answer

A) True 
 B)False

Question 14

The four primary traits of the value of information include levels, formats, granularities, and type.

Accepted Answer

A) True 
 B)False

Question 15

What is web analytics?

Accepted Answer

A) analyzes text flowing across the Internet, including unstructured text from blogs and messages 
B) the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise 
C) analyzes unstructured data to find trends and patterns in words and sentences 
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation

Question 16

What is data that humans, in interaction with computers, generate?

Accepted Answer

A) structured data 
B) machine-generated data 
C) human-generated data 
D) unstructured data

Question 17

How would the banking 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 18

What processes and manages algorithms across many machines in a computing environment?

Accepted Answer

A) big data 
B) distributed computing 
C) advanced analytics 
D) data scientist

Question 19

Which of the following is not a primary trait of information?

Accepted Answer

A) governance 
B) type 
C) timeliness 
D) quantity

Question 20

Volume includes the uncertainty of data, including biases, noise, and abnormalities.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

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

What is analysis paralysis?

What is data mining?

Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible; for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Social media analytics analyzes text flowing across the Internet, including unstructured text from blogs and messages.

What can present the results of large data analysis, looking for patterns and relationships that monitor changes in variables over time?

What is the primary problem with redundant information?

What is information inconsistency?

Which of the following uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making?

What are rules that enforce basic and fundamental information-based constraints?

What refers to the overall management of the availability, usability, integrity, and security of company data?

The four common characteristics of big data include variety, veracity, volume, velocity.

The four primary traits of the value of information include levels, formats, granularities, and type.

What is web analytics?

What is data that humans, in interaction with computers, generate?

How would the banking industry use business intelligence?

What processes and manages algorithms across many machines in a computing environment?

Which of the following is not a primary trait of information?

Volume includes the uncertainty of data, including biases, noise, and abnormalities.