Question 1

Define a data warehouse, and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection...

Question 2

In terms of big data what is volume?

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

Question 3

Explain the business benefits of a data-driven website.

Accepted Answer

A data-driven website is an interactive ...

Question 4

Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

Accepted Answer

A) True 
 B)False

Question 5

Data latency includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  Are there any duplicate orders?
B)  Are there any duplicate customers?
C)  Is aggregate information in agreement with detailed information?
D)  Is each transaction and event represented only once in the information?E) None of the above
F) A) and B)

Question 7

Business analysis is difficult from operational databases. Which of the following is not a reason why?

Accepted Answer

A)  Every department has its own method for recording data.
B)  Data stored in operational databases did not allow users direct access.
C)  The data is standardized.
D)  The data collected is not always useful for intended purposes.E) A) and C)
F) B) and C)

Question 8

There are three primary data models for organizing information including the hierarchical, network, and relational database models.

Accepted Answer

A) True 
 B)False

Question 9

What is data gap analysis?

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 tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.E) B) and C)
F) A) and D)

Question 10

A DBMS provides details about data.

Accepted Answer

A) True 
 B)False

Question 11

There are only two main primary traits that help you determine the value of information including timeliness and quality.

Accepted Answer

A) True 
 B)False

Question 12

How would the marketing 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 C)
F) A) and B)

Question 13

What is fast data?

Accepted Answer

A)  Processes and manages algorithms across many machines in a computing environment.
B)  A data value that is numerically distant from most of the other data points in a set of data.
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)  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.E) B) and C)
F) None of the above

Question 14

Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Accepted Answer

A) True 
 B)False

Question 15

While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

Accepted Answer

A) True 
 B)False

Question 16

What is a collection of data from various sources for the purpose of data processing?

Accepted Answer

A)  Repository.
B)  Data warehouse.
C)  Data aggregation.
D)  Data broker.E) A) and B)
F) A) and C)

Question 17

What is a primary key?

Accepted Answer

A)  A field (or group of fields) that uniquely identifies a given entity in a table
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C)  Characteristics or properties of an entity
D)  A field (or group of fields) that uniquely identifies a given attribute in a tableE) All of the above
F) A) and B)

Question 18

Advanced analytics processes and manages algorithms across many machines in a computing environment.

Accepted Answer

A) True 
 B)False

Question 19

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is not a common form of data mining analysis?

Accepted Answer

A)  Division organization
B)  Classification
C)  Estimation
D)  ClusteringE) All of the above
F) B) and C)

Exam 6: Data: Business Intelligence

Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

Correct AnswerverifiedShow Answer

How would the marketing industry use business intelligence?

Correct AnswerverifiedShow Answer

What is data gap analysis?

Correct AnswerverifiedShow Answer

While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

Correct AnswerverifiedShow Answer

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Correct AnswerverifiedShow Answer

What is a primary key?

Correct AnswerverifiedShow Answer

Explain the business benefits of a data-driven website.

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

There are only two main primary traits that help you determine the value of information including timeliness and quality.

Correct AnswerverifiedShow Answer

Which of the following is not a common form of data mining analysis?

Correct AnswerverifiedShow Answer

In terms of big data what is volume?

Correct AnswerverifiedShow Answer

What is fast data?

Correct AnswerverifiedShow Answer

Define a data warehouse, and provide a few reasons it can make a manager more effective.

Correct AnswerverifiedA data warehouse is a logical collection...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Data latency includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Correct AnswerverifiedShow Answer

Advanced analytics processes and manages algorithms across many machines in a computing environment.

Correct AnswerverifiedShow Answer

A DBMS provides details about data.

Correct AnswerverifiedShow Answer

Regression is a statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.

Correct AnswerverifiedShow Answer

There are three primary data models for organizing information including the hierarchical, network, and relational database models.

Correct AnswerverifiedShow Answer

Business analysis is difficult from operational databases. Which of the following is not a reason why?

Correct AnswerverifiedShow Answer

What is a collection of data from various sources for the purpose of data processing?

Correct AnswerverifiedShow Answer

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
A data warehouse is a logical collection...
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