Exam Professional Cloud Developer topic 1 question 227 discussion

It is a good choice for applications that require a high volume of reads and writes, as well as regular backups and capacity planning.

I go with A, since it is a Cloud SQL is a fully managed service that involves less operational overheads.

A or D cloud sql ideal for heavy reads and not ideal for heavy writes spanner ideal for both reads/writes but more about global anyway both are extremely fast - then go for A

https://cloud.google.com/sql/docs/mysql -> no time to manage DB therefore use a manage service

The best option to host the MySQL relational database schema on Google Cloud while minimizing management overhead and maximizing the ability to handle a large volume of reads and writes, backups and ongoing capacity planning would be: A. Configure Cloud SQL to host the database, and import the schema into Cloud SQL. Cloud SQL is a fully-managed service that makes it easy to set up, maintain, manage, and administer your relational databases on Google Cloud. It is specifically designed for MySQL, so it is a good fit for this use case. With Cloud SQL, you can automatically backup your data, and perform capacity planning, so you don't have to worry about managing the infrastructure. Additionally, Cloud SQL provides high availability, automatic failover and easy scaling. Option D and E are not correct since Cloud Spanner is a NoSQL database and Firestore is a document-based database and not suitable for Relational Database.

A, cloud SQL is easy to put in place from an other relational database

The answer A is more likely to be the correct one. Although Cloud Spanner is also a relational DB service (and has certain advantages over Cloud SQL), migrating from MySQL to Cloud Spanner is not as trivial as "import the schema" (stating by the answer D). If D has been excluded, the only relational DB option in the answers is A: Cloud SQL. https://cloud.google.com/spanner/docs/migrating-mysql-to-spanner#migration-process

A is the answer. 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.

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. Answer A

a large volume of reads and writes to the database and will require backups and ongoing capacity planning. Thats Bigtable. Changing my answer to C

Answer A