📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    Which of the following is NOT a common OLAP

    operation?
    A Roll-up (aggregation) Correct Answer Incorrect Answer
    B Drill-down (detail) Correct Answer Incorrect Answer
    C Pivot (rotate) Correct Answer Incorrect Answer
    D Normalize (apply 3NF) Correct Answer Incorrect Answer
    E Slice and dice Correct Answer Incorrect Answer

    Solution

    OLAP operations are analytical (roll-up, drill-down, slice, dice, pivot); normalization is OLTP modeling practice, not OLAP analytical operation.

    Practice Next
    ask-question