Multiple choice technology

More efficient and faster way of eliminating duplicates if there is enough memory

  1. Inmemory scan

  2. Sort and dedup

  3. Rollup

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

In-memory deduplication uses a hash set to track seen records, operating in O(n) time with a single pass. Sort-based dedup requires O(n log n) for sorting plus a pass to remove duplicates. Rollup performs aggregation, not duplicate removal. With sufficient memory, in-memory is fastest.

Keep practicing — related questions