Interview question asked to Data Scientists interviewing at Shopify, Mollie, Coupang 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?.