PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2026 paper

Module 1: Data Warehousing and Business Analysis

20262m

A data cube contains 5 products, 4 regions and 12 months. The total number of base-level cells is

(i) 120
(ii) 240
(iii) 180
(iv) 360

Search GoogleAsk AI
Worked SolutionAI Assisted

Solution

Correct Answer: (ii) 240

Explanation

In a data cube, the number of base-level (apex-excluded, lowest-level) cells is the product of the number of distinct values in each dimension:

Cells = products x regions x months = 5 x 4 x 12 = 240

Each cell stores one measure value (for example total sales) for one unique combination of product, region and month.

Why other options are incorrect:

  • (i) 120 - ignores one dimension (5 x 4 x 6 or similar).
  • (iii) 180 and (iv) 360 - not the product of 5, 4 and 12.

Answer: (ii) 240

Similar questions

Data MiningA data warehouse contains sales data for 4 regions, 12 months and 5 product categories. Each combination stores the total sales value. Determine: (i) The total number of possible multidimensional cells, (ii) The number of cells required for one region across all months and products and (iii) Explain how roll-up, drill-down, slice and dice operations can be performed on this cube.20267mData MiningIf no hierarchy is associated with an n-dimensional data cube, how many cuboids would there be? (i) n³ (ii) n (iii) 2ⁿ (iv) n²20232mOPERATING SYSTEMConsider a disk queue with requests for I/O to blocks on cylinders. 98 183 37 122 14 124 65 67. Considering FCFS (first cum first served) scheduling, the total number of head movements is, if the disk head is initially at 53 is? (i) 600 (ii) 630 (iii) 620 (iv) 64020242mDatabase Management SystemData models in DBMS are classified into _____ categories. (i) 3 (ii) 4 (iii) 5 (iv) 220182m
NextWhich schema generally contains a central fact table connected directly to multiple dimension tables? (i) Network schema (ii) Hierarchical schema (iii) Star schema (iv) Object schema
Student FinanceWeb Platform

Pocketly — Personal Finance for Students

Keep your hostel and college expenses under control. Track accounts, log spending in seconds, and stay within your monthly budget.

Open Pocketly