Exam Professional Cloud Database Engineer topic 1 question 37 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 37
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by fredcaram at Dec. 20, 2022, 11:04 p.m.

Comments

Submit Cancel

dynamic_dba

9 months, 1 week ago

A. 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

upvoted 2 times

...

SVGoogle89

11 months, 3 weeks ago

C. for import service account needs storage.buckets.get & storage.objects.get

upvoted 1 times

...

pk349

11 months, 3 weeks ago

A: Close idle connections or restart the instance before beginning the import operation.

upvoted 2 times

...

GCP72

11 months, 3 weeks ago

Selected Answer: 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

upvoted 3 times

...

chelbsik

11 months, 3 weeks ago

Selected Answer: A

Eliminate B and D because 'You checked memory and CPU usage, and sufficient resources are available.' Eliminate C because it makes no sense.

upvoted 1 times

chelbsik

11 months, 3 weeks ago

To elaborate on C - it's required for the export into Cloud Storage, which is not the case https://cloud.google.com/sql/docs/postgres/import-export/import-export-csv#required_roles_and_permissions_for_exporting

upvoted 2 times

...

range9005

12 months ago

Selected Answer: A

Close idle connections or restart the instance before beginning the import operation.

upvoted 3 times

...

fredcaram

12 months ago

Selected Answer: A

It should be A given the amount of opened connections

upvoted 3 times

...