Question 1

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 2

What is erroneous or flawed data?

Accepted Answer

A) Dirty data 
B) Information cleansing 
C) Information Scrubbing 
D) ETL 
A) Dirty data 
B) Information cleansing 
C) Information Scrubbing 
D) ETL

Question 3

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 4

What is a data map?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data. 
A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 5

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

Accepted Answer

A) Logical, operational 
B) Physical, operational 
C) Logical, transactional 
D) Physical, transactional 
A) Logical, operational 
B) Physical, operational 
C) Logical, transactional 
D) Physical, transactional

Question 8

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 9

Identify the advantages of using business intelligence to support managerial decision making.

Accepted Answer

Many organizations today find it next to

Question 10

What is it called when a manager has too much data and information to 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 11

What is an individual item on a graph or a chart?

Accepted Answer

A) Data set 
B) Dirty data 
C) Data map 
D) Data point 
A) Data set 
B) Dirty data 
C) Data map 
D) Data point

Question 12

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Accurate data 
B) Integrated data 
C) Violates business rules 
D) All of these 
A) Accurate data 
B) Integrated data 
C) Violates business rules 
D) All of these

Question 14

What is a business that collects personal information about consumers and sells that information to other organizations?

Accepted Answer

A) Repository 
B) Data warehouse 
C) Data aggregation 
D) Data broker 
A) Repository 
B) Data warehouse 
C) Data aggregation 
D) Data broker

Question 15

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Accepted Answer

A) True 
 B)False

Question 16

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 17

What is data-driven decision management?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data. 
A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 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 20

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

Accepted Answer

A) True 
 B)False

Exam 7: Accessing Organizational Information Data Warehouses

Dirty data is erroneous or flawed data.

What is erroneous or flawed data?

The financial industry uses business intelligence to predict hardware failures.

What is a data map?

Data warehouses struggle with combining too much standardized information.

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

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

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

Identify the advantages of using business intelligence to support managerial decision making.

What is it called when a manager has too much data and information to make a decision?

What is an individual item on a graph or a chart?

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Which of the following is a problem associated with dirty data?

What is a business that collects personal information about consumers and sells that information to other organizations?

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

How would the retail industry use business intelligence?

What is data-driven decision management?

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

How would the marketing industry use business intelligence?

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

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 Information Databases

Understanding Big Data and Its Impact on Business

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End to End Enterprise Resource Planning

Creating Innovative Organizations

E-business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters

A data warehouse is a _ collection of information, gathered from many different ___ databases, that supports business analysis activities and decision-making tasks.