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 Cloud Developer Exam - Topic 12 Question 104 Discussion

You are developing an application hosted on Google Cloud that uses a MySQL relational database schema. 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?
A) Configure Cloud SQL to host the database, and import the schema into Cloud SQL.
B) Deploy MySQL from the Google Cloud Marketplace to the database using a client, and import the schema.
C) Configure Bigtable to host the database, and import the data into Bigtable.
D) Configure Cloud Spanner to host the database, and import the schema into Cloud Spanner.
E) Configure Firestore to host the database, and import the data into Firestore.

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.


by Margurite at Mar 21, 2025, 10:50 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Krissy
9 months ago
Firestore? That's not even a relational database!
upvoted 0 times
...
Isreal
9 months ago
I agree, Cloud SQL handles backups automatically!
upvoted 0 times
...
Delsie
9 months ago
Wait, why would you use Bigtable for a relational database?
upvoted 0 times
...
Sage
9 months ago
Cloud Spanner sounds cool, but is it really necessary here?
upvoted 0 times
...
Ahmad
9 months ago
Cloud SQL is the way to go for MySQL.
upvoted 0 times
...
Fatima
10 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
10 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
10 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
10 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
11 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
11 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
11 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
11 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
1 year 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
1 year ago
I think Cloud SQL is more user-friendly and efficient for our needs.
upvoted 0 times
...
Stefania
1 year ago
B) Deploy MySQL from the Google Cloud Marketplace to the database using a client, and import the schema.
upvoted 0 times
...
Micah
1 year ago
Cloud SQL is definitely the best choice for us. It's easy to manage and reliable.
upvoted 0 times
...
Marguerita
1 year ago
A) Configure Cloud SQL to host the database, and import the schema into Cloud SQL.
upvoted 0 times
...
...
Quentin
1 year 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
1 year ago
B) Deploy MySQL from the Google Cloud Marketplace to the database using a client, and import the schema.
upvoted 0 times
...
Jani
1 year ago
A) Configure Cloud SQL to host the database, and import the schema into Cloud SQL.
upvoted 0 times
...
...
Sharika
1 year ago
I think Cloud SQL is the most cost-effective option for us right now.
upvoted 0 times
...
Justine
1 year ago
I'm not sure, I think Cloud Spanner might be a better choice for scalability.
upvoted 0 times
...
Tiffiny
1 year ago
I agree with Ivette. Cloud SQL seems like the best option for our needs.
upvoted 0 times
...
Mozelle
1 year 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
1 year ago
Definitely, it's a scalable and fully managed solution that will save us time on database administration tasks.
upvoted 0 times
...
Bernadine
1 year ago
That sounds like a good choice. Cloud Spanner can handle the high volume of reads and writes efficiently.
upvoted 0 times
...
Kris
1 year ago
D) Configure Cloud Spanner to host the database, and import the schema into Cloud Spanner.
upvoted 0 times
...
...
Ivette
1 year ago
I think we should go with option A and configure Cloud SQL to host the database.
upvoted 0 times
...
Kimberely
1 year 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
1 year ago
User 3: Definitely, it's important to have a reliable solution like Cloud SQL for our database needs.
upvoted 0 times
...
Lauran
1 year ago
User 2: Yeah, Cloud SQL will handle the database management for us, so we can focus on other tasks.
upvoted 0 times
...
Angelo
1 year ago
User 1: I agree, option A with Cloud SQL sounds like the best choice for us.
upvoted 0 times
...
...

Save Cancel