Question 1

Which of the following occurs when the same data element has different values?

Accepted Answer

A)   Data modeling issue
B)   Data mining issue
C)   Data governance issue
D)   Information inconsistency issueE) None of the above
F) B) and D)

Question 2

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Accepted Answer

A)   Data model
B)   Data element
C)   Data mining tool
D)   Data mart toolE) A) and D)
F) B) and D)

Question 3

Time-series information is time-stamped information collected at a particular frequency.

Accepted Answer

A) True 
 B)False

Question 4

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business has been?

Accepted Answer

A)   A historical perspective offers important variables for determining trends and patterns.
B)   Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control.
C)   Setting strategic direction is critical for planning and creating solid business strategies.
D)   None of these choicesE) A) and B)
F) A) and C)

Question 5

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

Question 6

Information quality refers to the extent of detail within the information (fine and detailed,or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 7

The complete removal of dirty data from a source is practical and possible.

Accepted Answer

A) True 
 B)False

Question 8

Explain the four primary traits that determine the value of information.

Accepted Answer

Information is data converted into a mea...

Question 9

Which of the following is an examples of an external databases in the data warehouse model?

Accepted Answer

A)   Marketing information
B)   Sales information
C)   Competitor information
D)   All of these choicesE) A) and D)
F) A) and C)

Question 10

What is a collection of large,complex data sets,including structured and unstructured data,which can't be analyzed using traditional database methods and tools?

Accepted Answer

A)   Big Data
B)   Distributed computing
C)   Advanced analytics
D)   Data scientistE) None of the above
F) C) and D)

Question 11

Static information includes data that changes based on user actions.

Accepted Answer

A) True 
 B)False

Question 12

What is the term for when a company examines its data to determine if it can meet business expectations,while identifying possible data gaps or where missing data might exist?

Accepted Answer

A)   Data steward
B)   Data stewardship
C)   Data validation
D)   Data gap analysisE) A) and B)
F) None of the above

Question 13

Information integrity are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 16

Clustering assigns records to one of a predefined set of classes.

Accepted Answer

A) True 
 B)False

Question 17

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Accepted Answer

A)   Data mining tools
B)   Structured example language
C)   Query-by-example tool
D)   Relational query toolE) A) and B)
F) None of the above

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the below represents the three common types of information found throughout an organization?

Accepted Answer

A)   Levels,forms,granularities
B)   Levels,forms,data
C)   Levels,formats,granularities
D)   Data,formats,granularitiesE) A) and D)
F) B) and C)

Question 20

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

Accepted Answer

A)   Is the name spelled correctly?
B)   Is the email address invalid?
C)   Does the name and the phone values have the exact same information?
D)   Is aggregate information in agreement with detailed information?E) B) and D)
F) None of the above

Exam 6: Data: Business Intelligence

Static information includes data that changes based on user actions.

Correct AnswerverifiedShow Answer

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Correct AnswerverifiedShow Answer

Clustering assigns records to one of a predefined set of classes.

Correct AnswerverifiedShow Answer

Information integrity are rules that help ensure the quality of information.

Correct AnswerverifiedShow Answer

Which of the following occurs when the same data element has different values?

Correct AnswerverifiedShow Answer

Explain the four primary traits that determine the value of information.

Correct AnswerverifiedInformation is data converted into a mea...View AnswerShow Answer

Data warehouses struggle with combining too much standardized information.

Correct AnswerverifiedShow Answer

What is the term for when a company examines its data to determine if it can meet business expectations,while identifying possible data gaps or where missing data might exist?

Correct AnswerverifiedShow Answer

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the below represents the three common types of information found throughout an organization?

Correct AnswerverifiedShow Answer

Which of the following is an examples of an external databases in the data warehouse model?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a collection of large,complex data sets,including structured and unstructured data,which can't be analyzed using traditional database methods and tools?

Correct AnswerverifiedShow Answer

Time-series information is time-stamped information collected at a particular frequency.

Correct AnswerverifiedShow Answer

The complete removal of dirty data from a source is practical and possible.

Correct AnswerverifiedShow Answer

Information quality refers to the extent of detail within the information (fine and detailed,or coarse and abstract).

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the two different categories for information type?

Correct AnswerverifiedShow Answer

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business has been?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Information is data converted into a mea...
View 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