Font size
WorksheetsASM654 CHAPTER 6
Total questions: 10
Worksheet time: 5mins
Which of the followings are the key features of OLAP?
Supports analysis, dynamic synthesis and consolidation of large volumes of multi-dimensional data.
Is able to drill down or roll up with each dimension.
Does not have ability to answer ‘what if?’ and ‘why?’ type questions.
Can easily answer ‘who?’ and ‘what?'
Differentiate OLTP and Data Warehouse.
OLTP has very low analytical capabilities, data warehouse has moderate
OLTP has very fast response time, data warehouse has fast to moderate.
OLTP has large size of result set, data warehouse has small.
OLTP has detail data granularity, data warehouse has detail and summary.
Tick all basic features of OLAP
Consistent performance
Slice-and-dice or rotation
Drill-down and roll-up
Single view modes
Tick all advanced features of OLAP
Easy scalability
Powerful calculations
Cross-dimensional calculations
Time intelligence
Tick all OLAP benefits
Increased productivity of end-users.
Distinguishes OLAP from general-purpose query tools.
Improved potential revenue and profitability
Can be implemented on the web.
Which of the followings are OLTP characteristics.
Relational
Summarized
Historical
Process oriented
Which of the followings are OLAP characteristics.
A record-at-a-time
Summarized
Multidimensional
Atomized
Which of the followings are key features of OLAP?
Is not able to drill down or roll up with each dimension.
Is capable of applying mathematical formulas and calculations to measures.
Can easily answer ‘who?’ and ‘what?’
Does not supports analysis, dynamic synthesis and consolidation of large volumes of multi-dimensional data.
Choose one example of OLAP applications in functional areas.
Sales - market research analysis
Finance - financial performance analysis
Marketing - sales analysis
Manufacturing - sales forecasting
Slice-and-dice is ________ of OLAP.
basic features
advanced features
complex features
