AmazonAmazon
DEA-C01 · Question #111
DEA-C01 Question #111: Real Exam Question with Answer & Explanation
The correct answer is C: Use query editor v2 to run the stored procedure on a schedule.. https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-schedule-query.html
Data Operations and Support
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.
Explanation
https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-schedule-query.html
Topics
#Amazon Redshift#Stored Procedures#Scheduling#Cost Optimization
Community Discussion
No community discussion yet for this question.