Reference no: EM133487303

Question 1: OLAP stands for?

• Offline Accounting Practice.
• Online Transaction Processing.
• Online Analytical Processing.
• Online Atomic processing.

Question 2: An example of alternate hierarchies would be?

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

Question 3: Protecting personal privacy with dimensional data?

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

Question 4: Semi Additive Measures?

• Can be meaningfully added across most dimensions, but not over time
• Must be averaged rather than added.
• Can be meaningfully added over time but not other dimensions.
• 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?

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

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

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

Question 7: Managed Dashboards are typically used?

• Where everybody's job is a little different.
• Where the company has identified the optimal way of do each job, and the best data to use.
• In startup companies, with few staff and no BI team.
• 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?

• Designers always eliminate the lest important charts, so that it does fit, like a car dashboard.
• Designers always arrange the charts so that the user can see them all if they scroll down rather than across.
• Designers sometimes collect charts together into meaningful groups, and add a Tabbed UI, Like a dialog box.
• 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?

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

Question 10: Local filtering is used?

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