PROFESSIONAL-DATA-ENGINEER · Question #8
PROFESSIONAL-DATA-ENGINEER Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively querying data. Which query type should you use?
Options
- AInclude ORDER BY DESK on timestamp column and LIMIT to 1.
- BUse GROUP BY on the unique ID column and timestamp column and SUM on the values.
- CUse the LAG window function with PARTITION by unique ID along with WHERE LAG IS NOT NULL.
- DUse the ROW_NUMBER window function with PARTITION by unique ID along with WHERE row equals 1.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.