Question

In a star schema, what is the main advantage of using surrogate keys in fact tables?

A Reduce query time with indexes
B Allow natural key reuse across dimensions
C Maintain referential integrity during slowly changing dimensions
D Optimize ETL processes with uniqueness
E All of the above
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)