Question 1

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 these 
A) Formatted data 
B) Misleading data 
C) Correct data 
D) All of these

Question 2

BI can help managers with ___________, 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) 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

Question 3

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 4

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A) Block 
B) Square 
C) Column 
D) Cube 
A) Block 
B) Square 
C) Column 
D) Cube

Question 5

How would the technology 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 6

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 7

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 8

How would the law enforcement 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 9

A data set is an organized collection of data.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following statements is true?

Accepted Answer

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

Question 11

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 12

What determines the accuracy and completeness of organizational data?

Accepted Answer

A) Data quantity audit 
B) Data quality audit 
C) Data intelligence audit 
D) Data accuracy audit 
A) Data quantity audit 
B) Data quality audit 
C) Data intelligence audit 
D) Data accuracy audit

Question 13

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 14

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 15

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 16

__________ 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 17

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

Accepted Answer

A) Duplicate data 
B) Correct data 
C) Accurate data 
D) All of these 
A) Duplicate data 
B) Correct data 
C) Accurate data 
D) All of these

Question 18

ETL stands for extraction, transformation, and loading.

Accepted Answer

A) True 
 B)False

Question 19

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 these 
A) Clean missing records 
B) Clean redundant records 
C) Clean inaccurate data 
D) All of these

Question 20

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

Exam 7: Accessing Organizational Information Data Warehouses

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

BI can help managers with ___________, 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.

Which of the following occurs during data cleansing?

Which of the following is the common term for the representation of multidimensional information?

How would the technology industry use business intelligence?

What is the ultimate outcome of a data warehouse?

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

How would the law enforcement industry use business intelligence?

A data set is an organized collection of data.

Which of the following statements is true?

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

What determines the accuracy and completeness of organizational data?

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

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 ___________.

Which of the following is not an information cleansing activity?

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

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

ETL stands for extraction, transformation, and loading.

Which of the following occurs during data cleansing?

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

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