Multiple choice technology

A dataset needs to be sorted to retain a single occurrence of multiple records that have identical sorting key values. Which sort option can be selected to achieve this

  1. Stable sort must be set to true

  2. Sort group must include the sort key values

  3. Allow duplicates must be set to False

  4. Unique sort keys must be set to True
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Setting 'Allow duplicates' to False during sorting ensures that only one record is retained for each unique sort key value, effectively deduplicating the dataset while sorting. A stable sort (option A) preserves relative order of equal elements but doesn't remove duplicates. Sort groups (option B) define grouping behavior, not duplicate handling.

Keep practicing — related questions