Multiple choice technology platforms and products

In an Aggregator you cannot use sorted input if

  1. The aggregate expression contains nested aggregate functions

  2. The session uses incremental aggregation

  3. Source data is data-driven

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Sorted input cannot be used with nested aggregate functions because they require multiple passes through the data. Incremental aggregation uses cache to track changes across runs, so sorted input is incompatible. Data-driven sessions require cache to handle row-by-row flags, making sorted input unusable.

Keep practicing — related questions