Question 1

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

Accepted Answer

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

Question 2

What does standardization of data elements accomplish?

Accepted Answer

A)  Greater accuracy 
B)  Completeness and completeness 
C)  Increases the quality of information 
D)  All of these 
A)  Greater accuracy 
B)  Completeness and completeness 
C)  Increases the quality of information 
D)  All of these

Question 3

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

Accepted Answer

A)  Oracle. 
B)  SAS. 
C)  Ascential Software. 
D)  McAffee. 
A)  Oracle. 
B)  SAS. 
C)  Ascential Software. 
D)  McAffee.

Question 4

Which of the following statements is true regarding customer information?

Accepted Answer

A)  Customer information can exist in several operational systems 
B)  Customer information in each operational system could change 
C)  Customer information in each operational system can be different 
D)  All of the choices are correct 
A)  Customer information can exist in several operational systems 
B)  Customer information in each operational system could change 
C)  Customer information in each operational system can be different 
D)  All of the choices are correct

Question 5

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

What is another term for information cleansing?

Accepted Answer

A)  Information mining 
B)  Information scrubbing 
C)  Information scrapping 
D)  Information marts 
A)  Information mining 
B)  Information scrubbing 
C)  Information scrapping 
D)  Information marts

Question 9

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

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

What is a data broker?

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

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Accepted Answer

A) True 
 B)False

Question 12

Organizational data includes simple structured data elements in a database.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 15

What is a central location in which data is stored and managed?

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

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Accepted Answer

A) True 
 B)False

Question 17

What is a collection of data from various sources for the purpose of data processing?

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 18

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)  When sharing data, the data matches with the data warehouse and users get the data they need. 
C)  The data is of poor quality. 
D)  The data collected is not always useful for intended purposes. 
A)  Every department has its own method for recording data. 
B)  When sharing data, the data matches with the data warehouse and users get the data they need. 
C)  The data is of poor quality. 
D)  The data collected is not always useful for intended purposes.

Question 19

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean data marts 
B)  Clean redundant customer data 
C)  Clean accurate data 
D)  Clean correct data 
A)  Clean data marts 
B)  Clean redundant customer data 
C)  Clean accurate data 
D)  Clean correct data

Question 20

Which of the following occurs during data cleansing?

Accepted Answer

A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of the choices are correct 
A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of the choices are correct

Exam 7: Accessing Organizational Informationdata Warehouses

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

What does standardization of data elements accomplish?

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

Which of the following statements is true regarding customer information?

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

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

How would the marketing industry use business intelligence?

What is another term for information cleansing?

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

What is a data broker?

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Organizational data includes simple structured data elements in a database.

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

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

What is a central location in which data is stored and managed?

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

What is a collection of data from various sources for the purpose of data processing?

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

Which of the following occurs during data cleansing?

Which of the following occurs during data cleansing?

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