Capgemini Interview Question

Regarding Joins, rollup,scan , senarios