Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 101 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 101
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by lalitjhawar at June 14, 2024, 11:23 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

artworkad

Highly Voted 1 year ago

Selected Answer: C

This can be achieved with query editor v2 (https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-schedule-query.html)

upvoted 7 times

...

andrologin

Most Recent 11 months, 1 week ago

Selected Answer: 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.

upvoted 4 times

...

4d716d6

11 months, 2 weeks ago

Selected Answer: B

given that the table is not mission-critical and requires the "MOST cost-effective way."

upvoted 1 times

...

salayea28

12 months ago

Selected Answer: B

I am going with option B, given that the table is not mission-critical and requires the "MOST cost-effective way." AWS Spot Instances are Amazon EC2 instances that allow you to utilize spare EC2 capacity at a significantly lower cost than On-Demand instances. These instances are ideal for flexible workloads that can tolerate interruptions, such as batch processing, data analysis, and background processing jobs.

upvoted 1 times

...

GHill1982

1 year ago

Selected Answer: C

I think all options other than using the query editor will incur additional costs.

upvoted 2 times

...

tgv

1 year ago

Selected Answer: 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.

upvoted 3 times

...

lalitjhawar

1 year ago

A. Create an AWS Lambda function to schedule a cron job to run the stored procedure.

upvoted 1 times

...