New Year Sale 2026! 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 Developer Exam - Topic 12 Question 104 Discussion

Actual exam question for Google's Professional Cloud Developer exam
Question #: 104
Topic #: 12
[All Professional Cloud Developer Questions]

You are developing an application hosted on Google Cloud that uses a MySQL relational database schem

a. The application will have a large volume of reads and writes to the database and will require backups and ongoing capacity planning. Your team does not have time to fully manage the database but can take on small administrative tasks. How should you host the database?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://cloud.google.com/spanner/docs/migrating-mysql-to-spanner#migration-process

Cloud SQL: Cloud SQL is a web service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

https://cloud.google.com/sql/docs/mysql Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform.


Contribute your Thoughts:

0/2000 characters
Krissy
3 months ago
Firestore? That's not even a relational database!
upvoted 0 times
...
Isreal
3 months ago
I agree, Cloud SQL handles backups automatically!
upvoted 0 times
...
Delsie
3 months ago
Wait, why would you use Bigtable for a relational database?
upvoted 0 times
...
Sage
3 months ago
Cloud Spanner sounds cool, but is it really necessary here?
upvoted 0 times
...
Ahmad
4 months ago
Cloud SQL is the way to go for MySQL.
upvoted 0 times
...
Fatima
4 months ago
I feel like Firestore wouldn’t work well for this scenario either, since it’s more suited for NoSQL. Cloud SQL seems like the safest bet.
upvoted 0 times
...
Breana
4 months ago
I’m a bit confused about Bigtable; I don’t think it’s suitable for relational data like MySQL, right?
upvoted 0 times
...
Marcelle
4 months ago
I remember practicing a question similar to this, and I think Cloud Spanner might be overkill for just a MySQL database.
upvoted 0 times
...
Hortencia
4 months ago
I think Cloud SQL is the best option here since it’s fully managed and supports MySQL, but I'm not entirely sure about the backup features.
upvoted 0 times
...
Christiane
5 months ago
I'm leaning towards option A, Configure Cloud SQL to host the database. It seems like the most straightforward and low-maintenance solution, which is important since the team doesn't have a lot of time to manage the database.
upvoted 0 times
...
Loreta
5 months ago
The key here is that the team doesn't have time to fully manage the database, so I think the best approach is to go with a fully managed service like Cloud SQL. That way, Google will handle the heavy lifting, and the team can focus on the application development.
upvoted 0 times
...
Laurena
5 months ago
Hmm, I'm a bit unsure about this one. I know Cloud SQL is a good option, but I'm also wondering if Bigtable or Cloud Spanner might be better for handling the large volume of data. I'll need to review the differences between these services more closely.
upvoted 0 times
...
Dianne
5 months ago
This seems like a straightforward question. I think the best option is to go with Cloud SQL since it's a managed MySQL service that can handle the high volume of reads and writes, as well as backups and capacity planning.
upvoted 0 times
...
Lorrine
11 months ago
Cloud SQL is the way to go. It's the easiest and most straightforward option to get our database up and running quickly.
upvoted 0 times
Pamela
9 months ago
I think Cloud SQL is more user-friendly and efficient for our needs.
upvoted 0 times
...
Stefania
9 months ago
B) Deploy MySQL from the Google Cloud Marketplace to the database using a client, and import the schema.
upvoted 0 times
...
Micah
10 months ago
Cloud SQL is definitely the best choice for us. It's easy to manage and reliable.
upvoted 0 times
...
Marguerita
10 months ago
A) Configure Cloud SQL to host the database, and import the schema into Cloud SQL.
upvoted 0 times
...
...
Quentin
11 months ago
Haha, Firestore for a MySQL database? That's like trying to put a square peg in a round hole. E is definitely not the way to go here.
upvoted 0 times
Meaghan
10 months ago
B) Deploy MySQL from the Google Cloud Marketplace to the database using a client, and import the schema.
upvoted 0 times
...
Jani
10 months ago
A) Configure Cloud SQL to host the database, and import the schema into Cloud SQL.
upvoted 0 times
...
...
Sharika
11 months ago
I think Cloud SQL is the most cost-effective option for us right now.
upvoted 0 times
...
Justine
11 months ago
I'm not sure, I think Cloud Spanner might be a better choice for scalability.
upvoted 0 times
...
Tiffiny
11 months ago
I agree with Ivette. Cloud SQL seems like the best option for our needs.
upvoted 0 times
...
Mozelle
11 months ago
I'd go with D, Cloud Spanner. It's a great fit for the high read/write requirements and we don't have to worry about database administration.
upvoted 0 times
Antonio
10 months ago
Definitely, it's a scalable and fully managed solution that will save us time on database administration tasks.
upvoted 0 times
...
Bernadine
11 months ago
That sounds like a good choice. Cloud Spanner can handle the high volume of reads and writes efficiently.
upvoted 0 times
...
Kris
11 months ago
D) Configure Cloud Spanner to host the database, and import the schema into Cloud Spanner.
upvoted 0 times
...
...
Ivette
12 months ago
I think we should go with option A and configure Cloud SQL to host the database.
upvoted 0 times
...
Kimberely
12 months ago
Option A seems like the obvious choice here. Cloud SQL takes care of the database management so we can focus on the application.
upvoted 0 times
Lavonne
11 months ago
User 3: Definitely, it's important to have a reliable solution like Cloud SQL for our database needs.
upvoted 0 times
...
Lauran
11 months ago
User 2: Yeah, Cloud SQL will handle the database management for us, so we can focus on other tasks.
upvoted 0 times
...
Angelo
11 months ago
User 1: I agree, option A with Cloud SQL sounds like the best choice for us.
upvoted 0 times
...
...

Save Cancel