Google Cloud Professional Data Engineer PDE — Topic 1 Question 8

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Use the ROW_NUMBER window function with PARTITION by unique ID along with WHERE row equals 1. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Data Engineer PDE — Question 8