ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!
  • google app store apple app store
    • тЬЦ

      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
      More Data Warehousing Questions
      ask-question