Question 1

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 2

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

Accepted Answer

A) True 
 B)False

Question 3

Why were data warehouses created?

Accepted Answer

A)  Numbers and types of operational databases increased as businesses grew.
B)  Many companies had information scattered across multiple systems with different formats.
C)  Completing reporting requests from numerous operational systems took days or weeks.
D)  All of these are correct.E) A) and B)
F) None of the above

Question 4

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  inaccurate data
B)  nonintegrated data
C)  violates business rules
D)  All of these are correct.E) B) and C)
F) None of the above

Question 6

A foreign key uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 10

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A)  Data warehouses make quick decisions, data marts make slow decisions.
B)  Data warehouses tackle ethical issues, data marts tackle hypothetical issues.
C)  Data warehouses have a more organization-wide focus, data marts have functional focus.
D)  Data warehouses have a physical focus, data marts have logical focus.E) B) and C)
F) A) and B)

Question 11

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)  statistical detection
B)  cluster analysis
C)  association detection
D)  social media analyticsE) B) and D)
F) C) and D)

Question 12

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Accepted Answer

A) True 
 B)False

Question 13

What do data warehouses support?

Accepted Answer

A)  OLAP
B)  analytical processing
C)  OLTP
D)  OLAP and analytical processingE) B) and C)
F) None of the above

Question 14

Which of the following offers an advantage of using a data-driven website?

Accepted Answer

A)  easy to eliminate human errors
B)  easy to manage content
C)  easy to store large amounts of data
D)  All of these are correct.E) A) and B)
F) None of the above

Question 15

What is 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?

Accepted Answer

A)  social media analytics
B)  speech analytics
C)  text analytics
D)  web analyticsE) A) and B)
F) B) and D)

Question 16

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Accepted Answer

A) True 
 B)False

Question 17

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False

Question 18

Static information includes data that changes based on user actions.

Accepted Answer

A) True 
 B)False

Question 19

What is another term for data that is already contained in a database or a spreadsheet?

Accepted Answer

A)  structured data
B)  unstructured data
C)  text mining
D)  web miningE) C) and D)
F) None of the above

Question 20

What is unstructured data?

Accepted Answer

A)  has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address
B)  created by a machine without human intervention
C)  data that humans, in interaction with computers, generate
D)  not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messagesE) A) and B)
F) A) and C)

Exam 6: Data: Business Intelligence

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

Correct AnswerverifiedShow Answer

ETL, within a data warehouse model, stands for exit, track, and load.

Correct AnswerverifiedShow Answer

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Correct AnswerverifiedShow Answer

What is clustering?

Correct AnswerverifiedShow Answer

What is another term for data that is already contained in a database or a spreadsheet?

Correct AnswerverifiedShow Answer

Why were data warehouses created?

Correct AnswerverifiedShow Answer

What is unstructured data?

Correct AnswerverifiedShow Answer

A foreign key uniquely identifies a given record in a table.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are the primary differences between a data warehouse and a data mart?

Correct AnswerverifiedShow Answer

Which of the following offers an advantage of using a data-driven website?

Correct AnswerverifiedShow Answer

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Static information includes data that changes based on user actions.

Correct AnswerverifiedShow Answer

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Correct AnswerverifiedShow Answer

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Correct AnswerverifiedShow Answer

What is 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?

Correct AnswerverifiedShow Answer

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Correct AnswerverifiedShow Answer

What do data warehouses support?

Correct AnswerverifiedShow Answer

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

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