Bandwidth Interview Question

How and when to use hierarchical queries.