Question 43 of 139
Single answerYou 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?
AUse Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
✓BUse Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
CUse Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
DUse Cloud Composer to execute a select * from table(s) query and export results.
✓
Correct Answer: B
Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.