Topic 1 Question 101
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?
Create an AWS Lambda function to schedule a cron job to run the stored procedure.
Schedule and run the stored procedure by using the Amazon Redshift Data API in an Amazon EC2 Spot Instance.
Use query editor v2 to run the stored procedure on a schedule.
Schedule an AWS Glue Python shell job to run the stored procedure.
ユーザの投票
コメント(7)
- 正解だと思う選択肢: C
This can be achieved with query editor v2 (https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-schedule-query.html)
👍 7artworkad2024/06/15 - 正解だと思う選択肢: C
I go with C because it runs the query within the Redshift instance, B may not be appropriate because it involves other services on top of the Redshift instance and there is movement of data across the services.
👍 3andrologin2024/07/17 - 正解だと思う選択肢: A
AWS Lambda, combined with Amazon CloudWatch Events for scheduling, provides a low-cost, serverless, and reliable way to automatically run the stored procedure daily.
👍 2tgv2024/06/15
シャッフルモード