Answer-first summary for fast verification
Answer: Close idle connections or restart the instance before beginning the import operation.
When importing a large CSV file into a Cloud SQL for MySQL instance, it's important to ensure that the operation does not time out. Google-recommended practices include managing the instance's connections efficiently. Option A suggests closing idle connections or restarting the instance before beginning the import operation. This is a correct approach because it helps in freeing up resources and ensuring that the import operation has the necessary resources to complete without timing out. Options B and D suggest increasing memory or CPUs, but the question states that sufficient resources are already available, making these options unnecessary. Option C, ensuring the service account has the Storage Admin role, is unrelated to preventing timeouts during the import operation. Therefore, the correct answer is A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you ensure that a large CSV import into a Cloud SQL for MySQL instance with numerous open connections does not time out, following Google-recommended practices, given that memory and CPU resources are sufficient?
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.
No comments yet.