Question 1:

OLAP stands for ?

1. Offline Accounting Practice.
2. Online Transaction Processing.
3. Online Analytical Processing.
4. Online Atomic processing.

Question 2:

An example of alternate hierarchies would be ?

1. Product Size and Shop Location.
2. Fiscal Years and Fiscal quarters vs Calendar Years and quarters, both based on the same months.
3. Grouping people by age as 20-30, 30-40 etc.
4. Product and SKU.

Question 3:

Protecting personal privacy with dimensional data ?

1. Can be improved if the software returns null for any data point represents less than 5 individuals.
2. Is automatic because data is always aggregated.
3. Can be ensured if we don't allow user to drill down to a specific individual.
4. Is achieved by the "peak" approach to dimensional data security.

Question 4:

Semi Additive Measures ?

1. Can be meaningfully added across most dimensions, but not over time
2. Must be averaged rather than added.
3. Can be meaningfully added over time but not other dimensions.
4. Must be aggregate by adding their values then halving the result.

Question 5:

A disadvantage of using ROLAP rather than MOLAP as a storage approach is ?

1. ROLAP uses database technology the company probably already owns and is familiar with.
2. ROLAP cannot handle data volumes as large a MOLAP cubes.
3. Query performance will vary and is not guaranteed.
4. SQL is used as the query language.

Question 6:

Which of these is not a good idea when printing a dashboard?

1. Including what filtering was being applied to generate the charts as shown.
2. Print all the widgets, not just the ones currently visible on screen.
3. Include the Date & time of the data query/extract used.
4. Print in black and white to save on colored ink.

Question 7 :

Managed Dashboards are typically used ?

1. Where everybody's job is a little different.
2. Where the company has identified the optimal way of do each job, and the best data to use.
3. In startup companies, with few staff and no BI team.
4. In a company where staff are encouraged to constantly find new ways to get the work done better.

Question 8 :

When building a dashboard with more widgets than can be fitted on a screen ?

1. Designers always eliminate the lest important charts, so that it does fit, like a car dashboard.
2. Designers always arrange the charts so that the user can see them all if they scroll down rather than across.
3. Designers sometimes collect charts together into meaningful groups, and add a Tabbed UI, Like a dialog box.
4. Designers always shrink the chart size down making small controls that do fit, like a car dashboard.

Question 9 :

Which of these parts of a dashboard display wouldn't be considered a widget ?

1. A UI control which can change any chart type.
2. A list of categories which can be used to filter data
3. A single data value shown by itself.
4. A bar chart.

Question 10:

Local filtering is used ?

1. When we want to show different categories using different charts.
2. When we want the filter to apply to all charts/widgets on the dashboard.
3. To filter data within the user's cache rather than by requiring the underlying database.
4. To understand trend rather than difference.