Professional-Cloud-Database-Engineer Exam Dumps | You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for

<< Prev Question Next Question >>

Question 13/41

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?

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.

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

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

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

Question 13/41

LEAVE A REPLY

Download PDF File