Topic 1 Question 23
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: C
C is the correct answer
👍 1GCP722022/12/23 C: Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
👍 1pk3492022/12/25- 正解だと思う選択肢: C
C - serverless export https://cloud.google.com/sql/docs/mysql/import-export#serverless
👍 1chelbsik2022/12/27
シャッフルモード