1. Home
  2. Discussions
  3. Google
  4. Google Cloud Certified
  5. Professional-Data-Engineer Discussions
  6. Professional-Data-Engineer Exam Topic 2 Question 12 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 12 Topic 2 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 12 Topic 2 Discussion

Professional-Data-Engineer Exam Topic 2 Question 12 Discussion:
Question #: 12
Topic #: 2

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 records that must be updated in BigQuery. When you use the UPDATE statement in BigQuery, you receive a quotaExceeded error. What should you do?
A.

Reduce the number of records updated each day to stay within the BigQuery UPDATE DML statement limit.

B.

Increase the BigQuery UPDATE DML statement limit in the Quota management section of the Google Cloud Platform Console.

C.

Split the source CSV file into smaller CSV files in Cloud Storage to reduce the number of BigQuery UPDATE DML statements per BigQuery job.

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 the results to a new BigQuery table.

Get Premium Professional-Data-Engineer Questions
Actual exam question for Google Professional-Data-Engineer exam by Quill97329 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next