nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #26

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #26: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.

Managing and Operating Databases

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?

Options

  • AUse Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call
  • BUse Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the
  • 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.

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud SQL#Data Export#Automation#Scheduled Tasks
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions