AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ44

Data Operations and Support

A data engineer has completed testing an Amazon Redshift stored procedure that processes and inserts data into a non-mission-critical table. The engineer needs the stored procedure to run automatically each day.

Which solution meets this requirement in the MOST cost-effective manner?

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

Amazon Redshift Query Editor v2 can schedule a SQL statement to run automatically at specified intervals or times. Scheduling a CALL statement for the stored procedure directly provides daily execution while avoiding the additional compute and operational cost of an EC2 instance, Lambda-based scheduling infrastructure, or an AWS Glue job.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!