chapter
    Data Warehousing PYQs for GATE DA

    GATE DA Data Warehousing: 2 chapters, 3 previous year questions (14% of Database Management and Warehousing), 0 practice questions and one solved question fro

    A question from this chapter

    Question 1
    2026 PYQ
    Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country.
    From this, if we want to further visualize the Sales Quantity for each combination of Product Type, Month and State, which of the following OLAP operations should be performed?
    Question 2
    2026 PYQ
    Consider the concept hierarchies as shown in the figure.

    Year Month Day Country State City Item Category Item Type Item

    Which of the following options denotes the total number of possible data cuboids from these concept hierarchies?
    Free preview ends here

    Login to view the complete previous-year questions and solutions

    Creating an account is free. You get the rest of this chapter, step-by-step solutions, and a study plan built around the topics you are actually weak at.

    Login to continueSee plans
    Why MastersUp

    Personalised first. High quality throughout.

    Most platforms hand everyone the same content. Here the content moves with your performance, topic by topic.

    Built around you, not around a syllabus PDF

    Every answer you give moves your topic-level intelligence rate. The next question, the next revision card and tomorrow's plan all change with it.

    Revision that hits your weak spots

    We only revise topics you have actually attempted and are still below the safe bar on — never the same chapter on repeat.

    Questions calibrated to the real exam

    Each question carries a measured toughness. You are served a rung above your current level, so practice keeps stretching you.

    Notes written for recall, not for volume

    Full lesson cards for first study, curated short-note cards for the last mile — with derivations, traps and exam patterns marked.

    One place for everything

    Notes, chapter practice, previous-year questions, test series and full-length papers — all feeding one picture of your preparation.

    Honest progress

    No vanity streaks. Progress here means chapters mastered and accuracy that held up on harder questions.

    Unlock the whole course

    Full notes and short notes, the complete question bank with worked solutions, mock tests, full-length papers, and an adaptive plan that rebuilds itself as you improve.

    View all plansStart free

    Data Warehousing PYQs for GATE DA

    GATE DA Data Warehousing: 2 chapters, 3 previous year questions (14% of Database Management and Warehousing), 0 practice questions and one solved question from each chapter.

    About Data Warehousing Previous Year Questions (PYQs)

    3 previous year questions from Data Warehousing in GATE DA, grouped by chapter with the exam year, answer key and step-by-step solution for each.

    Data Warehousing Weightage in GATE DA

    Data Warehousing accounts for 3 of 22 Database Management and Warehousing previous year questions in our bank (14%), about 1.5 per paper across 2 papers.

    Data Warehousing Chapter Matrix

    ChapterTopicsPYQsShare of unit PYQsPractice questions
    OLAP Operations and Data Cube AggregationData Cube Aggregation and OLAP Grouping, OLAP Operations: Roll-Up, Drill-Down, Slice and Dice267%0
    Concept Hierarchies and Multidimensional Data ModelsConcept Hierarchies and Multidimensional Data Models133%0

    More from Database Management and Warehousing

    One Solved Question from Each Data Warehousing Chapter

    Question 1 · OLAP Operations and Data Cube Aggregation · 2026 MCQ
    Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country.
    From this, if we want to further visualize the Sales Quantity for each combination of Product Type, Month and State, which of the following OLAP operations should be performed?
    1. A.

      Slicing

    2. B.

      Dicing

    3. C.

      Roll-up

    4. D.

      Drill-down

    Question 2 · Concept Hierarchies and Multidimensional Data Models · 2026 MCQ
    Consider the concept hierarchies as shown in the figure.

    Year Month Day Country State City Item Category Item Type Item

    Which of the following options denotes the total number of possible data cuboids from these concept hierarchies?
    1. A.

    2. B.

    3. C.

    4. D.