Question 1

What is another term for data that is already contained in a database or a spreadsheet?

Accepted Answer

A)  Structured data
B)  Unstructured data
C)  Text mining
D)  Web miningE) A) and C)
F) All of the above

Question 2

Static information includes fixed data incapable of change in the event of a user action.

Accepted Answer

A) True 
 B)False

Question 3

Reports for each sales person, product, and part are examples of detail or fine information granularities.

Accepted Answer

A) True 
 B)False

Question 4

What determines which things go together?

Accepted Answer

A)  Classification
B)  Estimation
C)  Affinity grouping
D)  ClusteringE) All of the above
F) B) and C)

Question 5

What are advanced analytics?

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 data.E) A) and B)
F) B) and D)

Question 6

What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A)  Dynamic website
B)  Data-driven website
C)  Static information
D)  Dynamic informationE) None of the above
F) B) and D)

Question 7

Organizational data includes simple structured data elements in a database.

Accepted Answer

A) True 
 B)False

Question 8

A data point is an individual item on a graph or chart.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

Accepted Answer

A)  Physical view
B)  Logical view
C)  Data mart view
D)  Data viewE) B) and C)
F) A) and C)

Question 10

A content creator is the person responsible for creating the original website content.

Accepted Answer

A) True 
 B)False

Question 11

What is data governance?

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 systems.E) C) and D)
F) B) and D)

Question 12

What is data validation?

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

Question 13

What is estimation?

Accepted Answer

A)  Determines values for an unknown continuous variable behavior or estimated future value.
B)  Determine which things go together.
C)  Segments a heterogeneous population of more homogeneous subgroups.
D)  Assigns records to one of a predefined set of classes.E) A) and D)
F) B) and C)

Question 14

The primary purpose of a data warehouse is to ________.

Accepted Answer

A)  Combine strategic information
B)  Organize departments
C)  Interface between the computer and employees
D)  All of the aboveE) None of the above
F) A) and D)

Question 15

What are forecasts?

Accepted Answer

A)  A statement about what will happen or might happen in the future, for example, predicting future sales or employee turnover.
B)  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.
C)  Predictions based on time-series information.
D)  A statistical process for estimating the relationships among variables.E) A) and D)
F) A) and C)

Question 16

What is erroneous or flawed data?

Accepted Answer

A)  Dirty data
B)  Information cleansing
C)  Information Scrubbing
D)  ETLE) A) and D)
F) B) and C)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 19

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)  Big data
B)  Distributed computing
C)  Advanced analytics
D)  Data scientistE) B) and D)
F) All of the above

Question 20

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are advanced analytics?

Correct AnswerverifiedShow Answer

What is another term for data that is already contained in a database or a spreadsheet?

Correct AnswerverifiedShow Answer

What are forecasts?

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

What is erroneous or flawed data?

Correct AnswerverifiedShow Answer

Static information includes fixed data incapable of change in the event of a user action.

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to ________.

Correct AnswerverifiedShow Answer

Organizational data includes simple structured data elements in a database.

Correct AnswerverifiedShow Answer

Which of the following focuses on how individual users logically access information to meet their own particular business needs?

Correct AnswerverifiedShow Answer

What is estimation?

Correct AnswerverifiedShow Answer

What determines which things go together?

Correct AnswerverifiedShow Answer

Reports for each sales person, product, and part are examples of detail or fine information granularities.

Correct AnswerverifiedShow Answer

What is data validation?

Correct AnswerverifiedShow Answer

A content creator is the person responsible for creating the original website content.

Correct AnswerverifiedShow Answer

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Correct AnswerverifiedShow Answer

A data point is an individual item on a graph or chart.

Correct AnswerverifiedShow Answer

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Correct AnswerverifiedShow Answer

What is data governance?

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