Question 1

While a traditional data warehouse stores data in files or folders,a data lake uses a flat architecture to store data.

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

How would the law enforcement industry use business intelligence?

Accepted Answer

A)   Track crime patterns,locations,and criminal behavior
B)   Analyze customer demographics
C)   Predict sales,inventory levels,and distribution
D)   Predict hardware failuresE) B) and C)
F) A) and D)

Question 4

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False  False

Question 5

A data mart contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A)   Dynamic website
B)   Data-driven website
C)   Static information
D)   Dynamic informationE) A) and B)
F) A) and C)

Question 8

The primary purpose of a data warehouse is to perform analytical process.

Accepted Answer

A) True 
 B)False

Question 9

Affinity determines values for an unknown continuous variable behavior or estimated future value.

Accepted Answer

A) True 
 B)False

Question 10

How would the retail industry use business intelligence?

Accepted Answer

A)   Track crime patterns,locations,and criminal behavior
B)   Analyze customer demographics
C)   Predict sales,inventory levels,and distribution
D)   Predict hardware failuresE) A) and B)
F) B) and C)

Question 11

What 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)   Prediction
B)   Optimization
C)   Forecasting
D)   RegressionE) B) and C)
F) C) and D) B

Question 12

Classification segments a heterogeneous population of more homogeneous subgroups.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following refers to immediate,up-to-date information?

Accepted Answer

A)   Daily information
B)   Strategic information
C)   Real-time information
D)   Crisis informationE) A) and C)
F) B) and D)

Question 14

What is it called when each transaction,entity,and event is represented only once in the information?

Accepted Answer

A)   Uniqueness
B)   Accuracy
C)   Consistency
D)   TimelinessE) B) and C)
F) All of the above

Question 15

Consistent information asks if there is a value missing from the information.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not an information cleansing activity?

Accepted Answer

A)   Identifies redundant records
B)   Identifies inaccurate or incomplete data
C)   Identifies missing records or attributes
D)   Identifies sales trendsE) B) and C)
F) A) and C)

Question 17

A central location in which data is stored and managed is called a data mart.

Accepted Answer

A) True 
 B)False  False

Question 18

There are only two main primary traits that help you determine the value of information including timeliness and quality.

Accepted Answer

A) True 
 B)False

Question 19

What is 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?

Accepted Answer

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

Question 20

What is a data value that is numerically distant from most of the other data points in a set of data?

Accepted Answer

A)   Fast data
B)   Outlier
C)   Analysis paralysis
D)   CubeE) B) and C)
F) A) and D)

Exam 6: Data: Business Intelligence

While a traditional data warehouse stores data in files or folders,a data lake uses a flat architecture to store data.

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

Correct AnswerverifiedShow Answer

How would the law enforcement industry use business intelligence?

Correct AnswerverifiedShow Answer

One of the advantages found in a relational database is increased information redundancy.

Correct AnswerverifiedFalse

A data mart contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

How would the banking industry use business intelligence?

Correct AnswerverifiedShow Answer

What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to perform analytical process.

Correct AnswerverifiedShow Answer

Affinity determines values for an unknown continuous variable behavior or estimated future value.

Correct AnswerverifiedShow Answer

How would the retail industry use business intelligence?

Correct AnswerverifiedShow Answer

What 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?

Correct AnswerverifiedB

Classification segments a heterogeneous population of more homogeneous subgroups.

Correct AnswerverifiedShow Answer

Which of the following refers to immediate,up-to-date information?

Correct AnswerverifiedShow Answer

What is it called when each transaction,entity,and event is represented only once in the information?

Correct AnswerverifiedShow Answer

Consistent information asks if there is a value missing from the information.

Correct AnswerverifiedShow Answer

Which of the following is not an information cleansing activity?

Correct AnswerverifiedShow Answer

A central location in which data is stored and managed is called a data mart.

Correct AnswerverifiedFalse

There are only two main primary traits that help you determine the value of information including timeliness and quality.

Correct AnswerverifiedShow Answer

What is 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?

Correct AnswerverifiedShow Answer

What is a data value that is numerically distant from most of the other data points in a set of data?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified