Use standard compute clusters (the default) for all workloads except compute-intensive analytic workloads.
On a standard compute cluster, at most 30 queries can run concurrently. Queries that call the APPLY operator cannot run on a standard compute cluster. The APPLY operator must run on an analytic or analytic GPU compute cluster.