exam questions

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 83 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 83
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

  • A. Create a VM in Compute Engine, and run a cron job.
  • B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
  • C. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
  • D. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Pime13
5 months, 3 weeks ago
Selected Answer: C
Scheduler + CF
upvoted 1 times
...
isribalaji
10 months ago
Selected Answer: C
Minimal Cost Approach: 1. Put the python script on the Cloud Function 2. Schedule weekly trigger using Cloud Scheduler Compute Engine and Cloud Composer would increase the cost and making it complex
upvoted 4 times
...
dynamic_dba
1 year, 1 month ago
C. Need to automate and minimize costs/overhead. Eliminate A. From Google’s documentation, “Cloud Composer is a fully managed workflow orchestration service, enabling you to create, schedule, monitor, and manage workflow pipelines that span across clouds and on-premises data centers.”. We don’t need Cloud Composer. Eliminate B. To have something run at a specific time on a specific schedule, you need to use Cloud Scheduler (which has cron like scheduling). Cloud Tasks doesn’t do that. Eliminate D. That leaves C.
upvoted 3 times
...
zanhsieh
1 year, 2 months ago
Selected Answer: C
C Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured. Reference: https://cloud.google.com/tasks/docs/comp-tasks-sched
upvoted 1 times
...
chelbsik
1 year, 4 months ago
Selected Answer: C
I'll go for C
upvoted 2 times
...
pk349
1 year, 4 months ago
C: Create a Cloud Function, and call the Cloud Function using Cloud *** Scheduler. Compare Cloud Tasks vs. Cloud Scheduler Both Cloud Tasks and Cloud Scheduler can be used to initiate actions outside of the immediate context. But they have significant differences in functionality and usage. This page helps you understand the differences between them.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago