Google Professional Data Engineer Exam - Topic 2 Question 25 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 25
Topic #: 2

[All Professional Data Engineer Questions]

Your United States-based company has created an application for assessing and responding to user actions. The primary table's data volume grows by 250,000 records per second. Many third parties use your application's APIs to build the functionality into their own frontend applications. Your application's APIs should comply with the following requirements:

Single global endpoint

ANSI SQL support

Consistent access to the most up-to-date data

What should you do?

AImplement BigQuery with no region selected for storage or processing.

BImplement Cloud Spanner with the leader in North America and read-only replicas in Asia and Europe.

CImplement Cloud SQL for PostgreSQL with the master in Norht America and read replicas in Asia and Europe.

DImplement Cloud Bigtable with the primary cluster in North America and secondary clusters in Asia and Europe.

Show Suggested Answer

Suggested Answer: B

by Teddy at May 06, 2022, 07:44 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Leatha

4 months ago

Cloud Spanner's global setup is a solid move for third-party APIs!

upvoted 0 times

...

Herman

4 months ago

I think Cloud SQL might struggle with that data growth.

upvoted 0 times

...

Holley

4 months ago

Wait, can BigQuery really support ANSI SQL fully?

upvoted 0 times

...

Willard

4 months ago

I disagree, BigQuery could handle the data volume better.

upvoted 0 times

...

Terrilyn

5 months ago

Cloud Spanner seems like the best choice for global consistency.

upvoted 0 times

...

Loren

5 months ago

I recall that Cloud Bigtable is great for large-scale data, but I wonder if it supports ANSI SQL like the question requires.

upvoted 0 times

...

Gracia

5 months ago

I practiced a similar question where Cloud SQL was mentioned, but I feel like it might not handle the high volume as well as Cloud Spanner.

upvoted 0 times

...

Yolando

5 months ago

I'm not entirely sure, but I think BigQuery is more suited for analytics rather than real-time data access.

upvoted 0 times

...

Delsie

5 months ago

I remember we discussed the importance of having a single global endpoint for APIs, which makes me think Cloud Spanner might be a good fit.

upvoted 0 times

...

Margurite

5 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the different system files and how they might relate to FTP access.

upvoted 0 times

...

Rene

5 months ago

Okay, let me think this through. I'm leaning towards option C - Prism Central -> Settings -> Calm -> Enable. That seems like the most logical path to me.

upvoted 0 times

...