Question 1

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A)  Data warehouses make quick decisions; data marts make slow decisions 
B)  Data warehouse tackle ethical issues; data marts tackle hypothetical issues 
C)  Data warehouses have a more organization wide focus; data marts have functional focus 
D)  Data warehouses have a physical focus; data marts have logical focus. 
A)  Data warehouses make quick decisions; data marts make slow decisions 
B)  Data warehouse tackle ethical issues; data marts tackle hypothetical issues 
C)  Data warehouses have a more organization wide focus; data marts have functional focus 
D)  Data warehouses have a physical focus; data marts have logical focus.

Question 2

________ can compare two or more data sets to identify patterns and trends.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Accepted Answer

A) True 
 B)False

Question 5

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 6

What is erroneous or flawed data?

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 7

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 8

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

Accepted Answer

A)  Every department has its own method for recording data. 
B)  Data standards do not apply across departments. 
C)  The data, if available, were often incorrect or incomplete. 
D)  All of these. 
A)  Every department has its own method for recording data. 
B)  Data standards do not apply across departments. 
C)  The data, if available, were often incorrect or incomplete. 
D)  All of these.

Question 9

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants to get its information, the less it costs 
B)  The more accurate an organization wants to get its information, the less it costs 
C)  The less accurate an organization wants to get its information, the more it costs 
D)  The more complete and accurate an organization wants to get its information, the more it costs 
A)  The more complete an organization wants to get its information, the less it costs 
B)  The more accurate an organization wants to get its information, the less it costs 
C)  The less accurate an organization wants to get its information, the more it costs 
D)  The more complete and accurate an organization wants to get its information, the more it costs

Question 10

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 11

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A)  Data broker 
B)  Data lake 
C)  Data map 
D)  Data point 
A)  Data broker 
B)  Data lake 
C)  Data map 
D)  Data point

Question 14

A comparative analysis can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

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 17

A data warehouse is a central location in which data is stored and managed.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not an information cleansing activity?

Accepted Answer

A)  Identifies redundant records 
B)  Identifies inaccurate or incomplete data 
C)  Identifies missing records or attributes 
D)  Identifies sales trends 
A)  Identifies redundant records 
B)  Identifies inaccurate or incomplete data 
C)  Identifies missing records or attributes 
D)  Identifies sales trends

Question 19

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 20

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

Exam 7: Accessing Organizational Informationdata Warehouses

What are the primary differences between a data warehouse and a data mart?

________ can compare two or more data sets to identify patterns and trends.

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

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Competitive monitoring can compare two or more data sets to identify patterns and trends.

What is erroneous or flawed data?

What is a data map?

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

Which of the following statements is true?

What is data-driven decision management?

Dirty data is erroneous or flawed data.

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

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

A comparative analysis can compare two or more data sets to identify patterns and trends.

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

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

A data warehouse is a central location in which data is stored and managed.

Which of the following is not an information cleansing activity?

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

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

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

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