Deloitte interview question

bq optimization techniques in gcp