Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 45

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API. Pub/Sub is a serverless, global messaging service that decouples services and ingests high-volume event streams.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 45