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 28 of 118
Free Preview · 118 of 392 · questions 1–118 of 392 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.
- A 7-day trailing window per user: partition by user_id, order by date, frame 6 rows before the current row (rowsBetween(-6, 0)). Use with F.avg over that window. Option B misses partitioning. Option C partitions by date (wrong). Option D is invalid syntax.