Google Cloud Professional Data Engineer PDE — Topic 1 Question 327

Question

You are designing BigQuery tables for large volumes of clickstream event data. Your data analyst team will most frequently query by specific event date ranges and filter by the user ID UUID. You want to optimize table structure for query cost and performance. What should you do?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Partition the table by the event date column and cluster the table by user ID column.

Google Cloud Professional Data Engineer PDE — Question 327