A feature of Azure SQL Data Warehouse is the ability to scale (and pay for) compute resources as needed.  This is particularly useful when loading data to a data warehouse.  ETL operations typically put heavy load on the data warehouse, and could benefit from increased computing power.  When the load process completes, however, that extra power may no longer be necessary.