Question 1

What includes data that change based on user actions?

Accepted Answer

A)  Content creator
B)  Content editor
C)  Static information
D)  Dynamic informationE) A) and B)
F) B) and C)

Question 2

Which of the following is not a dirty data problem?

Accepted Answer

A)  Duplicate data.
B)  Inaccurate data.
C)  Specific data.
D)  Non-integrated data.E) B) and D)
F) C) and D)

Question 3

What is source data?

Accepted Answer

A)  Identifies the primary location where data is collected.
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) A) and B)
F) A) and C)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A)  Database
B)  Data model
C)  Data mining
D)  Data intelligenceE) A) and D)
F) A) and C)

Question 7

In terms of big data what is velocity?

Accepted Answer

A)  Includes different forms of structured and unstructured data.
B)  Includes the uncertainty of data, including biases, noise, and abnormalities.
C)  Includes the scale of data.
D)  Includes the analysis of streaming data as it travels around the Internet.E) C) and D)
F) B) and D)

Question 8

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

Accepted Answer

A)  Identity management.
B)  Master data management.
C)  Data validation.
D)  Data latency.E) A) and C)
F) None of the above

Question 9

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 10

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

Optimization 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 13

Organizational information comes at the same level, formats and granularities.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Big data
B)  Distributed computing
C)  Advanced analytics
D)  Data scientistE) B) and D)
F) A) and B)

Question 15

Timely information asks if the information current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 16

What are the rules that help ensure the quality of information?

Accepted Answer

A)  Information integrity
B)  Integrity constraints
C)  Relational integrity constraints
D)  Business-critical integrity constraintsE) B) and D)
F) None of the above

Question 17

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 18

How would the technology industry use business intelligence?

Accepted Answer

A)  Track crime patterns, locations, and criminal behavior
B)  Analyze customer demographics
C)  Predict sales, inventory levels, and distribution
D)  Predict hardware failuresE) A) and B)
F) A) and C)

Question 19

A data warehouse is a central location in which data is stored and managed.

Accepted Answer

A) True 
 B)False

Question 20

What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Accepted Answer

A)  Fast data
B)  Outlier
C)  Analysis paralysis
D)  CubeE) B) and C)
F) A) and D)

Exam 6: Data: Business Intelligence

What are the rules that help ensure the quality of information?

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

In terms of big data what is velocity?

Correct AnswerverifiedShow Answer

What maintains information about various types of objects, events, people, and places?

Correct AnswerverifiedShow Answer

How would the technology industry use business intelligence?

Correct AnswerverifiedShow Answer

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Correct AnswerverifiedShow Answer

What is the term for is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity?

Correct AnswerverifiedShow Answer

What is source data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Organizational information comes at the same level, formats and granularities.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A data warehouse is a central location in which data is stored and managed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What includes data that change based on user actions?

Correct AnswerverifiedShow Answer

What is the application of big data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Correct AnswerverifiedShow Answer

Which of the following is not a dirty data problem?

Correct AnswerverifiedShow Answer

Optimization 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

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Timely information asks if the information current with respect to the business needs.

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