$12$:$00-13$:$30(1\mathrm{.}5$ Hours$)$

The exam is open book, and permits the use of reference materials but strictly prohibits the use of Generative AI $($ChatGPT$,$ etc.$).$ Any reliance on

G$.$Al will result in a score of zero.

Multiple Choice $(6$ Marks$)$

Which of the following is NOT an example of transaction processing?

a$.$ ATM withdrawal

b$.$ bank deposit

c$.$ sales report

d$.$ cash register scans

What has caused the growth of the demand for instant, on$-$demand access to dispersed information?

a$.$ the increasing divide between users who focus on the strategic level and those who are more oriented to the tactical level

b$.$ the need to create a database infrastructure that is always online and contains all the information from the OLTP systems

c$.$ the more pressing need to close the gap between the operational data and strategic objectives

d$.$ the fact that BI cannot simply be a technical exercise for the information systems department

What type of analytics seeks to determine what is likely to happen in the future?

a$.$ descriptive

b$.$ prescriptive

c$.$ predictive

d$.$ domain

Which type of visualization tool can be very helpful when the intention is to show relative proportions of BHD per department allocated by UOB administration?

a$.$ heat map

b$.$ bullet

c$.$ pie chart

d$.$ bubble chart

This measure of central tendency is the sum of all the values$/$observations divided by the number of observations in the data set.

a$.$ dispersion

b$.$ mode

c$.$ median

d$.$ arithmetic mean

What is the management feature of a dashboard?

a$.$ operational data that identify what actions to take to resolve a problem

b$.$ summarized dimensional data to analyze the root cause of problems

c$.$ summarized dimensional data to monitor key performance metrics

d$.$ graphical, abstracted data to monitor key performance metrics