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


    ⚡ Month End Offer- Few Hours Left Flat 55% Off On All Courses!! Coode - OCT55 Enroll Now ⚡
    00:00:00 AM Left

    Question

    Which OLAP operation involves focusing on a subset of

    dimensions (e.g., region=‘Asia’)?
    A Roll-up Correct Answer Incorrect Answer
    B Drill-down Correct Answer Incorrect Answer
    C Slice Correct Answer Incorrect Answer
    D Dice Correct Answer Incorrect Answer
    E Pivot Correct Answer Incorrect Answer

    Solution

    Slice reduces the cube by fixing one dimension value (like filtering rows in SQL). Dice filters multiple values, roll-up aggregates, drill-down goes deeper into hierarchy, pivot rotates.

    Practice Next
    ask-question