Answer-first summary for fast verification
Answer: Batch your updates and inserts.
A. Correct. Updating and inserting rows one at a time is not performant. Batch them instead. B. Incorrect. A limit clause is applied at the end of the query, which does not make it performant. C. Incorrect. Filtering data as early as possible reduces the amount of data processed across stages. D. Incorrect. Self-joins are not performant. Use window analytical functions instead.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You need to optimize the performance of queries in BigQuery. Your tables are not partitioned or clustered.
A
Batch your updates and inserts.
B
Use the LIMIT clause to reduce the data read.
C
Filter data as late as possible.
D
Perform self-joins on data.
No comments yet.