Question 1

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.E) None of the above
F) B) and C)

Question 2

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 numbersE) B) and D)
F) None of the above

Question 3

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

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

Question 9

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

Question 10

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

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

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, transactionalE) A) and B)
F) A) and C)

Question 13

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)  QualityE) A) and B)
F) None of the above

Question 14

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 15

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

Accepted Answer

A)  Content creator
B)  Content editor
C)  Static information
D)  Dynamic informationE) B) and C)
F) All of the above

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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 AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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 ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is data-driven decision management?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

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

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

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