Question 1

Which of the following is a problem associated with dirty data?

Accepted Answer

A)   Accurate data
B)   Integrated data
C)   Violates business rules
D)   All of these choicesE) A) and B)
F) C) and D)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following represents the different information levels?

Accepted Answer

A)   Detail,summary,aggregate
B)   Document,presentation,spreadsheet,database
C)   Individual,department,enterprise
D)   Executives,managers,operational employeesE) A) and B)
F) A) and C)

Question 4

According to Gartner Inc.,dirty data is an MIS problem,not a business problem.

Accepted Answer

A) True 
 B)False

Question 5

What is clustering?

Accepted Answer

A)   Determines values for an unknown continuous variable behavior or estimated future value
B)   Determines which things go together
C)   Segments a heterogeneous population of more homogeneous subgroups
D)   Assigns records to one of a predefined set of classesE) C) and D)
F) A) and C)

Question 6

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

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

Question 7

Which of the following is a valid type of integrity constraint?

Accepted Answer

A)   Relational-critical integrity constraint
B)   Business integrity constraint
C)   Relational integrity constraint
D)   Business-critical integrity constraintE) A) and B)
F) A) and C)

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

Question 9

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 10

The four common characteristics of Big Data include variety,veracity,volume,velocity.

Accepted Answer

A) True 
 B)False

Question 11

A data element (or data field)is the smallest or basic unit of information.

Accepted Answer

A) True 
 B)False

Question 12

What displays information graphically so it can be easily understood?

Accepted Answer

A)   Informing
B)   Infographics
C)   Data visualization
D)   Business intelligence dashboardsE) A) and C)
F) B) and C)

Question 13

Unique information asks if each transaction and event represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 14

What is text analytics?

Accepted Answer

A)   Analyzes text flowing across the Internet,including unstructured text from blogs and messages
B)   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
C)   Analyzes unstructured data to find trends and patterns in words and sentences
D)   Analyzes unstructured data associated with websites to identify consumer behavior and website navigationE) B) and C)
F) A) and B)

Question 15

Which of the following creates,reads,updates,and deletes data in a database while controlling access and security?

Accepted Answer

A)   Database element
B)   Database management system
C)   Data governance
D)   Data FileE) A) and B)
F) A) and C)

Question 16

Relational database models store information in the form of logically related two-dimensional tables.

Accepted Answer

A) True 
 B)False

Question 17

Information integrity issues occur when a system produces incorrect,inconsistent,or duplicate data.

Accepted Answer

A) True 
 B)False

Question 18

Veracity includes the uncertainty of data,including biases,noise,and abnormalities.

Accepted Answer

A) True 
 B)False

Question 19

Data governance refers to the overall management of the availability,usability,integrity,and security of company data.

Accepted Answer

A) True 
 B)False

Question 20

What is the smallest or basic unit of information?

Accepted Answer

A)   Database management element
B)   Data element
C)   Data model
D)   Data integrity issueE) A) and C)
F) A) and D)

Exam 6: Data: Business Intelligence

Veracity includes the uncertainty of data,including biases,noise,and abnormalities.

Correct AnswerverifiedShow Answer

What displays information graphically so it can be easily understood?

Correct AnswerverifiedShow Answer

Unique information asks if each transaction and event represented only once in the information.

Correct AnswerverifiedShow Answer

Information integrity issues occur when a system produces incorrect,inconsistent,or duplicate data.

Correct AnswerverifiedShow Answer

Relational database models store information in the form of logically related two-dimensional tables.

Correct AnswerverifiedShow Answer

Which of the following is a problem associated with dirty data?

Correct AnswerverifiedShow Answer

A data element (or data field)is the smallest or basic unit of information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

According to Gartner Inc.,dirty data is an MIS problem,not a business problem.

Correct AnswerverifiedShow Answer

Data governance refers to the overall management of the availability,usability,integrity,and security of company data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following creates,reads,updates,and deletes data in a database while controlling access and security?

Correct AnswerverifiedShow Answer

Which of the following is a valid type of integrity constraint?

Correct AnswerverifiedShow Answer

Which of the following represents the different information levels?

Correct AnswerverifiedShow Answer

What is text analytics?

Correct AnswerverifiedShow Answer

What is clustering?

Correct AnswerverifiedShow Answer

What is the smallest or basic unit of information?

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

The four common characteristics of Big Data include variety,veracity,volume,velocity.

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