Answer-first summary for fast verification
Answer: Transfer the new records from the CSV file into a fresh BigQuery table. Then, use a BigQuery job to combine these new records with the existing ones, outputting the results to another new BigQuery table.
Option D is correct because importing new records into a separate BigQuery table and merging them with existing records through a BigQuery job not only circumvents the quotaExceeded error but also offers enhanced flexibility and control over the update process. This approach is particularly beneficial for frequent updates requiring meticulous oversight.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a recommended method to resolve a quotaExceeded error when attempting to update a CSV file containing 1 million records in BigQuery?
A
Divide the source CSV file into smaller segments stored in Cloud Storage to minimize the number of BigQuery UPDATE DML statements per job.
B
Enhance the BigQuery UPDATE DML statement limit via the Quota management section in the Google Cloud Platform Console.
C
Restrict the daily update of records to prevent reaching the BigQuery UPDATE DML statement limit.
D
Transfer the new records from the CSV file into a fresh BigQuery table. Then, use a BigQuery job to combine these new records with the existing ones, outputting the results to another new BigQuery table.
No comments yet.