Question 1

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

Accepted Answer

A) Comparative analysis. 
B) Competitive monitoring. 
C) Data-driven decision management. 
D) Source data.

Question 2

What is an individual item on a graph or a chart?

Accepted Answer

A) Data set. 
B) Dirty data. 
C) Data map. 
D) Data point.

Question 3

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) Regression

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?

Accepted Answer

A) Transactional information 
B) Analytical information 
C) Timeliness 
D) Quality

Question 6

Which of the following contains a subset of data warehouse information?

Accepted Answer

A) Data miner 
B) Data mart 
C) Data pool 
D) Data analyzing tool

Question 7

Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Accepted Answer

A) Business intelligence system 
B) Informational database system 
C) Relational database management system 
D) Data mining system

Question 9

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

Question 10

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Accepted Answer

A) True 
 B)False

Question 11

Analysis paralysis 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) True 
 B)False

Question 12

Gender can be referred to in many ways (Male, Female, M/F, 1/0)in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

Accepted Answer

A) Information scaling 
B) Streamlining data points 
C) Standardizing information 
D) Standardizing protocols

Question 13

Primary key is a field (or group of fields)that uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What is the process of analyzing data to extract information not offered by the raw data alone?

Accepted Answer

A) Data integrity 
B) Data mart analysis 
C) Data mining 
D) Data extraction

Question 16

What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?

Accepted Answer

A) Clustering factors 
B) Mashup technology 
C) Market basket analysis 
D) Drill-down basket analysis

Question 17

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

Accepted Answer

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

Question 18

What is data-driven decision management?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 19

Who is the person responsible for creating the original website content?

Accepted Answer

A) Content creator 
B) Content editor 
C) Static information 
D) Dynamic information

Question 20

Which of the following is not an advantage to a data-driven website?

Accepted Answer

A) Development 
B) Minimizing human error 
C) Increasing update costs 
D) More efficient

Exam 6: Data: Business Intelligence

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

What is an individual item on a graph or a chart?

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?

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

What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?

Which of the following contains a subset of data warehouse information?

Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.

Which of the following systems allow users to create, read, update, and delete data in a relational database?

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

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Analysis paralysis 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.

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

Primary key is a field (or group of fields)that uniquely identifies a given record in a table.

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

What is the process of analyzing data to extract information not offered by the raw data alone?

What is a common association detection analysis technique where you analyze certain items to detect customers' buying behavior and predict future behavior?

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

What is data-driven decision management?

Who is the person responsible for creating the original website content?

Which of the following is not an advantage to a data-driven website?