Question 1

Which of the following statements does not describe the Zappos database?

Accepted Answer

A)  The Zappos database was highly scalable.
B)  The Zappos database was highly flexible.
C)  The Zappos database was highly secure.
D)  The Zappos database was highly redundant.E) None of the above
F) All of the above

Question 2

Volume includes the scale of data.

Accepted Answer

A) True 
 B)False

Question 3

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following implies that information is current with respect to the business requirement?

Accepted Answer

A)  uniqueness
B)  accuracy
C)  consistency
D)  timelinessE) B) and C)
F) A) and D)

Question 5

Attributes (also called columns or fields) are the data elements associated with an entity.

Accepted Answer

A) True 
 B)False

Question 6

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 these are correct.E) All of the above
F) C) and D)

Question 7

Explain the four primary traits that determine the value of information.

Accepted Answer

Information is data converted into a mea...

Question 8

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

Question 9

What is affinity grouping?

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

Question 10

What has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address?

Accepted Answer

A)  structured data
B)  machine-generated data
C)  human-generated data
D)  unstructured dataE) C) and D)
F) A) and C)

Question 11

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 12

What displays information graphically so it can be easily understood?

Accepted Answer

A)  informing
B)  infographics
C)  data visualization
D)  business intelligence dashboardsE) A) and B)
F) None of the above

Question 13

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

A) True 
 B)False

Question 14

What focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization?

Accepted Answer

A)  distributed computing
B)  advanced analytics
C)  analysis paralysis
D)  data artistE) B) and C)
F) A) and C)

Question 15

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Accepted Answer

A)  quality business constraints
B)  critical web constraints
C)  business critical integrity constraints
D)  web integrity constraintsE) B) and D)
F) All of the above

Question 16

Timely information asks if each transaction and event is represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 17

In terms of big data what is veracity?

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) C) and D)
F) None of the above

Question 18

In terms of big data, what includes the analysis of streaming data as it travels around the Internet?

Accepted Answer

A)  variety
B)  veracity
C)  volume
D)  velocityE) B) and D)
F) None of the above

Question 19

Information granularity means immediate, up-to-date information.

Accepted Answer

A) True 
 B)False

Question 20

What analyzes unstructured data to find trends and patterns in words and sentences?

Accepted Answer

A)  structured data
B)  unstructured data
C)  text analytics
D)  web analyticsE) All of the above
F) A) and B)

Exam 6: Data: Business Intelligence

Explain the four primary traits that determine the value of information.

Correct AnswerverifiedInformation is data converted into a mea...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Correct AnswerverifiedShow Answer

What analyzes unstructured data to find trends and patterns in words and sentences?

Correct AnswerverifiedShow Answer

What has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address?

Correct AnswerverifiedShow Answer

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Correct AnswerverifiedShow Answer

In terms of big data what is veracity?

Correct AnswerverifiedShow Answer

Timely information asks if each transaction and event is represented only once in the information.

Correct AnswerverifiedShow Answer

Which of the following statements is TRUE regarding customer information?

Correct AnswerverifiedShow Answer

In terms of big data, what includes the analysis of streaming data as it travels around the Internet?

Correct AnswerverifiedShow Answer

Which of the following statements does not describe the Zappos database?

Correct AnswerverifiedShow Answer

Volume includes the scale of data.

Correct AnswerverifiedShow Answer

What is affinity grouping?

Correct AnswerverifiedShow Answer

What displays information graphically so it can be easily understood?

Correct AnswerverifiedShow Answer

What focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization?

Correct AnswerverifiedShow Answer

Attributes (also called columns or fields) are the data elements associated with an entity.

Correct AnswerverifiedShow Answer

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

Information granularity means immediate, up-to-date information.

Correct AnswerverifiedShow Answer

Which of the following implies that information is current with respect to the business requirement?

Correct AnswerverifiedShow Answer

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Correct AnswerverifiedShow Answer

Correct Answer
verified
Information is data converted into a mea...
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