Question 1

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following identifies the primary location where data is collected?

Accepted Answer

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

Question 3

Businesses collect a tremendous amount of ________ information as part of their routine operations.

Accepted Answer

A)  operational
B)  transactional
C)  aggregate
D)  comparativeE) None of the above
F) A) and B)

Question 4

What is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover?

Accepted Answer

A)  Prediction
B)  Optimization
C)  Forecasting
D)  RegressionE) A) and B)
F) A) and C)

Question 5

In terms of big data what includes the analysis of streaming data as it travels around the Internet?

Accepted Answer

A)  Variety
B)  Veracity
C)  Volume
D)  VelocityE) All of the above
F) A) and B)

Question 6

What is regression?

Accepted Answer

A)  A statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.
B)  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.
C)  Predictions based on time-series information.
D)  A statistical process for estimating the relationships among variables.E) None of the above
F) A) and B)

Question 7

What is a field that uniquely identifies a given record in a table?

Accepted Answer

A)  Foreign key
B)  Primary key
C)  Data mining key
D)  DBMS keyE) A) and D)
F) B) and D)

Question 8

What 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)  Distributed computing
B)  Advanced analytics
C)  Analysis paralysis
D)  Data artistE) All of the above
F) B) and C)

Question 9

What is optimization?

Accepted Answer

A)  A statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.
B)  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.
C)  Predictions based on time-series information.
D)  A statistical process for estimating the relationships among variables.E) None of the above
F) All of the above

Question 10

The core component of any system, regardless of size, is a database and a database management system.

Accepted Answer

A) True 
 B)False

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

Question 12

Attributes (also called columns or fields)are the data elements associated with an entity.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following would not be considered part of the complete characteristic of high-quality information?

Accepted Answer

A)  Is a value missing from the personal information?
B)  Is each transaction represented only once in the information?
C)  Is the address incomplete?
D)  Is the area code missing for the phone information?E) C) and D)
F) None of the above

Question 14

Data latency is the time it takes for data to be stored or retrieved.

Accepted Answer

A) True 
 B)False

Question 15

What 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)  Analytical paradox
B)  Analytical analysis
C)  Analysis paralysis
D)  Analysis paradoxE) C) and D)
F) A) and D)

Question 16

Which of the following illustrates the primary concepts of the relational database model?

Accepted Answer

A)  Ethics, applications, keys, and relationships
B)  Entities, attributes, keys, and relationships
C)  Endeavor, aspire, control, and regulate
D)  Early, after, before, and futureE) A) and D)
F) None of the above

Question 17

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

Accepted Answer

A)  Distributed computing
B)  Advanced analytics
C)  Analysis paralysis
D)  Data artistE) A) and B)
F) A) and C)

Question 18

What are the two different categories for information type?

Accepted Answer

A)  Analytical and productive
B)  Analytical and analysis
C)  Transactional and analytical
D)  Transactional and analysisE) All of the above
F) A) and C)

Question 19

Forecasts are predictions based on time-series information.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Accepted Answer

A)  Quality business constraints
B)  Critical web constraints
C)  Business critical integrity constraints
D)  Web integrity constraintsE) A) and B)
F) A) and C)

Exam 6: Data: Business Intelligence

Attributes (also called columns or fields)are the data elements associated with an entity.

Correct AnswerverifiedShow Answer

Which of the following would not be considered part of the complete characteristic of high-quality information?

Correct AnswerverifiedShow Answer

In terms of big data what includes the analysis of streaming data as it travels around the Internet?

Correct AnswerverifiedShow Answer

What is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover?

Correct AnswerverifiedShow Answer

Data latency is the time it takes for data to be stored or retrieved.

Correct AnswerverifiedShow Answer

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

What is optimization?

Correct AnswerverifiedShow Answer

The core component of any system, regardless of size, is a database and a database management system.

Correct AnswerverifiedShow Answer

Forecasts are predictions based on time-series information.

Correct AnswerverifiedShow Answer

What 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 are the two different categories for information type?

Correct AnswerverifiedShow Answer

Which of the following illustrates the primary concepts of the relational database model?

Correct AnswerverifiedShow Answer

What is a field that uniquely identifies a given record in a table?

Correct AnswerverifiedShow Answer

Businesses collect a tremendous amount of ________ information as part of their routine operations.

Correct AnswerverifiedShow Answer

Which of the following identifies the primary location where data is collected?

Correct AnswerverifiedShow Answer

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Correct AnswerverifiedShow Answer

What 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 are rules that enforce basic and fundamental information-based constraints?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is regression?

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

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