Question-45: You can set up, maintain, manage, and administer your relational databases on Google Cloud Platform with the assistance of Cloud SQL, a database service that is entirely managed by Google. You may connect MySQL, PostgreSQL, or SQL Server to Cloud SQL to manage your databases. You are migrating a MySQL-based application that was previously hosted on-premises to the Google Cloud. Compute Engine and Cloud SQL will be utilised by the application while it is running. You want to move the application's deployment to Google Compute Engine with as little interruption as possible and without causing any of your customers' data to be lost. You want to migrate the application while causing as little change as possible. In addition to this, you need to figure out the cutover technique. What action should you take?
A. 1. Install Cloud VPN to establish a private network connection between the MySQL server that is hosted on-premises and the application that is hosted on Compute Engine. 2. Put a stop to the programme running locally. 3. Generate a mysqldump of the MySQL server that is located on-premises. 4. Transfer the dump to a container in the cloud storage. 5. Bring the dump into Cloud SQL and import it. 6. Modify the application's source code so that queries may be written to both databases and the application's local database can be read from. 7. Launch the application for Google Compute Engine. 8. Put a stop to the programme running locally.
B. 1. Configure a proxy server for both MySQL and Cloud SQL. 2. Generate a mysqldump of the MySQL server that is located on-premises. 3. Place the dump in a container on a cloud storage service. 4. Begin the process of importing the dump into Cloud SQL. 5. Exit the programme that is running locally. 6. Fire up the application for Google Compute Engine.
C. 1. Install Cloud VPN to establish a private network connection between the MySQL server that is hosted on-premises and the application that is hosted on Compute Engine. 2. Put a stop to the programme running locally. 3. Start the application for Google Compute Engine that has been set up to read and write to the MySQL server that is located on-premises. 4. In Cloud SQL, set up the replication settings. 5. Make the necessary adjustments to the configuration of the source database server so that it can accept connections from the Cloud SQL replica. 6. Put the finishing touches on the setup of the Cloud SQL replica. 7. Exit the Google Compute Engine application once the replication process has been finished. 8. Convert the replica of Cloud SQL into a standalone instance. 9. Restart the application using Compute Engine that has been configured to read and write to the standalone instance of Cloud SQL.
D. 1. Exit the application that is running locally. 2. Generate a mysqldump of the MySQL server that is located on-premises. 3. Place the dump in a container on a cloud storage service. 4. Begin the process of importing the dump into Cloud SQL. 5. Commence operation of the application using Google Compute Engine.

Get All 340 Questions and Answer for Google Professional Cloud Architect