Question:
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?
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?
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?
Show Hint
Country and State belong to the same geography hierarchy, with State being more detailed than Country. Moving to a more detailed level of an existing hierarchy is Drill-down.
Updated On: Jul 22, 2026
- Slicing
- Dicing
- Roll-up
- Drill-down
Show Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
Step 1: Recall the four OLAP operations.
Slicing picks one fixed value for a single dimension and looks at the resulting lower-dimension cross section, for example fixing Country = India.
Dicing picks a sub-cube by fixing a range or a set of values across two or more dimensions at once.
Roll-up moves up a dimension's concept hierarchy, combining detailed values into a coarser summary, for example City data combined into Country data.
Drill-down does the opposite of roll-up: it moves down a concept hierarchy, breaking a summarized value into its more detailed components.
Step 2: Identify the hierarchy involved here.
In a geography dimension, the usual hierarchy is Country at the top, then State below it, then City below that. Country and State sit on the same dimension (geography), with State being a finer level of detail than Country.
Step 3: Match the change in the question to an operation.
We start with Sales Quantity grouped by Product Type, Month and Country (a coarser, more summarized geography level). We want to move to Sales Quantity grouped by Product Type, Month and State (a more detailed geography level, since one Country contains many States).
No dimension is being removed (Slicing) and no dimension is being restricted to a sub-cube of specific values (Dicing), we are just moving to a lower, more detailed level of the same geography hierarchy.
Step 4: Why the other options are wrong.
(A) Slicing would mean fixing one dimension to a single value and dropping it, which is not what is happening, all three dimensions remain, only the level of detail of one of them changes.
(B) Dicing would mean selecting a sub-cube using multiple dimension restrictions, but here we are not restricting to specific values, we are changing the granularity.
(C) Roll-up would apply if we were going from State to Country (coarser), which is the reverse of what is asked here.
Final Answer:
Moving from Country (coarse) to State (detailed) within the same hierarchy is Drill-down. \[ \boxed{\text{Option (D): Drill-down}} \]
Slicing picks one fixed value for a single dimension and looks at the resulting lower-dimension cross section, for example fixing Country = India.
Dicing picks a sub-cube by fixing a range or a set of values across two or more dimensions at once.
Roll-up moves up a dimension's concept hierarchy, combining detailed values into a coarser summary, for example City data combined into Country data.
Drill-down does the opposite of roll-up: it moves down a concept hierarchy, breaking a summarized value into its more detailed components.
Step 2: Identify the hierarchy involved here.
In a geography dimension, the usual hierarchy is Country at the top, then State below it, then City below that. Country and State sit on the same dimension (geography), with State being a finer level of detail than Country.
Step 3: Match the change in the question to an operation.
We start with Sales Quantity grouped by Product Type, Month and Country (a coarser, more summarized geography level). We want to move to Sales Quantity grouped by Product Type, Month and State (a more detailed geography level, since one Country contains many States).
No dimension is being removed (Slicing) and no dimension is being restricted to a sub-cube of specific values (Dicing), we are just moving to a lower, more detailed level of the same geography hierarchy.
Step 4: Why the other options are wrong.
(A) Slicing would mean fixing one dimension to a single value and dropping it, which is not what is happening, all three dimensions remain, only the level of detail of one of them changes.
(B) Dicing would mean selecting a sub-cube using multiple dimension restrictions, but here we are not restricting to specific values, we are changing the granularity.
(C) Roll-up would apply if we were going from State to Country (coarser), which is the reverse of what is asked here.
Final Answer:
Moving from Country (coarse) to State (detailed) within the same hierarchy is Drill-down. \[ \boxed{\text{Option (D): Drill-down}} \]
Was this answer helpful?
0
0
Top GATE DA Data Science and Artificial Intelligence Questions
- Consider performing depth-first search (DFS) on an undirected and unweighted graph G starting at vertex s. For any vertex u in G, d[u] is the length of the shortest path from s to u. Let (u, v) be an edge in G such that d[u] < d[v]. If the edge (u, v) is explored first in the direction from u to v during the above DFS, then (u, v) becomes a _____ edge.
- Three fair coins are tossed independently. T is the event that two or more tosses result in heads. S is the event that two or more tosses result in tails. What is the probability of the event T ∩ S?
- Consider the matrix \(M=\begin{bmatrix} 2 & -1 \\ 3 & 1 \end{bmatrix}\).
Which ONE of the following statements is TRUE ? - For any twice differentiable function ƒ: R → R, if at some x* ∈ R, f'(x*) = 0 and f'(x*) > 0, then the function f necessarily has a ______ at x = x*.
Note : R denotes the set of real numbers. - Match the items in Column 1 with the items in Column 2 in the following table :
Column 1 Column 2 (p) First In First Out (i) Stacks (q) Lookup Operation (ii) Queues (r) Last In First Out (iii) Hash Tables
View More Questions
Top GATE DA Data Warehousing and Data Mining Questions
- Consider the visualization of a 3-dimensional data cube showing sales quantity for each combination of the attributes Product-type, Month \& Country. From this, if we want to further visualize the sale quantity for each combination of PT, M \& S, which of the following OLAP operator should be performed?
- Consider the concept hierarchies as shown in the figure.
Which of the following options denotes the total number of possible data cuboids from these concept hierarchies?
Top GATE DA Questions
- Consider performing depth-first search (DFS) on an undirected and unweighted graph G starting at vertex s. For any vertex u in G, d[u] is the length of the shortest path from s to u. Let (u, v) be an edge in G such that d[u] < d[v]. If the edge (u, v) is explored first in the direction from u to v during the above DFS, then (u, v) becomes a _____ edge.
- Three fair coins are tossed independently. T is the event that two or more tosses result in heads. S is the event that two or more tosses result in tails. What is the probability of the event T ∩ S?
- Consider the matrix \(M=\begin{bmatrix} 2 & -1 \\ 3 & 1 \end{bmatrix}\).
Which ONE of the following statements is TRUE ? - For any twice differentiable function ƒ: R → R, if at some x* ∈ R, f'(x*) = 0 and f'(x*) > 0, then the function f necessarily has a ______ at x = x*.
Note : R denotes the set of real numbers. - Match the items in Column 1 with the items in Column 2 in the following table :
Column 1 Column 2 (p) First In First Out (i) Stacks (q) Lookup Operation (ii) Queues (r) Last In First Out (iii) Hash Tables
View More Questions