Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 1 Question 27 Discussion

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.

Google Professional Data Engineer Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Junita
7 months ago
I think B is a waste of time, just work within the limits!
upvoted 0 times
...
Ariel
7 months ago
C is a solid option, splitting files can help manage the load.
upvoted 0 times
...
Darci
8 months ago
Wait, can you really increase the UPDATE limit? Sounds odd!
upvoted 0 times
...
Jackie
8 months ago
I disagree, D might be more efficient in the long run.
upvoted 0 times
...
Eric
8 months ago
A seems like the most straightforward solution.
upvoted 0 times
...
Paz
8 months ago
I don't think we can increase the DML limits in the console, right? That seems like it wouldn't be the best approach for this situation.
upvoted 0 times
...
Michael
8 months ago
I vaguely recall a practice question where we had to merge records, so option D sounds familiar. It might be a more efficient way to handle the updates.
upvoted 0 times
...
Francesco
8 months ago
I think splitting the CSV into smaller files could help with the quotaExceeded error, but I wonder if that would complicate the update process.
upvoted 0 times
...
Cherri
8 months ago
I remember something about the limits on UPDATE statements in BigQuery, so reducing the number of records might be a good idea, but I'm not sure how much to reduce it by.
upvoted 0 times
...
Francesco
8 months ago
This seems like a straightforward user story question. I'd focus on the key details - the request is for visibility into sales reps' pipeline and revenue. The missing component is likely the "who" since that's not explicitly stated.
upvoted 0 times
...
Shelba
8 months ago
I think they're maybe combined at runtime? I recall a practice question that had similar wording.
upvoted 0 times
...
Elza
8 months ago
Okay, let me think this through. I guess it depends on the scale of the change, but my initial instinct is to go with option D and request change control board involvement.
upvoted 0 times
...
Alba
8 months ago
I thought fragments were only for UI components. I'm hesitant about this one but leaning towards “True” based on what I practiced.
upvoted 0 times
...
Major
8 months ago
Hmm, I'm not sure I remember the exact statistic from Xplor '06. I'll have to think this through and try to eliminate any options that don't seem plausible.
upvoted 0 times
...

Save Cancel