Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 103 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 103
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

A. Use Cloud Scheduler and Cloud Functions to run the daily export.
B. Create a streaming Datatlow job to export the table.
C. Set up Cloud Composer, and create a task to export the table daily.
D. Run the cron job on a Compute Engine instance to continue the export.

Show Suggested Answer

Suggested Answer: A 🗳️

by pk349 at Dec. 24, 2022, 10:43 p.m.

Comments

Submit Cancel

chelbsik

Highly Voted 1 year, 7 months ago

Selected Answer: A

A is Google recommended couple

upvoted 10 times

...

DPonly

Most Recent 11 months, 1 week ago

Selected Answer: A

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

upvoted 1 times

...

dynamic_dba

1 year, 4 months ago

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

upvoted 3 times

...

zanhsieh

1 year, 5 months ago

Selected Answer: C

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.

upvoted 1 times

...

orbo

1 year, 6 months ago

Selected Answer: B

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.

upvoted 1 times

...

pk349

1 year, 7 months ago

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

upvoted 3 times

...

pk349

1 year, 7 months ago

A: Use Database Migration Service

upvoted 2 times

...

pk349

1 year, 7 months ago

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.

upvoted 1 times

...