Question 1

Which of the following questions can be answered using business intelligence?

Accepted Answer

A)  Where has the business been? 
B)  Where is the business now? 
C)  Where is the business going? 
D)  All of these. 
A)  Where has the business been? 
B)  Where is the business now? 
C)  Where is the business going? 
D)  All of these.

Question 2

How would the health care 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 3

Business analysis is different 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. 
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.

Question 4

Within the data warehouse model, the external databases could include competitor information, industry information, mailing lists, and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Why were data warehouses created?

Accepted Answer

A)  Numbers and types of operational databases increased as businesses grew 
B)  Many companies had information scattered across multiple systems with different formats 
C)  Completing reporting requests from numerous operational systems took days or weeks 
D)  All of the choices are correct 
A)  Numbers and types of operational databases increased as businesses grew 
B)  Many companies had information scattered across multiple systems with different formats 
C)  Completing reporting requests from numerous operational systems took days or weeks 
D)  All of the choices are correct

Question 7

Businesses collect a tremendous amount of ________ information as part of their routine operations.

Accepted Answer

A)  operational 
B)  transactional 
C)  aggregate 
D)  comparative 
A)  operational 
B)  transactional 
C)  aggregate 
D)  comparative

Question 8

Which of the following are examples of external databases in the data warehouse model?

Accepted Answer

A)  Marketing, sales, inventory, and billing 
B)  Data mart 1, data mart 2, and data mart 3 
C)  Competitor and industry information, mailing lists, and stock market analysis 
D)  Marketing information, sales information, and stock market analysis 
A)  Marketing, sales, inventory, and billing 
B)  Data mart 1, data mart 2, and data mart 3 
C)  Competitor and industry information, mailing lists, and stock market analysis 
D)  Marketing information, sales information, and stock market analysis

Question 9

What is the ultimate outcome of a data warehouse?

Accepted Answer

A)  Data goals 
B)  Data relationships 
C)  Data marketing 
D)  Data marts 
A)  Data goals 
B)  Data relationships 
C)  Data marketing 
D)  Data marts

Question 10

What is a data point?

Accepted Answer

A)  Identifies the primary location where data is collected 
B)  An individual item on a graph or chart 
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)  Identifies the primary location where data is collected 
B)  An individual item on a graph or chart 
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 11

What is source data?

Accepted Answer

A)  Identifies the primary location where data is collected 
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)  Identifies the primary location where data is collected 
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 12

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

Accepted Answer

A)  Formatted data 
B)  Misleading data 
C)  Correct data 
D)  All of the choices are correct 
A)  Formatted data 
B)  Misleading data 
C)  Correct data 
D)  All of the choices are correct

Question 13

Explain ETL and the role of a data mart in business.

Accepted Answer

Extraction, transformation, and loading

Question 14

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

Accepted Answer

A)  Information scaling 
B)  Streamlining data points 
C)  Standardizing information 
D)  Standardizing protocols 
A)  Information scaling 
B)  Streamlining data points 
C)  Standardizing information 
D)  Standardizing protocols

Question 18

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

Accepted Answer

A)  A historical perspective offers important variables for determining trends and patterns. 
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C)  Setting strategic direction is critical for planning and creating solid business strategies. 
D)  None of these. 
A)  A historical perspective offers important variables for determining trends and patterns. 
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C)  Setting strategic direction is critical for planning and creating solid business strategies. 
D)  None of these.

Question 19

The primary purpose of a data warehouse is to combine information.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following identifies the primary location where data is collected?

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

Exam 7: Accessing Organizational Informationdata Warehouses

Which of the following questions can be answered using business intelligence?

How would the health care industry use business intelligence?

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

Within the data warehouse model, the external databases could include competitor information, industry information, mailing lists, and stock market analysis.

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

Why were data warehouses created?

Businesses collect a tremendous amount of ________ information as part of their routine operations.

Which of the following are examples of external databases in the data warehouse model?

What is the ultimate outcome of a data warehouse?

What is a data point?

What is source data?

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

Explain ETL and the role of a data mart in business.

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

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

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

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?

The primary purpose of a data warehouse is to combine information.

Which of the following identifies the primary location where data is collected?

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