Topic 1 Question 37

Professional Cloud Database Engineer

Topic 1 Question 37
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?
- Close idle connections or restart the instance before beginning the import operation.
- Increase the amount of memory allocated to your instance.
- Ensure that the service account has the Storage Admin role.
- Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
ユーザの投票
コメント(7)
- 正解だと思う選択肢: A
  It should be A given the amount of opened connections
  
  👍 3
  fredcaram2022/12/20
- 正解だと思う選択肢: A
  Close idle connections or restart the instance before beginning the import operation.
  
  👍 3
  range90052022/12/21
- 正解だと思う選択肢: A
  The import operation is taking too long. Too many active connections can interfere with import operations. Close unused operations. Check the CPU and memory usage of your Cloud SQL instance to make sure there are plenty of resources available. The best way to ensure maximum resources for the import is to restart the instance before beginning the operation.
  
  A restart:
  
  Closes all connections. Ends any tasks that may be consuming resources https://cloud.google.com/sql/docs/mysql/import-export
  
  👍 3
  GCP722022/12/25
シャッフルモード

ユーザの投票

コメント(7)