Amazon
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 proce
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
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.
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Amazon Redshift#Stored Procedures#Scheduling#Cost Optimization