Multiple choice technology databases

When is using Relational OLAP most justified?

    1. Many dimensions, large dense datasets
    1. Few dimensions, small dense datasets
    1. Few dimensions, small sparse datasets
    1. Many dimensions, small sparse datasets
    1. Many dimensions, large sparse datasets
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Relational OLAP (ROLAP) stores data in relational databases and is most suitable when you have few dimensions and small dense datasets. ROLAP avoids the preprocessing overhead of MOLAP and works well when data doesn't have significant sparsity. For many dimensions or large datasets, MOLAP or HOLAP would be more appropriate.

Keep practicing — related questions