ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 23 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 23
Topic #: 1
[All Professional Cloud Database Engineer Questions]

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?

  • A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
  • B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
  • C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by GCP72 at Dec. 24, 2022, 8:23 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
PKookNN
9 months, 2 weeks ago
Selected Answer: C
C is simple and works
upvoted 1 times
...
dynamic_dba
1 year, 7 months ago
C. The only way to minimize performance impact of running an export on a Cloud SQL instance is to use a serverless export. The fact that no data synchronization is needed since it’s a one off eliminates every option apart from C.
upvoted 3 times
...
Nirca
1 year, 8 months ago
Selected Answer: C
C looks simple and ok.
upvoted 1 times
...
chelbsik
1 year, 10 months ago
Selected Answer: C
C - serverless export https://cloud.google.com/sql/docs/mysql/import-export#serverless
upvoted 1 times
...
pk349
1 year, 10 months ago
C: Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
upvoted 1 times
...
GCP72
1 year, 10 months ago
Selected Answer: C
C is the correct answer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago