After validating an Amazon Redshift stored procedure that inserts data into a noncritical table, the engineer needs it to run automatically every day. What is the most cost-effective way to accomplish this?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Query Editor v2 to run the stored procedure on a schedule..
Why this is the answer
Query Editor v2 offers a built-in scheduling feature for SQL queries and stored procedures directly within Redshift, making it the most cost-effective and straightforward solution for this use case. It eliminates the need for additional AWS services or custom code. Creating an AWS Lambda function to schedule a cron job is more complex and incurs Lambda execution costs. Scheduling via the Amazon Redshift Data API in an Amazon EC2 Spot Instance introduces EC2 costs, management overhead, and potential interruptions if the Spot Instance is reclaimed. Scheduling an AWS Glue Python shell job also adds Glue service costs and requires writing Python code for execution, which is an unnecessary layer for a simple stored procedure schedule.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed