Google Exam Professional Data Engineer Topic 1 Question 27 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 27
Topic #: 1

[All Professional Data Engineer Questions]

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?

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

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

Show Suggested Answer

Suggested Answer: A

by Felix at May 05, 2022, 05:40 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!