Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.