A team mixes large ingestion jobs and latency-sensitive BI on one warehouse. What is a reasonable isolation strategy?

1. Increase data retention only
2. Set all BI tables to temporary
3. Use separate appropriately sized warehouses for the workloads
4. Copy every table into a separate account as a first requirement