ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by fredcaram at Dec. 20, 2022, 11:04 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dynamic_dba
7 months, 2 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
10 months ago
C. for import service account needs storage.buckets.get & storage.objects.get
upvoted 1 times
...
pk349
10 months, 1 week ago
A: Close idle connections or restart the instance before beginning the import operation.
upvoted 2 times
...
GCP72
10 months, 1 week 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
10 months, 1 week 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
10 months, 1 week 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
10 months, 1 week ago
Selected Answer: A
Close idle connections or restart the instance before beginning the import operation.
upvoted 3 times
...
fredcaram
10 months, 1 week ago
Selected Answer: A
It should be A given the amount of opened connections
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago