4. How are OLAP queries different from traditional SQL queries?
The common OLAP approach is to focus on the multidimensional cube. Consequently, the queries are based on aggregating across hierarchies of data dimensions. Traditional SQL queries tend to focus on simple totals or row selections.