If you have a pipeline with a copy data activity, which copies data from an on-prem SQL server to an azure data lake storage account - and you choose some form of compression.
Where is the compression happening? Is the data transfered over the internet to the cloud, and then compressed. Or does it get compressed on-prem by the self-hosted integration runtime?