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.