Answer-first summary for fast verification
Answer: Use query editor v2 to run the stored procedure on a schedule.
Option C is CORRECT because using query editor v2 to run the stored procedure on a schedule is the most cost-effective solution. Query editor v2 allows you to create and manage scheduled SQL queries directly within Amazon Redshift, eliminating the need for additional infrastructure or services.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 31/60
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?
A
Create an AWS Lambda function to schedule a cron job to run the stored procedure.
B
Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.
C
Use query editor v2 to run the stored procedure on a schedule.
D
Schedule an AWS Glue Python shell job to run the stored procedure.
No comments yet.