DEA-C01 · Question #111
A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored…
The correct answer is C. Use query editor v2 to run the stored procedure on a schedule. Amazon Redshift Query Editor v2 includes a built-in scheduling feature that allows you to run SQL queries and stored procedures on a defined schedule (e.g., daily) directly within the console at no extra cost. This requires zero additional services. Option A (Lambda + cron) and…
Question
A data engineer finished testing an Amazon Redshift stored procedure that processes and inserts data into a table that is not mission critical. The engineer wants to automatically run the stored procedure on a daily basis. Which solution will meet this requirement in the MOST cost-effective way?
Options
- ACreate an AWS Lambda function to schedule a cron job to run the stored procedure.
- BSchedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon
- CUse query editor v2 to run the stored procedure on a schedule.
- DSchedule an AWS Glue Python shell job to run the stored procedure.
How the community answered
(65 responses)- A3% (2)
- B6% (4)
- C83% (54)
- D8% (5)
Explanation
Amazon Redshift Query Editor v2 includes a built-in scheduling feature that allows you to run SQL queries and stored procedures on a defined schedule (e.g., daily) directly within the console at no extra cost. This requires zero additional services. Option A (Lambda + cron) and Option D (Glue Python shell job) both introduce extra services with their own execution costs and development overhead. Option B (Redshift Data API) can schedule queries but requires additional integration work (e.g., EventBridge + Lambda), adding complexity and cost for a non-mission-critical task.
Topics
Community Discussion
No community discussion yet for this question.