Question 1

Which of the following would be considered a data source for BI?

Accepted Answer

A)  operating system data 
B)  call centre data 
C)  security data 
D)  network data 
E)  customer testimonials 
A)  operating system data 
B)  call centre data 
C)  security data 
D)  network data 
E)  customer testimonials B

Question 2

What is an ad-hoc query?

Accepted Answer

The ability for users to generate any type of query or report they wish within the system.

Question 3

In many cases the KPI's are linked to a ________.

Accepted Answer

A)  balanced scorecard 
B)  data cube 
C)  data mart 
D)  metadata 
E)  data warehouse 
A)  balanced scorecard 
B)  data cube 
C)  data mart 
D)  metadata 
E)  data warehouse A

Question 4

The ability of a system to maintain a set rate of performance as the number of users or volume of usage increases is called ________.

Accepted Answer

A)  flexibility 
B)  performance 
C)  scalability 
D)  transparency 
E)  none of the above 
A)  flexibility 
B)  performance 
C)  scalability 
D)  transparency 
E)  none of the above

Question 5

The ultimate objective of BI is to:

Accepted Answer

A)  enhance decision making. 
B)  analyze data. 
C)  draw data from diverse sources. 
D)  improve collaboration. 
E)  organize and store data. 
A)  enhance decision making. 
B)  analyze data. 
C)  draw data from diverse sources. 
D)  improve collaboration. 
E)  organize and store data.

Question 6

The use of KPI's and/or a balanced scorecard for performance measurement and analysis does not require the capture of large volumes of data.

Accepted Answer

A) True 
 B)False

Question 7

If the data are of high quality, means that they are:

Accepted Answer

A)  internal, accurate, and readily shared. 
B)  specific, measureable, and timely. 
C)  organized, and easy to access. 
D)  flexible, scaleable, and secure. 
E)  complete, current, accurate, and authorized. 
A)  internal, accurate, and readily shared. 
B)  specific, measureable, and timely. 
C)  organized, and easy to access. 
D)  flexible, scaleable, and secure. 
E)  complete, current, accurate, and authorized.

Question 8

What is business intelligence (BI)?

Accepted Answer

Business intelligence (BI) involves the

Question 9

Data warehouses are divided into smaller, dedicated databases also known as ________.

Accepted Answer

A)  data marts 
B)  data cubes 
C)  data clusters 
D)  data stores 
E)  data mines 
A)  data marts 
B)  data cubes 
C)  data clusters 
D)  data stores 
E)  data mines

Question 10

There is no need for business intelligence strategies in companies that already have a well-designed ERP system.

Accepted Answer

A) True 
 B)False

Question 11

The sources of data for BI can include both internal and external data.

Accepted Answer

A) True 
 B)False

Question 12

Several BI providers now operate as ________ providers.

Accepted Answer

A)  ERP 
B)  Internet Service 
C)  Software as a Service 
D)  CRM 
E)  change management 
A)  ERP 
B)  Internet Service 
C)  Software as a Service 
D)  CRM 
E)  change management

Question 13

ROLAP (Applications that allow multi-dimensional analysis within a relational database) stands for Removable Online Analytical Processing.

Accepted Answer

A) True 
 B)False

Question 14

In data analysis and reporting methods, the value of BI (Business Intelligence) increases as the complexity of the level of:

Accepted Answer

A)  performance increases. 
B)  information increases. 
C)  analysis increases. 
D)  analysis decreases. 
A)  performance increases. 
B)  information increases. 
C)  analysis increases. 
D)  analysis decreases.

Question 15

What are the main functions of a data warehouse?

Accepted Answer

A)  analyzing data 
B)  storing data 
C)  mirroring data 
D)  compressing data 
E)  none of the above 
A)  analyzing data 
B)  storing data 
C)  mirroring data 
D)  compressing data 
E)  none of the above

Question 16

The use of relational databases reduces:

Accepted Answer

A)  employee training requirements. 
B)  data accuracy. 
C)  duplication of data. 
D)  the level of security. 
E)  ease of use. 
A)  employee training requirements. 
B)  data accuracy. 
C)  duplication of data. 
D)  the level of security. 
E)  ease of use.

Question 17

Examples of Hybrid OLAP are:

Accepted Answer

A)  IOLAP and XOLAP. 
B)  WOLAP and BOLAP. 
C)  ROLAP and MOLAP. 
D)  EOLAP and IOLAP. 
E)  ROLAP and BOLAP. 
A)  IOLAP and XOLAP. 
B)  WOLAP and BOLAP. 
C)  ROLAP and MOLAP. 
D)  EOLAP and IOLAP. 
E)  ROLAP and BOLAP.

Question 18

Which one of the following is a Business Intelligence function?

Accepted Answer

A)  information dissemination 
B)  collaboration 
C)  performance analysis 
D)  data analysis 
E)  all of the above 
A)  information dissemination 
B)  collaboration 
C)  performance analysis 
D)  data analysis 
E)  all of the above

Question 19

One of the 5 business intelligence functions is performance dissemination.

Accepted Answer

A) True 
 B)False

Question 20

OLAP stands for:

Accepted Answer

A)  Online Assistance Programs 
B)  Office Language and Procedures 
C)  Online Analytical Processing 
D)  Online Advertising Programs 
E)  none of the above 
A)  Online Assistance Programs 
B)  Office Language and Procedures 
C)  Online Analytical Processing 
D)  Online Advertising Programs 
E)  none of the above

Which of the following would be considered a data source for BI?

What is an ad-hoc query?

In many cases the KPI's are linked to a ________.

The ability of a system to maintain a set rate of performance as the number of users or volume of usage increases is called ________.

The ultimate objective of BI is to:

The use of KPI's and/or a balanced scorecard for performance measurement and analysis does not require the capture of large volumes of data.

If the data are of high quality, means that they are:

What is business intelligence (BI)?

Data warehouses are divided into smaller, dedicated databases also known as ________.

There is no need for business intelligence strategies in companies that already have a well-designed ERP system.

The sources of data for BI can include both internal and external data.

Several BI providers now operate as ________ providers.

ROLAP (Applications that allow multi-dimensional analysis within a relational database) stands for Removable Online Analytical Processing.

In data analysis and reporting methods, the value of BI (Business Intelligence) increases as the complexity of the level of:

What are the main functions of a data warehouse?

The use of relational databases reduces:

Examples of Hybrid OLAP are:

Which one of the following is a Business Intelligence function?

One of the 5 business intelligence functions is performance dissemination.

OLAP stands for:

Introduction to Ebusiness

Internet Business Models and Strategies

Evolution and Applications of the Internet

Enterprise-Wide and Inter-Enterprise Systems

Security and Controls

Billing and Payment Systems

Supply-Chain Management

Eprocurement, Trading Exchanges, and Auctions

Customer Relationship Management

E-marketing and Advertising

Metrics for Performance Measurement in E-commerce

Privacy, Legal, and Taxation Issues in Ecommerce

Ecommerce and Small Business

Filters

Exam 10: Business Intelligence

Which of the following would be considered a data source for BI?

What is an ad-hoc query?

In many cases the KPI's are linked to a ________.

The ability of a system to maintain a set rate of performance as the number of users or volume of usage increases is called ________.

The ultimate objective of BI is to:

The use of KPI's and/or a balanced scorecard for performance measurement and analysis does not require the capture of large volumes of data.

If the data are of high quality, means that they are:

What is business intelligence (BI)?

Data warehouses are divided into smaller, dedicated databases also known as ________.

There is no need for business intelligence strategies in companies that already have a well-designed ERP system.

The sources of data for BI can include both internal and external data.

Several BI providers now operate as ________ providers.

ROLAP (Applications that allow multi-dimensional analysis within a relational database) stands for Removable Online Analytical Processing.

In data analysis and reporting methods, the value of BI (Business Intelligence) increases as the complexity of the level of:

What are the main functions of a data warehouse?

The use of relational databases reduces:

Examples of Hybrid OLAP are:

Which one of the following is a Business Intelligence function?

One of the 5 business intelligence functions is performance dissemination.

OLAP stands for:

Introduction to Ebusiness

Internet Business Models and Strategies

Evolution and Applications of the Internet

Enterprise-Wide and Inter-Enterprise Systems

Security and Controls

Billing and Payment Systems

Supply-Chain Management

Eprocurement, Trading Exchanges, and Auctions

Customer Relationship Management

E-marketing and Advertising

Metrics for Performance Measurement in E-commerce

Privacy, Legal, and Taxation Issues in Ecommerce

Ecommerce and Small Business

Filters