ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
artworkad
Highly Voted 10 months, 2 weeks 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 9 months, 2 weeks 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
9 months, 3 weeks ago
Selected Answer: B
given that the table is not mission-critical and requires the "MOST cost-effective way."
upvoted 1 times
...
salayea28
10 months, 1 week 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
10 months, 2 weeks ago
Selected Answer: C
I think all options other than using the query editor will incur additional costs.
upvoted 2 times
...
tgv
10 months, 2 weeks 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
10 months, 3 weeks ago
A. Create an AWS Lambda function to schedule a cron job to run the stored procedure.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago