Exam Professional Cloud Database Engineer topic 1 question 103 discussion

A is Google recommended couple

https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

A. Minimize cost and operational overhead eliminates D. Cloud Composer is a workflow orchestration service for managing workflow pipelines that span across clouds and on premises data centers. Eliminate C. Dataflow processes data. Eliminate B. A is the best answer. https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

C A: Cloud Scheduler and Cloud Functions can't run on the on-premises MySQL database. B: Dataflow is mostly good for real time job. Again, need special tweaking to access the on-premises DB. C: Best answer. Composer deals with various kinds of inputs. Also handle retry / HA for free. D: Run cron job on a GCE instance then we have to maintain GCE instance stability.

The correct answer is "Create a streaming Datatlow job to export the table" because it is the most cost-effective and efficient solution. A streaming Datatlow job will allow you to export the table in real time, without having to manually run a cron job. This will save you time and money, and it will also ensure that the data is always up to date.

Please ignore last two submits: A: Use Cloud Scheduler *** and Cloud Functions to run the daily export.

A: Use Database Migration Service

AUse Database Migration Service *** to connect to your on-premises database, and choose continuous replication. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.