Question 1

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 choices are correct 
A)  Combine strategic information 
B)  Organize departments 
C)  Interface between the computer and employees 
D)  All of the choices are correct

Question 2

The complete removal of dirty data from a source is practical and possible.

Accepted Answer

A) True 
 B)False

Question 3

A data set is an organized collection of data.

Accepted Answer

A) True 
 B)False

Question 4

How would the insurance industry use business intelligence?

Accepted Answer

A)  Analyze popular vacation locations with current flight listings 
B)  Understand customer credit card usage and nonpayment rates 
C)  Compare the demographics of patients with critical illnesses 
D)  Predict claim amounts and medical coverage costs 
A)  Analyze popular vacation locations with current flight listings 
B)  Understand customer credit card usage and nonpayment rates 
C)  Compare the demographics of patients with critical illnesses 
D)  Predict claim amounts and medical coverage costs

Question 5

According to Gartner Inc., dirty data is an MIS problem, not a business problem.

Accepted Answer

A) True 
 B)False

Question 6

What do data warehouses support?

Accepted Answer

A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing 
A)  OLAP 
B)  Analytical processing 
C)  OLTP 
D)  OLAP and analytical processing

Question 7

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

Accepted Answer

A)  Inconsistent data definitions 
B)  Lack of data standards 
C)  Effective direct data access 
D)  Poor data quality 
A)  Inconsistent data definitions 
B)  Lack of data standards 
C)  Effective direct data access 
D)  Poor data quality

Question 8

Bethany Walsh is a business manager at Dixon Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Accepted Answer

A)  Data point 
B)  Information cleansing 
C)  Dashboard 
D)  Data set 
A)  Data point 
B)  Information cleansing 
C)  Dashboard 
D)  Data set

Question 9

How would the law enforcement 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 failures 
A)  Track crime patterns, locations, and criminal behavior 
B)  Analyze customer demographics 
C)  Predict sales, inventory levels, and distribution 
D)  Predict hardware failures

Question 10

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

Accepted Answer

A)  Comparative analysis 
B)  Competitive monitoring 
C)  Data-driven decision management 
D)  Source data 
A)  Comparative analysis 
B)  Competitive monitoring 
C)  Data-driven decision management 
D)  Source data

Question 12

How would the retail 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 failures 
A)  Track crime patterns, locations, and criminal behavior 
B)  Analyze customer demographics 
C)  Predict sales, inventory levels, and distribution 
D)  Predict hardware failures

Question 13

Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had ________ productivity rates and ________ profits.

Accepted Answer

A)  4% lower, 6% higher 
B)  4% higher, 6% lower 
C)  4% higher, 6% higher 
D)  4% lower, 6% lower 
A)  4% lower, 6% higher 
B)  4% higher, 6% lower 
C)  4% higher, 6% higher 
D)  4% lower, 6% lower

Question 14

A data miner contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What is it called when a manager has so much data and information that they cannot make a decision?

Accepted Answer

A)  Data rich, information poor 
B)  Data rich, content poor 
C)  Data rich, communication poor 
D)  Data rich, intelligence 
A)  Data rich, information poor 
B)  Data rich, content poor 
C)  Data rich, communication poor 
D)  Data rich, intelligence

Question 17

Data aggregation is the collection of data from various sources for the purpose of data processing.

Accepted Answer

A) True 
 B)False

Question 18

A data mart contains a subset of data warehouse information.

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Informationdata Warehouses

The primary purpose of a data warehouse is to ________.

The complete removal of dirty data from a source is practical and possible.

A data set is an organized collection of data.

How would the insurance industry use business intelligence?

According to Gartner Inc., dirty data is an MIS problem, not a business problem.

What do data warehouses support?

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

Bethany Walsh is a business manager at Dixon Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

How would the law enforcement industry use business intelligence?

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?

How would the retail industry use business intelligence?

Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had ________ productivity rates and ________ profits.

A data miner contains a subset of data warehouse information.

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

What is it called when a manager has so much data and information that they cannot make a decision?

Data aggregation is the collection of data from various sources for the purpose of data processing.

A data mart contains a subset of data warehouse information.

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing and Storing Organizational Informationdatabases

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Creating Innovative Organizations

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing and Storing Organizational Informationdatabases

Accessing Organizational Informationdata Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Filters

Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had productivity rates and profits.