Google Cloud Professional Cloud Developer — Question 137

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct option is A because Cloud SQL is a fully managed service designed for relational databases like MySQL, which reduces the administrative burden on your team while still allowing for necessary backups and scaling. Options B and D require more management effort as they involve deploying MySQL manually or using Cloud Spanner, which is not specifically tailored for MySQL. Option C and E are also incorrect because Bigtable and Firestore are not relational databases and would not support the MySQL schema effectively.