Q83 — AWS DEA-C01 Ch.1

Question 83 of 100 | ← Chapter 1

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.

Correct Answer: C. Use query editor v2 to run the stored procedure on a schedule.

Explanation

针对这个需求，我们考虑的核心是成本效益。选项A虽然可以实现定时任务，但引入了额外的AWSLambda服务成本。选项B使用EC2SpotInstance虽然可能降低成本，但管理复杂度增加，且不一定比定时执行存储过程更经济。选项D同样引入了AWSGlue服务，增加了成本。选项C，使用Redshift自带的查询编辑器v2来定时执行存储过程，不需要额外服务，因此是最成本效益的选择。所以答案是C。