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