Google Cloud Professional Cloud Database Engineer — Question 24

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

Answer options

• A. Close idle connections or restart the instance before beginning the import operation.
• B. Increase the amount of memory allocated to your instance.
• C. Ensure that the service account has the Storage Admin role.
• D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

Correct answer: A

Explanation

The correct answer is A because closing idle connections or restarting the instance helps to ensure that the import operation runs smoothly without being interrupted by other connections. Increasing memory or CPUs (options B and D) may improve performance, but they won't specifically address potential timeouts due to existing connections. Option C is irrelevant to the import process itself.