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

10 months, 3 weeks 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

1 year, 1 month ago

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

upvoted 1 times

...

pk349

1 year, 1 month ago

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

upvoted 2 times

...

GCP72

1 year, 1 month 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

1 year, 1 month 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

1 year, 1 month 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

1 year, 1 month ago

Selected Answer: A

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

upvoted 3 times

...

fredcaram

1 year, 1 month ago

Selected Answer: A

It should be A given the amount of opened connections

upvoted 3 times

...