AWS Certified Data Engineer Associate DEA-C01 Practice Question
Your data engineering team runs an AWS Glue Spark job that connects to an Amazon RDS for MySQL database. Credentials are currently hard-coded in the job script. The team must store the credentials securely and have them automatically rotated every 30 days with minimal code changes and operations effort. Which solution meets these requirements?
Keep the credentials in the Glue job's environment variables but rotate them every 30 days by updating the job definition through a CI/CD pipeline that generates a new password.
Create a secret in AWS Secrets Manager for the RDS database, turn on automatic rotation every 30 days, attach an IAM role with secretsmanager:GetSecretValue to the Glue job, and reference the secret in the job's connection.
Encrypt the credentials with AWS KMS, upload them to Amazon S3, schedule an AWS Lambda function to replace the file with a new password every 30 days, and have the Glue job download and decrypt the file at runtime.
Store the credentials as a SecureString in AWS Systems Manager Parameter Store, trigger an Amazon EventBridge rule every 30 days to invoke a custom Lambda function that updates the parameter, and modify the job to read the parameter value.
AWS Secrets Manager natively integrates with Amazon RDS and provides built-in rotation templates. Creating a secret of type Amazon RDS and enabling automatic rotation (AutomaticallyAfterDays=30) lets Secrets Manager call an AWS-provided Lambda function to change the database password and update the secret. The Glue job only needs permission to call secretsmanager:GetSecretValue and to reference the secret in its connection, so no application code changes are required. Parameter Store has no built-in rotation and would need custom automation. S3 and KMS files, or environment-variable updates through a pipeline, require custom logic and ongoing operations, violating the requirement for minimal overhead.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is AWS Secrets Manager and how does it integrate with Amazon RDS?
Open an interactive chat with Bash
What permissions does AWS Glue need to retrieve secrets from AWS Secrets Manager?
Open an interactive chat with Bash
Why is AWS Secrets Manager preferred over Parameter Store or other options for this use case?
Open an interactive chat with Bash
What is AWS Secrets Manager?
Open an interactive chat with Bash
How does secret rotation work in AWS Secrets Manager?
Open an interactive chat with Bash
What IAM permissions are needed for AWS Glue to access Secrets Manager?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Security and Governance
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .