A data engineer must orchestrate a series of Amazon Athena queries that will run every day. Each query can run for more than 15 minutes. Which combination of steps will meet these requirements MOST co

An AWS Lambda function provides a cost-effective, serverless way to initiate an Amazon Athena query using the Boto3 start_query_execution API call, which can then be orchestrated and monitored by an AWS Step Functions workflow.

AWS Step Functions is a serverless orchestration service that can manage long-running workflows, including starting and polling the status of Amazon Athena queries for durations exceeding 15 minutes, with costs based on state transitions, making it highly cost-effective for waiting.

AWS Glue Python shell jobs involve provisioned compute resources, which can be more expensive than Step Functions' state-transition model for simple orchestration, especially when waiting for external tasks to complete.

Using a sleep timer in a Glue Python shell script is inefficient and not cost-effective, as the job consumes compute resources while idly waiting.

Amazon Managed Workflows for Apache Airflow (MWAA) provides robust orchestration but generally has a higher baseline cost compared to AWS Step Functions for simpler, daily scheduled tasks.