Amazon Redshift Serverless for Infrequent Analytics

DEA-C01 By islever Editorial Last updated

Automate data processing by using AWS services.

Short answer

B Use Amazon Redshift Serverless to automatically process the analytics workload without managing clusters.

Question

A data engineer uses Amazon Redshift to run resource-intensive analytics processes once every month. Every month, the data engineer creates a new Redshift provisioned cluster. The data engineer deletes the Redshift provisioned cluster after the analytics processes are complete every month. Before the data engineer deletes the cluster each month, the data engineer unloads backup data from the cluster to an Amazon S3 bucket. The data engineer needs a solution to run the monthly analytics processes that does not require the data engineer to manage the infrastructure manually. Which solution will meet these requirements with the LEAST operational overhead?
  1. Use Amazon Step Functions to pause the Redshift cluster when the analytics processes are complete and to resume the cluster to run new processes every month.
  2. Use Amazon Redshift Serverless to automatically process the analytics workload. Correct Answer
  3. Use the AWS CLI to automatically process the analytics workload.
  4. Use AWS CloudFormation templates to automatically process the analytics workload.

Key Takeaways

The core trap is confusing 'serverless' (fully managed, no cluster management) with 'automation' (using CLI or CloudFormation to manage clusters). The key phrase 'does not require... manage the infrastructure manually' points directly to serverless options.

This question evaluates the use of Amazon Redshift Serverless to eliminate manual infrastructure management for intermittent workloads. The correct solution leverages a fully managed service that scales automatically with minimal operational overhead.

Common mistake: Many learners might choose AWS CloudFormation or Step Functions because they automate the *creation* and *deletion* of resources. However, managing these stacks/states still requires operational oversight, whereas Redshift Serverless removes the need to manage the compute layer entirely.

Expert Analysis

Why the Answer Is Correct

Amazon Redshift Serverless is a fully managed option that automatically provisions and manages computing resources based on the workload size. Since the requirement specifies running resource-intensive processes once a month without managing infrastructure, Redshift Serverless is ideal because it eliminates the need to provision, scale, or terminate clusters manually. It charges only for the data processing units (DPUs) consumed during execution, making it cost-effective for infrequent usage.

Why the Other Options Are Wrong

Options A, C, and D all involve managing underlying infrastructure or automation frameworks. Using Step Functions (A) to pause/resume provisioned clusters still requires managing the cluster lifecycle and configuration. Using AWS CLI (C) or CloudFormation (D) automates the creation/deletion process but still requires the engineer to maintain the templates/scripts and handle any failures in the provisioning logic. These options do not meet the 'least operational overhead' criterion compared to a truly serverless experience.

Community Comment Notes

The community consensus strongly supports Option B. As Christina666 noted, 'Fully Managed, Serverless: Redshift Serverless eliminates the need to manually create, manage, or delete clusters.' Felix_G highlighted that other options 'still involve manual tasks like administering CloudFormation stacks,' reinforcing that serverless is the only path to zero cluster management.

Exam Strategy

When you see 'least operational overhead' combined with 'manage infrastructure manually', look for Serverless or Fully Managed services first. Automation tools (CLI, Terraform, CloudFormation) reduce effort but do not eliminate the responsibility of managing the underlying resources.

Frequently Asked Questions

Why isn't CloudFormation the best choice for least overhead?

CloudFormation automates deployment but you still manage the stack, errors, and updates. Redshift Serverless removes the compute management entirely.

Is Redshift Serverless cost-effective for monthly jobs?

Yes, it uses a pay-per-use model for DPUs, so you only pay when the job runs, avoiding costs for idle provisioned clusters.

More DEA-C01 FAQ →

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 6 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 6

  1. Christina666 👍 5 Answered B
    Fully Managed, Serverless: Redshift Serverless eliminates the need to manually create, manage, or delete clusters. It automatically scales resources based on the workload, reducing operational overhead significantly. Cost-Effective for Infrequent Workloads: Since the analytics processes run only once a month, Redshift Serverless's pay-per-use model is ideal for minimizing costs during downtime. Seamless S3 Integration: Redshift Serverless natively integrates with S3 for backup and restore operations, ensuring compatibility with the existing process.
  2. Felix_G 👍 3
    Selected Answer B: Options A, C and D still involve manual tasks like administering CloudFormation stacks, using AWS CLI commands, or configuring Step Function state machines. By leveraging Redshift Serverless, the data engineer avoids all cluster and infrastructure administration effort. This has the least operational overhead to run the monthly
  3. rralucard_ 👍 2 Answered B
    Use Amazon Redshift Serverless. This option allows the data engineer to focus on the analytics processes themselves without worrying about cluster provisioning, scaling, or management. It provides an on-demand, serverless solution that can handle variable workloads and is cost-effective for intermittent and irregular processing needs like those described.
  4. GiorgioGss 👍 2 Answered B
    "does not require to manage the infrastructure manually" = Serverless
  5. 4c78df0 👍 1 Answered B
    B is correct
Show 1 more comment
  1. damaldon 👍 1
    Ans. B

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Amazon Redshift Compound Sort Key Query Optimization

S-grade

Secure Redshift Spectrum Access with VPC Endpoints

S-grade

Athena Federated Query for Multi-Source Iceberg Pipelines

S-grade

Reclaiming Storage in Amazon Redshift Materialized Views

S-grade

Practice All DEA-C01 Questions

Access 100 questions with complete answers and detailed explanations.

View Full DEA-C01 Practice Test →

← Back to DEA-C01 Study Guide