Question 1

The most common form of database used in BI systems is a:

Accepted Answer

A)   customer database.
B)   client database.
C)   open-source database.
D)   relational database.
E)   embedded database.F) C) and D)
G) A) and E)

Question 2

Which of the following will influence the architecture design decision for intelligence applications?

Accepted Answer

A)   hardware selection
B)   number of users
C)   existing corporate infrastructure
D)   software application choice
E)   all of the aboveF) C) and E)
G) B) and E)

Question 3

Data mining is:

Accepted Answer

A)   getting rid of bad data in a database.
B)   analysis of data for new relationships.
C)   relocating data into a new database.
D)   searching through data to create new queries.
E)   none of the aboveF) None of the above
G) C) and D)

Question 4

Name the five Business Intelligence functions as outlined in the textbook.

Accepted Answer

The five business intelligence...

Question 5

List the benefits of BI systems.

Accepted Answer

Continuous rather than periodi...

Question 6

The balanced scorecard is a multi-dimensional measurement tool aimed to capture performance measures related to ________.

Accepted Answer

A)   accounting/finance
B)   human resources
C)   internal processes
D)   customers
E)   all of the aboveF) A) and C)
G) C) and D)

Question 7

ETL is the process of gathering data from a system, such as an ERP system, which can be simplified and stored within the data warehouse.

Accepted Answer

A) True 
 B)False

Question 8

Business intelligence applications can be closely related to:

Accepted Answer

A)   sales strategies.
B)   customer relationship management (CRM)  strategies.
C)   online marketing strategies.
D)   supply chain strategies.
E)   social media strategies.F) A) and B)
G) A) and C)

Question 9

Data cubes are a common format for data warehouses. More advanced design formats for data warehouses include star and snowflake schemas.

Accepted Answer

A) True 
 B)False

Question 10

A data repository that is dedicated to specific user groups and is often integrated into the data warehouse is a ________.

Accepted Answer

A)   metadata
B)   data mart
C)   data cube
D)   data mine
E)   BI applicationF) A) and C)
G) A) and B)

Question 11

Which of the following is a business intelligence function?

Accepted Answer

A)   marketing analysis
B)   travel analysis
C)   information dissemination
D)   transactional analysis
E)   none of the aboveF) B) and E)
G) B) and D)

Question 12

Which form of OLAP makes use of data cubes?

Accepted Answer

A)   Relational OLAP
B)   Multi-dimensional OLAP
C)   Hybrid OLAP
D)   Client-side OLAP
E)   all of the aboveF) All of the above
G) None of the above

Question 13

Data warehouse security can be established at the application or ________ level.

Accepted Answer

A)   end user
B)   database
C)   superuser
D)   query
E)   reportF) A) and B)
G) C) and D)

Question 14

What are key performance indicators (KPIs)?

Accepted Answer

Key performance indicators (KPIs) are im...

Question 15

Data sources for business intelligence (BI) have to be internal only.

Accepted Answer

A) True 
 B)False

Question 16

Business intelligence has evolved from previous data management systems such as data warehousing.

Accepted Answer

A) True 
 B)False

Question 17

The "P" in the acronym KPI stands for ________.

Accepted Answer

A)   production
B)   possibility
C)   performance
D)   position
E)   planningF) C) and E)
G) A) and E)

Question 18

Why is scalability a critical success factor for BI?

Accepted Answer

Scalability provides the capab...

Question 19

Core technologies provide the basic infrastructure for relational databases.

Accepted Answer

A) True 
 B)False

Question 20

Describe how BI improves collaboration among employees in an organization.

Accepted Answer

BI enable different divisions to share c...

Exam 10: Business Intelligence

Describe how BI improves collaboration among employees in an organization.

Correct AnswerverifiedBI enable different divisions to share c...View AnswerShow Answer

List the benefits of BI systems.

Correct AnswerverifiedContinuous rather than periodi...View AnswerShow Answer

Data warehouse security can be established at the application or ________ level.

Correct AnswerverifiedShow Answer

Data mining is:

Correct AnswerverifiedShow Answer

Which of the following will influence the architecture design decision for intelligence applications?

Correct AnswerverifiedShow Answer

Business intelligence applications can be closely related to:

Correct AnswerverifiedShow Answer

Name the five Business Intelligence functions as outlined in the textbook.

Correct AnswerverifiedThe five business intelligence...View AnswerShow Answer

Data sources for business intelligence (BI) have to be internal only.

Correct AnswerverifiedShow Answer

ETL is the process of gathering data from a system, such as an ERP system, which can be simplified and stored within the data warehouse.

Correct AnswerverifiedShow Answer

Data cubes are a common format for data warehouses. More advanced design formats for data warehouses include star and snowflake schemas.

Correct AnswerverifiedShow Answer

Why is scalability a critical success factor for BI?

Correct AnswerverifiedScalability provides the capab...View AnswerShow Answer

Which form of OLAP makes use of data cubes?

Correct AnswerverifiedShow Answer

Which of the following is a business intelligence function?

Correct AnswerverifiedShow Answer

Core technologies provide the basic infrastructure for relational databases.

Correct AnswerverifiedShow Answer

The most common form of database used in BI systems is a:

Correct AnswerverifiedShow Answer

Business intelligence has evolved from previous data management systems such as data warehousing.

Correct AnswerverifiedShow Answer

A data repository that is dedicated to specific user groups and is often integrated into the data warehouse is a ________.

Correct AnswerverifiedShow Answer

The "P" in the acronym KPI stands for ________.

Correct AnswerverifiedShow Answer

The balanced scorecard is a multi-dimensional measurement tool aimed to capture performance measures related to ________.

Correct AnswerverifiedShow Answer

What are key performance indicators (KPIs)?

Correct AnswerverifiedKey performance indicators (KPIs) are im...View AnswerShow Answer

Correct Answer
verified
BI enable different divisions to share c...
View Answer

Correct Answer
verified
Continuous rather than periodi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The five business intelligence...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Scalability provides the capab...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Key performance indicators (KPIs) are im...
View Answer