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

Google Professional Cloud Database Engineer Exam - Topic 5 Question 28 Discussion

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
A) Deploy the database using Cloud SQL.
B) Use BigQuery, and load data in batches.
C) C.Deploy the database using Bigtable.
D) Deploy the database using Cloud Spanner.

Google Professional Cloud Database Engineer Exam - Topic 5 Question 28 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 28
Topic #: 5
[All Professional Cloud Database Engineer Questions]

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

0/2000 characters
Vanesa
7 months ago
I agree, Bigtable seems like the best fit here!
upvoted 0 times
...
Dyan
8 months ago
Wait, can BigQuery really handle real-time data?
upvoted 0 times
...
Merilyn
8 months ago
Definitely not Cloud SQL, it can't handle that scale.
upvoted 0 times
...
Rolande
8 months ago
I think Cloud Spanner might be overkill for this use case.
upvoted 0 times
...
Dorothy
8 months ago
Bigtable is great for handling large volumes of semi-structured data!
upvoted 0 times
...
Shelba
9 months ago
Cloud Spanner sounds appealing because it’s scalable and supports real-time data, but I’m worried about the complexity of managing it.
upvoted 0 times
...
Lili
9 months ago
I feel like Bigtable could be a good choice since it’s designed for high throughput and low latency, but I’m not completely certain.
upvoted 0 times
...
Cassie
9 months ago
I think BigQuery is great for analytics, but it’s more about batch processing, right? Not sure if it’s the best fit for real-time needs.
upvoted 0 times
...
Charolette
9 months ago
I remember we discussed that Cloud SQL might not handle the scale of 100,000 sensors effectively, so I’m leaning away from that option.
upvoted 0 times
...
Sherrell
9 months ago
I feel pretty confident about this one. Based on the requirements, I would go with option D and deploy the database using Cloud Spanner. It's designed for high-throughput, low-latency applications, which seems perfect for this use case.
upvoted 0 times
...
Elza
9 months ago
Okay, let me think this through. We need to handle a huge amount of data from 100,000 sensors, with 10 readings per second. That's a lot of data! I think the key here is to find a solution that can ingest and process this data in real-time, so I'm leaning towards option B with BigQuery.
upvoted 0 times
...
Aliza
9 months ago
Hmm, I'm a bit unsure about this one. The question mentions real-time monitoring and analysis, so I'm not sure if Bigtable is the best fit. Maybe I should look into the other options as well, like BigQuery or Cloud Spanner.
upvoted 0 times
...
Leigha
9 months ago
This seems like a pretty straightforward question. I'd go with option C and deploy the database using Bigtable. It's designed for handling large volumes of semi-structured data, which is exactly what we need here.
upvoted 0 times
...
Graciela
9 months ago
Hmm, I'm a bit confused. Increasing the network bandwidth to 2 Gbps or 10 Gbps seems like a lot of work. I'm leaning towards keeping the 1 Gbps link and doing an offline migration.
upvoted 0 times
...
Thomasena
10 months ago
I'm pretty confident I know the answer to this one. The EnterpriseOne Server Manager Console is certified to run on Linux, Windows, and IBM System I.
upvoted 0 times
...
Daniela
1 year ago
Wow, 100,000 sensors? That's a lot of data! I hope the person who has to manage that infrastructure gets paid well. Bigtable seems like the right choice to handle all that semi-structured goodness.
upvoted 0 times
...
Novella
1 year ago
If I had a 100,000 sensors sending data at 10 readings per second, I'd be tempted to just use a rubber band and a paper clip to collect it all. But in all seriousness, Bigtable sounds like the way to go here.
upvoted 0 times
Marguerita
1 year ago
Using Bigtable would definitely help with real-time monitoring and analysis of all that sensor data.
upvoted 0 times
...
Laquita
1 year ago
I agree, Bigtable is designed for massive scale and high throughput.
upvoted 0 times
...
Mozell
1 year ago
Bigtable sounds like a good option for handling that amount of data.
upvoted 0 times
...
...
Darell
1 year ago
Cloud Spanner might be overkill for this use case. I'd stick with a NoSQL solution like Bigtable to handle the high throughput and semi-structured data.
upvoted 0 times
...
Tina
1 year ago
I'd go with Bigtable. It's designed for handling large-scale, semi-structured data, and it can provide the real-time performance you need for monitoring.
upvoted 0 times
...
Ocie
1 year ago
BigQuery seems like the best option here. Dealing with semi-structured data from so many sensors and requiring real-time monitoring is a perfect use case for a data warehouse like BigQuery.
upvoted 0 times
Junita
1 year ago
D) Deploy the database using Cloud Spanner.
upvoted 0 times
...
Reita
1 year ago
C) Deploy the database using Bigtable.
upvoted 0 times
...
Tamekia
1 year ago
B) Use BigQuery, and load data in batches.
upvoted 0 times
...
Jesusa
1 year ago
A) Deploy the database using Cloud SQL.
upvoted 0 times
...
...
Lanie
1 year ago
I'm leaning towards deploying the database using Cloud Spanner for better scalability and consistency.
upvoted 0 times
...
Norah
1 year ago
I disagree, I believe deploying the database using Bigtable would be a better option for real-time monitoring.
upvoted 0 times
...
Chauncey
1 year ago
I think we should use BigQuery and load data in batches.
upvoted 0 times
...

Save Cancel