Google
PROFESSIONAL-DATA-ENGINEER · Question #213
The marketing team at your organization provides regular updates of a segment of your customer dataset. The marketing team has given you a CSV with 1 million
The correct answer is D. Import the new records from the CSV file into a new BigQuery table. Create a BigQuery job that merges the new records with the existing records and writes. Explanation/Reference: https://cloud.google.com/blog/products/gcp/performing-large-scale-mutations-in-bigquery
Submitted by deeparc· Mar 30, 2026Building and operationalizing data processing systems
Question
The marketing team at your organization provides regular updates of a segment of your customer dataset. The marketing team has given you a CSV with 1 million
Options
- BIncrease the BigQuery UPDATE DML statement limit in the Quota management section of the Google Cloud Platform Console.
- CSplit the source CSV file into smaller CSV files in Cloud Storage to reduce the number of BigQuery UPDATE DML statements per BigQuery job.
- DImport the new records from the CSV file into a new BigQuery table. Create a BigQuery job that merges the new records with the existing records and writes
How the community answered
(16 responses)- B6% (1)
- C13% (2)
- D81% (13)
Explanation
Explanation/Reference: https://cloud.google.com/blog/products/gcp/performing-large-scale-mutations-in-bigquery
Topics
#BigQuery DML#MERGE statement#batch updates#data ingestion
Community Discussion
No community discussion yet for this question.