nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #18

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 Goo

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.

Optimizing Database Performance

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

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud SQL for MySQL#Database Import#Connection Management#Performance Tuning
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice