Q57 — AWS DEA-C01 Ch.1

Question 57 of 100 | ← Chapter 1

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?

• A. 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.
• B. Use Amazon Redshift Serverless to automatically process the analytics workload. ✓
• C. Use the AWS CLI to automatically process the analytics workload.
• D. Use AWS CloudFormation templates to automatically process the analytics workload.

Correct Answer: B. Use Amazon Redshift Serverless to automatically process the analytics workload.

Explanation

对于数据工程师需要每月运行资源密集型分析过程且希望减少基础设施手动管理负担的场景，选择B选项AmazonRedshiftServerless最为合适。AmazonRedshiftServerless允许用户根据查询需求自动扩展和缩减资源，无需手动管理集群的创建、配置和删除。这样，数据工程师可以在不管理基础设施的情况下运行分析过程，从而减少了操作开销。其他选项如使用AmazonStepFunctions、AWSCLI或AWSCloudFormation都需要更多的手动干预或配置，不符合题目中“LEASToperationaloverhead”的要求。