PulsePoint Interview Question

On window Functions, Query optimization and BIg Query optimization