Question 1

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean missing records
B)  Clean redundant records
C)  Clean inaccurate data
D)  All of the aboveE) All of the above
F) C) and D)

Question 2

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems
B)  Customer information in each operational system could change
C)  Customer information in each operational system can be different
D)  All of the aboveE) B) and D)
F) C) and D)

Question 3

Speech analytics 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) True 
 B)False

Question 4

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

Question 5

What is a data lake?

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) None of the above
F) All of the above

Question 6

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

Question 7

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Accepted Answer

A) True 
 B)False

Question 8

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

Prediction 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) True 
 B)False

Question 11

What is a data scientist?

Accepted Answer

A)  A collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.
B)  Processes and manages algorithms across many machines in a computing environment.
C)  Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
D)  Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information.E) B) and D)
F) A) and C)

Question 12

A content creator is the person responsible for updating and maintaining website content.

Accepted Answer

A) True 
 B)False

Question 13

What does standardization of data elements accomplish?

Accepted Answer

A)  Greater accuracy.
B)  Completeness and completeness.
C)  Increases the quality of information.
D)  All of the above.E) A) and B)
F) A) and C)

Question 14

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A)  It is only available to high-level executives due to the expense
B)  It is only available in aggregate levels of granularity
C)  It continually changes
D)  It rarely changesE) A) and B)
F) None of the above

Question 15

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 16

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is incorrect in reference to a database?

Accepted Answer

A)  A database can be relational or network
B)  Database information is accessed by logical structure
C)  Database information is accessed by physical structure
D)  Database users can have different views of informationE) C) and D)
F) None of the above

Question 18

Relationship integrity criteria are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 19

What is a data steward?

Accepted Answer

A)  The time it takes for data to be stored or retrieved.
B)  The management and oversight of an organization's data assets.
C)  The person responsible for ensuring policies and procedures are implemented across the organization.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.E) A) and B)
F) None of the above

Question 20

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Accepted Answer

A)  Entity
B)  Extraction
C)  Attribute
D)  Foreign keyE) B) and D)
F) A) and B)

Exam 6: Data: Business Intelligence

Relationship integrity criteria are rules that enforce basic and fundamental information-based constraints.

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 data scientist?

Correct AnswerverifiedShow Answer

Which of the following is incorrect in reference to a database?

Correct AnswerverifiedShow Answer

What is a data steward?

Correct AnswerverifiedShow Answer

What does standardization of data elements accomplish?

Correct AnswerverifiedShow Answer

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Correct AnswerverifiedShow Answer

Dirty data is erroneous or flawed data.

Correct AnswerverifiedShow Answer

A content creator is the person responsible for updating and maintaining website content.

Correct AnswerverifiedShow Answer

Prediction 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

Speech analytics 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

Why were data warehouses created?

Correct AnswerverifiedShow Answer

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Correct AnswerverifiedShow Answer

Which of the following statements is true regarding customer information?

Correct AnswerverifiedShow Answer

What is a data lake?

Correct AnswerverifiedShow Answer

What is one of the biggest pitfalls associated with real-time information?

Correct AnswerverifiedShow Answer

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Correct AnswerverifiedShow Answer

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

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

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