Interview question asked to Data Scientists interviewing at Disney, Red Hat, Stripe and other companies. Original question asked: What happens behind the scenes when a cloud data warehouse uses dynamic partition pruning during a complex join operation?.