Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 8 of 103
Free Preview · 103 of 342 · questions 1–103 of 342 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
D but it needs ORDER BY and should use QUALIFY instead of WHERE
D is closest, as there will always be at least 1 row for each ID. Would have rather used SELECT DISTINCT.
D ensures data is partitioned by the unique id and only one record is picked thereby ensuring results are de-duplicated