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 2 Question 25 Discussion

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 endpointANSI SQL supportConsistent access to the most up-to-date dataWhat should you do?
B) Implement Cloud Spanner with the leader in North America and read-only replicas in Asia and Europe.
A) Implement BigQuery with no region selected for storage or processing.
C) Implement Cloud SQL for PostgreSQL with the master in Norht America and read replicas in Asia and Europe.
D) Implement Cloud Bigtable with the primary cluster in North America and secondary clusters in Asia and Europe.

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?

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

0/2000 characters
Submit Cancel
Leatha
10 months ago
Cloud Spanner's global setup is a solid move for third-party APIs!
upvoted 0 times
...
Herman
10 months ago
I think Cloud SQL might struggle with that data growth.
upvoted 0 times
...
Holley
11 months ago
Wait, can BigQuery really support ANSI SQL fully?
upvoted 0 times
...
Willard
11 months ago
I disagree, BigQuery could handle the data volume better.
upvoted 0 times
...
Terrilyn
11 months ago
Cloud Spanner seems like the best choice for global consistency.
upvoted 0 times
...
Loren
11 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
11 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
11 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
11 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
11 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
11 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
...

Save Cancel