PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #18
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #18: Real Exam Question with Answer & Explanation
The correct answer is A: Close idle connections or restart the instance before beginning the import operation.. CPU and memory are OK so that elimiates B and D. C is nonsense which leaves A. This is supported by Google’s own documention (read recommended practices) which says close unused operations and re-start the instance. This is the best way to ensure maximum resources for the import
Question
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?
Options
- AClose idle connections or restart the instance before beginning the import operation.
- BIncrease the amount of memory allocated to your instance.
- CEnsure that the service account has the Storage Admin role.
- DIncrease the number of CPUs for the instance to ensure that it can handle the additional import
Explanation
CPU and memory are OK so that elimiates B and D. C is nonsense which leaves A. This is supported by Google’s own documention (read recommended practices) which says close unused operations and re-start the instance. This is the best way to ensure maximum resources for the import operation. https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
Topics
Community Discussion
No community discussion yet for this question.