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
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #213. The question stem and answer options stay visible for context.
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
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery DML#MERGE statement#batch updates#data ingestion