AWS Certified Data Engineer – Associate (DEA-C01) — Question 84

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?

Answer options

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

Correct answer: C

Explanation

The correct answer is C because using query editor v2 allows for easy scheduling of stored procedures directly within Amazon Redshift, making it a straightforward and cost-effective solution. Options A and B involve additional services that may incur extra costs and complexity, while option D, although viable, is less efficient compared to the direct scheduling available with query editor v2.