Question 1

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False  False

Question 2

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the below 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 the choices are correct. 
A)  Where has the business been? 
B)  Where is the business now? 
C)  Where is the business going? 
D)  All of the choices are correct. D

Question 4

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 5

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Accepted Answer

A) True 
 B)False

Question 6

Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Which of the following contains a subset of data warehouse information?

Accepted Answer

A)  Data miner 
B)  Data mart 
C)  Data pool 
D)  Data analyzing tool 
A)  Data miner 
B)  Data mart 
C)  Data pool 
D)  Data analyzing tool

Question 9

In which ways does a data warehouse enable business users to be more effective?

Accepted Answer

A)  Analyzing trends 
B)  Identifying financial issues 
C)  Understanding competitors 
D)  All of these 
A)  Analyzing trends 
B)  Identifying financial issues 
C)  Understanding competitors 
D)  All of these

Question 10

Which of the following questions is an example of how managers can use BI to answer tough business questions?

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 11

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 12

How would the banking 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 13

What is a data lake?

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 14

What is information that people use to support their decision-making efforts?

Accepted Answer

A)  Information cleansing and scrubbing 
B)  Data-mining tools 
C)  Data mining 
D)  Business intelligence 
A)  Information cleansing and scrubbing 
B)  Data-mining tools 
C)  Data mining 
D)  Business intelligence

Question 15

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 16

Define a data warehouse and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection

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 the choices are correct 
A)  Duplicate data 
B)  Correct data 
C)  Accurate data 
D)  All of the choices are correct

Question 18

Which of the following describes ETL?

Accepted Answer

A)  A process that extracts information from internal and external databases 
B)  A process that transforms information using a common set of enterprise definitions 
C)  A process that loads information into a data warehouse 
D)  All of the choices are correct 
A)  A process that extracts information from internal and external databases 
B)  A process that transforms information using a common set of enterprise definitions 
C)  A process that loads information into a data warehouse 
D)  All of the choices are correct

Question 19

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 20

What is an organized collection of 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.

Exam 7: Accessing Organizational Informationdata Warehouses

ETL, within a data warehouse model, stands for exit, track, and load.

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

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

What determines the accuracy and completeness of organizational data?

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

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

Which of the following contains a subset of data warehouse information?

In which ways does a data warehouse enable business users to be more effective?

Which of the following questions is an example of how managers can use BI to answer tough business questions?

The financial industry uses business intelligence to predict hardware failures.

How would the banking industry use business intelligence?

What is a data lake?

What is information that people use to support their decision-making efforts?

How would the technology industry use business intelligence?

Define a data warehouse and provide a few reasons it can make a manager more effective.

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

Which of the following describes ETL?

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.

What is an organized collection of 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