A data engineer runs resource-heavy analytics in Amazon Redshift once per month. Each month the engineer creates a provisioned Redshift cluster, runs the jobs, unloads backups to S3, and then deletes the cluster. The engineer wants a solution that removes the need to manage infrastructure manually and minimizes operational overhead. Which option best meets this requirement?

Amazon Redshift Serverless is the best option because it automatically provisions and scales compute capacity, eliminating the need for manual infrastructure management. This directly addresses the requirement to minimize operational overhead for a monthly, resource-heavy workload. The engineer no longer needs to create, manage, or delete clusters. Using Amazon Step Functions to pause and resume a provisioned Redshift cluster still involves managing a provisioned cluster and its lifecycle, which doesn't fully remove manual infrastructure management. While AWS CLI and AWS CloudFormation can automate the creation and deletion of provisioned clusters, they still require defining and managing the infrastructure explicitly. Redshift Serverless handles this implicitly, making it the most hands-off solution.