Accenture Interview Question

Detailed questions of SQL and Dimensional modeling