Google Professional Cloud Database Engineer Exam - Topic 10 Question 14 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 14
Topic #: 10

[All Professional Cloud Database Engineer Questions]

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

AUse Cloud SQL with read replicas for throughput.

BUse Firestore, and rely on automatic serverless scaling.

CUse Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.

DUse Bigtable, and add nodes as necessary to achieve the required throughput.

Show Suggested Answer

Suggested Answer: C

by Willard at Feb 07, 2023, 03:45 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Christiane

4 months ago

Wait, can Memorystore even manage that kind of load?

upvoted 0 times

...

Cassi

4 months ago

D sounds solid, but can it really handle 100 TB?

upvoted 0 times

...

Aliza

4 months ago

Cloud SQL? Really? That seems risky for millions of requests.

upvoted 0 times

...

Noble

4 months ago

I think Firestore might struggle with that scale.

upvoted 0 times

...

Catalina

4 months ago

Bigtable is designed for high throughput!

upvoted 0 times

...

Quentin

5 months ago

Bigtable sounds like a good fit since it’s designed for high throughput and can scale easily, so I’m leaning towards option D.

upvoted 0 times

...

Paulene

5 months ago

I feel like Memorystore is more for caching rather than long-term storage, so option C seems off to me.

upvoted 0 times

...

Lorriane

5 months ago

I think Firestore could work for automatic scaling, but I’m not confident it can handle the latency requirements.

upvoted 0 times

...

Flo

5 months ago

I remember we discussed how Cloud SQL might struggle with such high throughput, so I’m not sure about option A.

upvoted 0 times

...

Beula

5 months ago

I'm a bit confused by the wording of these options. I'll need to re-read them a few times to make sure I understand the differences.

upvoted 0 times

...

Venita

5 months ago

I think the best option is definitely A, since we want to follow the requirements clearly for naming in the SOAP message.

upvoted 0 times

...

Xuan

5 months ago

Hmm, I'm a bit confused on this one. I thought there was a way to prevent the contract address from changing, but I can't remember the details. I'll have to think this through carefully.

upvoted 0 times

...

Rebeca

5 months ago

B seems right - there's no guaranteed order of execution, so I'll need to design my code to handle that scenario.

upvoted 0 times

...

Gracia

9 months ago

I'm just picturing the poor database admin trying to keep up with adding Bigtable nodes like a hamster on a wheel. 'Wheee, another node! Wheee, another node!'

upvoted 0 times

Evelynn

8 months ago

D) Bigtable seems like the best option for handling the required throughput.

upvoted 0 times

...

Lavonne

8 months ago

C) Memorystore for Memcached sounds like a good choice for adding nodes as needed.

upvoted 0 times

...

Tijuana

8 months ago

B) I think Firestore would be a better option for automatic scaling.

upvoted 0 times

...

Kenneth

9 months ago

A) Use Cloud SQL with read replicas for throughput.

upvoted 0 times

...

Melodie

9 months ago

Cloud SQL with read replicas? Really? That's like trying to use a bicycle to haul a freight train. This application needs serious big-data firepower, not your grandpa's SQL database.

upvoted 0 times

Katina

8 months ago

Cloud SQL with read replicas won't cut it for this kind of workload.

upvoted 0 times

...

Hoa

8 months ago

D) Use Bigtable, and add nodes as necessary to achieve the required throughput.

upvoted 0 times

...

Sherron

9 months ago

A) Use Bigtable, and add nodes as necessary to achieve the required throughput.

upvoted 0 times

...

Cassie

10 months ago

Ooh, Memorystore for Memcached? That's an interesting idea! But I'm not sure if it can keep up with the insane throughput and data volume this application needs. Definitely not a good fit in my opinion.

upvoted 0 times

...

Aileen

10 months ago

I'm not so sure about Bigtable. What about Firestore? It's serverless, so you don't have to worry about scaling it up yourself. And it can probably handle the data volume and throughput requirements.

upvoted 0 times

Lezlie

8 months ago

D) Use Bigtable, and add nodes as necessary to achieve the required throughput.

upvoted 0 times

...

Martina

9 months ago

B) Use Firestore, and rely on automatic serverless scaling.

upvoted 0 times

...

Taryn

9 months ago

A) Use Cloud SQL with read replicas for throughput.

upvoted 0 times

...

Kristofer

10 months ago

Hmm, I think option D is the way to go. Bigtable can handle massive amounts of data and scale up to millions of requests per second. Plus, it's designed for time-series data like IoT sensor data.

upvoted 0 times