VantageCloud Lake is chosen for a workload due to its ability to use Compute Clusters for intelligent scaling. This ability allows the system to dynamically scale resources based on workload demands, providing flexibility and efficiency in managing varying workloads. VantageCloud Enterprise may not offer this specific capability, making VantageCloud Lake a more suitable choice for tasks requiring such intelligent scaling capabilities.