Question 1

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

Accepted Answer

A)  Non-formatted data 
B)  Misleading data 
C)  Incorrect data 
D)  All of the choices are correct 
A)  Non-formatted data 
B)  Misleading data 
C)  Incorrect data 
D)  All of the choices are correct

Question 2

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 3

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 4

Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

Many organizations today find it next to

Question 6

Which of the following is incorrect in terms of data warehousing and business intelligence?

Accepted Answer

A)  Does not include information from other operational applications 
B)  Operational systems are integrated 
C)  Operational information is mainly current 
D)  Operational information frequently has quality issues 
A)  Does not include information from other operational applications 
B)  Operational systems are integrated 
C)  Operational information is mainly current 
D)  Operational information frequently has quality issues

Question 7

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 8

Which of the following is an example of an external database in the data warehouse model?

Accepted Answer

A)  Marketing information 
B)  Sales information 
C)  Competitor information 
D)  All of these 
A)  Marketing information 
B)  Sales information 
C)  Competitor information 
D)  All of these

Question 9

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

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 10

Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

Accepted Answer

A)  Predict claim amounts and medical coverage costs 
B)  Track crime patterns, locations, and criminal behavior 
C)  Identify the primary locations where data is collected 
D)  Predict sales, inventory levels, and distribution 
A)  Predict claim amounts and medical coverage costs 
B)  Track crime patterns, locations, and criminal behavior 
C)  Identify the primary locations where data is collected 
D)  Predict sales, inventory levels, and distribution

Question 11

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 12

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a dirty data problem?

Accepted Answer

A)  Duplicate data. 
B)  Inaccurate data. 
C)  Specific data. 
D)  Non-integrated data. 
A)  Duplicate data. 
B)  Inaccurate data. 
C)  Specific data. 
D)  Non-integrated data.

Question 14

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Accepted Answer

A) True 
 B)False

Question 15

What is extraction, transformation, and loading?

Accepted Answer

A)  It is a process of entering data, tracking data, and loading it into a database 
B)  It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C)  It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D)  It is a process that is performed at the beginning of the data mining model 
A)  It is a process of entering data, tracking data, and loading it into a database 
B)  It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse 
C)  It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube 
D)  It is a process that is performed at the beginning of the data mining model

Question 16

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

Accepted Answer

A)  Inaccurate data 
B)  Non-integrated data 
C)  Violates business rules data 
D)  All of these 
A)  Inaccurate data 
B)  Non-integrated data 
C)  Violates business rules data 
D)  All of these

Question 17

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

Accepted Answer

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

Question 18

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Question 19

Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries 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)  All of these are examples of how industries use business intelligence 
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)  All of these are examples of how industries use business intelligence

Question 20

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

Accepted Answer

A)  Duplicate data 
B)  Incorrect data 
C)  Violates business rules 
D)  All of the choices are correct 
A)  Duplicate data 
B)  Incorrect data 
C)  Violates business rules 
D)  All of the choices are correct

Exam 7: Accessing Organizational Informationdata Warehouses

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

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

What is erroneous or flawed data?

Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

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

Which of the following is incorrect in terms of data warehousing and business intelligence?

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

Which of the following is an example of an external database in the data warehouse model?

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

Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

The primary purpose of a data warehouse is to perform transactional processes.

Which of the following is not a dirty data problem?

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

What is extraction, transformation, and loading?

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

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

ETL stands for extraction, transformation, and loading.

Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence?

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

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