PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2026 paper

Module 1: Data Warehousing and Business Analysis

20262m

Which 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

Search GoogleAsk AI
Worked SolutionAI Assisted

Solution

Correct Answer: (iii) Star schema

Explanation

A star schema has one large central fact table (measures such as sales amount, plus foreign keys) directly connected to several dimension tables (such as time, product, customer, location). The diagram looks like a star, and the dimension tables are usually denormalized, which keeps queries simple and fast.

Why other options are incorrect:

  • (i) Network schema and (ii) Hierarchical schema - old database models, not data warehouse schemas.
  • (iv) Object schema - used in object-oriented databases.

Key Points to Remember:

  • Snowflake schema = star schema with normalized dimension tables.
  • Fact constellation = several fact tables sharing dimensions.

Answer: (iii) Star schema

Similar questions

Data MiningWhich schema is most commonly used in a data warehouse? (i) Star schema (ii) Snowflake schema (iii) Network schema (iv) Tree schema20242mData MiningA Data Warehouse is generally built using which schema for decision support? (i) Hierarchical Schema (ii) Star or Snowflake Schema (iii) Relational Schema (iv) Network Schema20252mDatabase Management SystemData models in DBMS are classified into _____ categories. (i) 3 (ii) 4 (iii) 5 (iv) 220182mDatabase Management SystemThe way a particular application views the data from the database that the application uses is a (i) module (ii) relational model (iii) schema (iv) subschema20202m
PreviousA 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) 360NextIf a dataset contains extreme outliers that strongly affect the mean, which measure is generally more robust for describing central tendency? (i) Mean (ii) Variance (iii) Median (iv) Standard deviation
Budget AppAndroid App

Pocketly on Android

Log daily food, travel, and hostel expenses instantly. Set monthly spending limits and see where your money goes without complex spreadsheets.

Install Pocketly