Question 1

What is erroneous or flawed data?

Accepted Answer

A)   Data set
B)   Dirty data
C)   Data map
D)   Data pointE) A) and C)
F) B) and C)

Question 2

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False

Question 3

Data governance is the practice of gathering data and ensuring that it is uniform,accurate,consistent,and complete,including such entities as customers,suppliers,products,sales,employees,and other critical entities that are commonly integrated across organizational systems.

Accepted Answer

A) True 
 B)False

Question 4

The logical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 5

Association detection 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 6

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 7

What is advanced analytics?

Accepted Answer

A)   A collection of large,complex data sets,including structured and unstructured data,which can't 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 informationE) B) and C)
F) None of the above

Question 8

Organizational information has three characteristics including timeliness,quality,and governance.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Explain the business benefits of a data-driven website.

Accepted Answer

A data-driven website is an interactive ...

Question 11

What is information inconsistency?

Accepted Answer

A)   Occurs when the same data element has different values
B)   Occurs when a system produces incorrect,inconsistent,or duplicate data
C)   Refers to the overall management of the availability,usability,integrity,and security of company data
D)   The practice of gathering data and ensuring that it is uniform,accurate,consistent,and complete,including such entities as customers,suppliers,products,sales,employees,and other critical entities that are commonly integrated across organizational systemsE) All of the above
F) None of the above

Question 12

Accurate information asks if the aggregate or summary information in agreement with detailed information.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

What is extraction,transformation,and loading?

Accepted Answer

A)   It is a process of entering data,tracking data,and loading it into a database.
B)   It is a process that extracts information from internal and external databases,transforms it using a common set of enterprise definitions,and loads it into a data warehouse.
C)   It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube.
D)   It is a process that is performed at the beginning of the data mining model.E) B) and D)
F) None of the above

Question 15

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

Question 16

Which of the below is not an example of an advantage of using a relational database?

Accepted Answer

A)   Increased information quality
B)   Increased flexibility
C)   Decreased information redundancy
D)   Decreased information securityE) All of the above
F) A) and D)

Question 17

Determining if information is updated weekly,daily,or hourly is an example of an accurate characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   Transactional information
B)   Analytical information
C)   Timeliness
D)   QualityE) None of the above
F) C) and D)

Question 20

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What is advanced analytics?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Association detection 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

What is extraction,transformation,and loading?

Correct AnswerverifiedShow Answer

What is information inconsistency?

Correct AnswerverifiedShow Answer

Determining if information is updated weekly,daily,or hourly is an example of an accurate characteristic of high-quality information.

Correct AnswerverifiedShow Answer

Which of the below is not an example of an advantage of using a relational database?

Correct AnswerverifiedShow Answer

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Correct AnswerverifiedShow Answer

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Correct AnswerverifiedShow Answer

Organizational information has three characteristics including timeliness,quality,and governance.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is erroneous or flawed data?

Correct AnswerverifiedShow Answer

Data governance is the practice of gathering data and ensuring that it is uniform,accurate,consistent,and complete,including such entities as customers,suppliers,products,sales,employees,and other critical entities that are commonly integrated across organizational systems.

Correct AnswerverifiedShow Answer

The logical view of information deals with the physical storage of information on a storage device.

Correct AnswerverifiedShow Answer

Explain the business benefits of a data-driven website.

Correct AnswerverifiedA data-driven website is an interactive ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In terms of Big Data,what is velocity?

Correct AnswerverifiedShow Answer

Accurate information asks if the aggregate or summary information in agreement with detailed 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
A data-driven website is an interactive ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified