Question 1

Explain ETL and the role of a data mart in business.

Accepted Answer

Extraction, transformation, and loading ...

Question 2

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In terms of big data what includes different forms of structured and unstructured data?

Accepted Answer

A)  variety
B)  veracity
C)  volume
D)  velocityE) A) and D)
F) A) and B)

Question 5

What is a data artist?

Accepted Answer

A)  processes and manages algorithms across many machines in a computing environment
B)  focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
C)  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
D)  a business analytics specialist who uses visual tools to help people understand complex dataE) A) and B)
F) B) and D)

Question 6

What provides real-time information in response to query requests?

Accepted Answer

A)  real-time information
B)  real-time systems
C)  information level
D)  information qualityE) B) and D)
F) All of the above

Question 7

A data dictionary compiles all of the metadata about the data elements in the data model.

Accepted Answer

A) True 
 B)False

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)  analytical paradox
B)  analytical analysis
C)  analysis paralysis
D)  analysis paradoxE) All of the above
F) A) and B)

Question 9

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)  Do 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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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

Accepted Answer

A)  Is the zip code missing in the address?
B)  Is the information current with respect to business needs?
C)  Is the customer address current?
D)  Is the information updated weekly or hourly?E) B) and D)
F) A) and D)

Question 13

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 14

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Question 15

Metadata provides details about data.For example, metadata for an image could include its size, resolution, and date created.

Accepted Answer

A) True 
 B)False

Question 16

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 17

What is an example of using cluster analysis in business to create target-marketing strategies?

Accepted Answer

A)  Google search
B)  first name information
C)  zip code segmentation
D)  last name associationsE) None of the above
F) A) and B)

Question 18

What compiles all of the metadata about the data elements in the data model?

Accepted Answer

A)  data entity
B)  data element
C)  data attribute
D)  data dictionaryE) B) and C)
F) None of the above

Question 19

Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?

Accepted Answer

A)  analytical information
B)  transactional information
C)  statistical information
D)  targeted informationE) A) and D)
F) C) and D)

Question 20

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

Accepted Answer

A)  nonformatted data
B)  misleading data
C)  incorrect data
D)  All of these are correct.E) None of the above
F) B) and D)

Exam 6: Data: Business Intelligence

Explain ETL and the role of a data mart in business.

Correct AnswerverifiedExtraction, transformation, and loading ...View AnswerShow Answer

A data dictionary compiles all of the metadata about the data elements in the data model.

Correct AnswerverifiedShow Answer

What is a data artist?

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?

Correct AnswerverifiedShow Answer

The financial industry uses business intelligence to predict hardware failures.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What compiles all of the metadata about the data elements in the data model?

Correct AnswerverifiedShow Answer

What is an example of using cluster analysis in business to create target-marketing strategies?

Correct AnswerverifiedShow Answer

What provides real-time information in response to query requests?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

ETL stands for extraction, transformation, and loading.

Correct AnswerverifiedShow Answer

In terms of big data what includes different forms of structured and unstructured data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

Correct AnswerverifiedShow Answer

Metadata provides details about data.For example, metadata for an image could include its size, resolution, and date created.

Correct AnswerverifiedShow Answer

Correct Answer
verified
Extraction, transformation, and loading ...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified