Deck 10: Business Intelligence

Question 1

What are the main functions of a data warehouse?

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

Answer 1

none of the above

Question 2

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

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

Answer 2

all of the above

Question 3

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

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.

Answer 3

complete, current, accurate, and authorized.

Question 4

Data mining is the analysis of:

A) data for relationships that may not have previously been known.
B) data for relationships that have been previously known.
C) relationships between performance indicators.
D) business intelligence.
E) key performance indicators.

Question 5

Data mining is:

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 above

Question 6

What term describes the analysis of data for relationships that may not have been previously known?

A) data warehouse
B) metadata
C) data mart
D) data searching
E) data mining

Question 7

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

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

Question 8

OLAP stands for:

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

Question 9

Which form of OLAP makes use of data cubes?

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

Question 10

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

A) metadata
B) data mart
C) data cube
D) data mine
E) BI application

Question 11

A critical success factor for BI is:

A) ease of use
B) scalability
C) flexibility
D) performance and security
E) all of the above

Question 12

A data warehouse is:

A) a central data repository.
B) also known as a search engine.
C) a network within a national company.
D) a system utilized to report data for decision-making purposes.
E) an offsite records management location.

Question 13

Which of the following is a business intelligence function?

A) marketing analysis
B) travel analysis
C) information dissemination
D) transactional analysis
E) none of the above

Question 14

Which type of OLAP occurs if most of the data is analyzed on the system of the end user?

A) relational OLAP
B) multidimensional OLAP
C) client-side OLAP
D) hybrid OLAP
E) none of the above

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

Which one of the following is a Business Intelligence function?

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

Question 20

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

A) production
B) possibility
C) performance
D) position
E) planning

Question 21

Business intelligence applications can be closely related to:

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

Question 22

The ultimate objective of BI is to:

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

Question 23

Several BI providers now operate as ________ providers.

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

Question 24

A two-tier data warehouse structure allows the servers within the system to balance the load of user requests and therefore is easily scaled as the number of users grow.

Question 25

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

Question 26

Two critical issues in architecture design of the system for intelligence application are:

A) database design and system architecture.
B) database language and system architecture.
C) database interfaces and system design.
D) database performance and system version.
E) database architecture and system design.

Question 27

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

Question 28

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

Question 29

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

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

Question 30

Examples of Hybrid OLAP are:

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

Question 31

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

Question 32

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

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

Question 33

The use of relational databases reduces:

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

Question 34

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

A) end user
B) database
C) superuser
D) query
E) report

Question 35

Core technologies provide the basic infrastructure for relational databases.

Question 36

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.

Question 37

One of the 5 business intelligence functions is performance dissemination.

Question 38

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.

Question 39

Primary enabling technologies of BI systems are:

A) data marts and data cubes.
B) data warehouses and data marts.
C) internet and cloud computing.
D) ERP and CRM systems.
E) project and change management.

Question 40

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

Question 41

What are key performance indicators (KPIs)?

Question 42

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

Question 43

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

Question 44

What is business intelligence (BI)?

Question 45

List the benefits of BI systems.

Question 46

Core technologies, enabling technologies, and BI solutions are included in what kind of architecture?

Question 47

Why is scalability a critical success factor for BI?

Question 48

Describe how BI improves collaboration among employees in an organization.

Question 49

What is an ad-hoc query?

Question 50

Designing security for a data warehouse is manageable, since user access in this environment is similar to the objectives of security in the transactional (ERP) environment.