Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An AWS Lambda function ingests CSV files from an S3 bucket and then issues SQL statements to an Amazon Redshift data warehouse through the Redshift Data API. You create a new IAM role that includes only s3:GetObject and redshift-data:ExecuteStatement permissions to satisfy least-privilege requirements. What must you do so that the Lambda function can use this role during execution?

  • Add the Lambda service principal (lambda.amazonaws.com) to the role's trust policy and attach the role as the function's execution role.

  • Attach the AWSLambdaBasicExecutionRole managed policy to the role so that Lambda can assume it automatically.

  • Store temporary Redshift credentials in AWS Secrets Manager and reference the secret in the function's environment variables.

  • Add the role's ARN to the Lambda function's resource-based policy with Action sts:AssumeRole.

AWS Certified Data Engineer Associate DEA-C01
Data Security and Governance
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot