Explanation:
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.
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.