Google Professional Cloud Database Engineer Exam - Topic 10 Question 80 Discussion

Question

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

Lashaunda · Accepted Answer

B) Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

Lashaunda · Answer

A) Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

Lashaunda · Answer

C) Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

Lashaunda · Answer

D) Use Cloud Composer to execute a select * from table(s) query and export results.