Google Professional Data Engineer Exam - Topic 6 Question 21 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 21
Topic #: 6

[All Professional Data Engineer Questions]

You are running a pipeline in Cloud Dataflow that receives messages from a Cloud Pub/Sub topic and writes the results to a BigQuery dataset in the EU. Currently, your pipeline is located in europe-west4 and has a maximum of 3 workers, instance type n1-standard-1. You notice that during peak periods, your pipeline is struggling to process records in a timely fashion, when all 3 workers are at maximum CPU utilization. Which two actions can you take to increase performance of your pipeline? (Choose two.)

AIncrease the number of max workers

BUse a larger instance type for your Cloud Dataflow workers

CChange the zone of your Cloud Dataflow pipeline to run in us-central1

DCreate a temporary table in Cloud Bigtable that will act as a buffer for new data. Create a new step in your pipeline to write to this table first, and then create a new pipeline to write from Cloud Bigtable to BigQuery

ECreate a temporary table in Cloud Spanner that will act as a buffer for new data. Create a new step in your pipeline to write to this table first, and then create a new pipeline to write from Cloud Spanner to BigQuery

Show Suggested Answer

Suggested Answer: B, E

by Gracia at May 08, 2022, 01:58 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

Pete

4 months ago

More workers and bigger instances should do the trick!

upvoted 0 times

...

Kami

4 months ago

I think creating a buffer in Bigtable is overkill for this situation.

upvoted 0 times

...

Lashandra

4 months ago

Wait, changing the zone to us-central1? Isn't that slower for EU data?

upvoted 0 times

...

Alica

4 months ago

Definitely agree on using a larger instance type too.

upvoted 0 times

...

Lindsey

5 months ago

Increasing the number of max workers is a solid move!

upvoted 0 times

...

Barbra

5 months ago

Changing the zone to us-central1 doesn't seem right since we're already in europe-west4. I don't think that would help with performance.

upvoted 0 times

...

Demetra

5 months ago

I think we practiced a similar question where increasing workers helped. I feel like option A and B could work well together.

upvoted 0 times

...

Tomoko

5 months ago

I'm a bit unsure about the instance types. Would switching to a larger instance type really make a significant difference?

upvoted 0 times

...

Billy

5 months ago

I remember we discussed increasing the number of max workers to handle more load during peak times. That seems like a solid option.

upvoted 0 times

...

Tammara

5 months ago

Okay, let me break this down. The key here is that we need to give the User on the Reviewer_c record read-only access to the Defect_c record. I think Apex managed sharing or criteria-based sharing might be the way to go.

upvoted 0 times

...

Yong

5 months ago

Hmm, I'm not too familiar with the Cisco Unity Connection restriction table. I'll need to think this through carefully.

upvoted 0 times

...

Tracie

5 months ago

Okay, I've got an idea. If we use Proof instead of [PREVIEW], that should prevent the prefix from deploying in the live sends. I'm feeling confident about that.

upvoted 0 times

...

Lenna

5 months ago

This looks like a pretty straightforward question about HTML5 audio support. I think I can handle this one.

upvoted 0 times

...

Jesusita

5 months ago

Okay, let's see. I think the key here is whether the new requirements are immediately enforced on existing passwords or not. I'll have to weigh the options carefully.

upvoted 0 times

...