MIS 101 – Final Exam

SECTION 1 — Multiple Choice (Questions only)

1. Business Intelligence (BI) systems are designed to:

a. Replace all operational systems

b. Support decision making with data analysis

c. Eliminate the need for human judgment

d. Only store customer purchasing history

2. BI systems take data from operational databases and:

a. Hide it from users

b. Manipulate it using charts only

c. Analyze and publish results for decision-makers

d. Delete unwanted fields

3. The three primary BI activities are:

a. Import, export, delete

b. Acquire, analyze, publish

c. Create, revise, distribute

d. Extract, reorder, publish

4. A data warehouse is used to:

a. Replace operational databases

b. Provide clean, integrated data for BI processing

c. Store social media information only

d. Prevent users from accessing historical data

5. A typical problem with operational data is:

a. Too much consistency

b. Missing values and dirty data

c. Perfect formatting

d. Data always being accurate

6. An RFM score is based on:

a. Reliability, Flexibility, Mobility

b. Recency, Frequency, Monetary value

c. Revenue, Forecasting, Marketing

d. Reports, Formatting, Modeling

7. OLAP stands for:

a. Online Analytical Processing

b. Operational Logic and Processing

c. Organizational Learning and Planning

d. Online Application Programs

8. In an OLAP cube, users can:

a. Only view data

b. Drill down into levels of detail

c. Access summaries onlyd. Export data only

9. Data marts differ from data warehouses because:

a. Data marts hold more data

b. They focus on a specific business function

c. They are for executives only

d. Warehouses cannot store historical data

10. A BI system that identifies patterns like “Customers who bought X also buy Y” is:

a. Just-in-time reporting

b. Market-basket analysis

c. Data cleaning

d. OLAP calculation

SECTION 2 — True/False

11. BI systems help organizations make decisions. (T/F)

12. Data warehouses integrate and clean data before analysis. (T/F)

13. Operational data is always ready for BI processing. (T/F)

14. RFM analysis identifies purchasing behavior. (T/F)

15. OLAP allows users to drill down into details. (T/F)

16. Data marts serve the entire enterprise. (T/F)

17. BI systems only work with structured data. (T/F)

18. Market-basket analysis reveals cross-selling patterns. (T/F)

19. BI replaces the need for decision-makers. (T/F)

20. Publishing results is part of the BI process. (T/F)

SECTION 3 — Matching

Match each term with its definition.

A. Data Warehouse

B. Data Mart

C. RFM Analysis

D. OLAP

E. Dirty Data

F. Market-Basket Analysis

G. Acquire Data

H. Analyze Data

I. Publish Results

J. Granularity

21. ___ Step where data is collected and organized.

22. ___ Smaller data collection for one department.

23. ___ Ranks customers based on purchasing recency/frequency.

24. ___ Data with missing values or inconsistencies.

25. ___ Central repository for BI.

26. ___ Step where patterns and insights are found.

27. ___ Level of detail in the data.

28. ___ Sharing results with users.

29. ___ Finds product relationships.

30. ___ Enables drill-down and pivoting.SECTION 4 — Case Study

ARES Fitness wants to use employee fitness tracker data. They struggle because employees forget to

wear devices, data is inconsistent, and different departments store it differently.