AOS Tema 4 RDS 2024/23

Your company hosts a critical application using Amazon RDS MySQL in the us-east-1 region. The application needs to maintain availability during a regional outage, and the database must remain highly consistent. How can you ensure the database is resilient to regional failures?

• Set up a cross-region read replica in another AWS region, such as us-west-2.
• Create a Multi-AZ deployment in the us-east-1 region.
• Configure an S3 bucket in another region to store daily RDS snapshots.
• Use Amazon Aurora Global Database to replicate data across regions.

A company runs a critical application with an Amazon RDS MySQL database. The database must remain available during maintenance or hardware failures. How should the database be configured to meet this requirement?

• Enable Multi-AZ deployment for the RDS instance.
• Create a read replica in another AWS Region.
• Use AWS Backup to take snapshots of the database.
• Deploy the database in a single Availability Zone with automated backups.

You are building a serverless application using AWS Lambda and Amazon RDS. Your Lambda function needs to query the RDS database. What is the most secure way to allow the Lambda function to access the database?

• Store database credentials in Lambda environment variables.
• Use AWS Secrets Manager to store and retrieve the credentials.
• Hardcode the database credentials in the Lambda code.
• Use an IAM role for Lambda to access the RDS database directly.

Your organization is migrating an on-premises database to Amazon RDS PostgreSQL. The database must remain accessible during the migration process, with minimal downtime. Which solution should you implement?

• Create a snapshot of the on-premises database and import it into Amazon RDS.
• Use AWS DataSync to migrate the database directly to Amazon RDS.
• Use AWS Database Migration Service (DMS) with change data capture (CDC) enabled to replicate ongoing changes to Amazon RDS.
• Migrate the database manually by exporting the data and importing it into Amazon RDS.

A developer is tasked with storing sensitive application credentials in an RDS MySQL database. What AWS service or feature should be used to ensure the credentials are encrypted at rest?

• Enable encryption for the Amazon RDS instance at the time of creation.
• Store the credentials in AWS Secrets Manager and access them securely from the application.
• Use client-side encryption to encrypt the credentials before storing them in the database.
• Encrypt the credentials in transit using SSL.

A company uses an Amazon RDS instance for its production database. The team needs automated backups and the ability to restore the database to any point within the past 7 days. What is the best configuration to meet this requirement?

• Enable automated backups and set the retention period to 7 days.
• Enable automated backups with point-in-time recovery (PITR).
• Take manual snapshots daily.
• Use AWS Backup to schedule daily snapshots.

A company runs a multi-AZ Amazon RDS MySQL instance for a production workload. They need to ensure the database can handle failover automatically. What configuration is required?

• Ensure the RDS instance is configured for Multi-AZ deployment.
• Configure an RDS read replica in a different availability zone.
• Use AWS Elastic Load Balancing in front of the RDS instance.
• Set up Route 53 with health checks pointing to the RDS instance.

An application needs to connect to an Amazon RDS PostgreSQL database. Which of the following ensures secure communication between the application and the database?

• Enable SSL/TLS for connections to the RDS instance.
• Ensure the application connects using an IAM authentication token.
• Use a VPN to connect to the RDS instance.
• Encrypt the database credentials using AWS KMS before using them.

A DevOps team wants to monitor the performance of an RDS instance and set up alerts for high CPU usage. Which AWS services should they use?

• Use AWS CloudWatch metrics and alarms.
• Enable Enhanced Monitoring for the RDS instance and configure CloudWatch alarms.
• Deploy a custom monitoring script on the RDS instance.
• Use AWS Trusted Advisor for performance alerts.

A business needs to ensure its Amazon RDS MySQL database can scale for increased read operations without affecting the primary database’s performance. What should they do?

• Configure Multi-AZ deployment for the RDS instance.
• Create one or more read replicas for the RDS instance.
• Use Amazon ElastiCache in front of the database.
• Increase the instance size of the primary database.