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

Ensure the application connects using an IAM authentication token.

Enable SSL/TLS for connections to the RDS instance.

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?

Enable Enhanced Monitoring for the RDS instance and configure CloudWatch alarms.

Use AWS CloudWatch metrics and 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?

Create one or more read replicas for the RDS instance.

Configure Multi-AZ deployment for the RDS instance.

Use Amazon ElastiCache in front of the database.

Increase the instance size of the primary database.

A developer wants to automate the creation of database schemas and tables on an Amazon RDS PostgreSQL instance after the instance is launched. Which approach is most appropriate?

Use AWS CloudFormation with a custom resource that executes the schema creation script.

Manually connect to the database using a SQL client and run the schema creation scripts.

Use AWS Lambda to execute schema creation scripts after the RDS instance is available.

Write an application script to deploy the schema.

Your organization needs to migrate a critical on-premises Oracle database to Amazon RDS while ensuring the database remains highly available. Which configuration should you choose?

Use AWS Database Migration Service (DMS) to migrate the database to RDS Oracle with Multi-AZ enabled.

Deploy Amazon RDS Oracle in a Multi-AZ configuration.

Use Amazon Aurora as a replacement for the Oracle database.

Migrate the database to an Amazon EC2 instance and set up replication.

How can a developer ensure that data stored in an Amazon RDS database is encrypted at rest?

Enable encryption when creating the RDS instance.

Use AWS Key Management Service (KMS) to encrypt specific database tables.

Manually encrypt data before storing it in RDS.

Use RDS Reserved Instances for encryption.

How can a Solutions Architect ensure high availability for an Amazon RDS database?

Use Read Replicas in another Region.

Use Elastic Load Balancing in front of RDS.

Set up Auto Scaling for RDS instances.

How can a Solutions Architect improve query performance for a heavily used Amazon RDS database?

Create Read Replicas and distribute queries.

Increase instance size and enable Multi-AZ.

How can a DevOps Engineer minimize downtime during an RDS maintenance window?

Schedule maintenance during off-peak hours.

A DevOps team is building a CI/CD pipeline for an application that connects to an RDS database. How should the pipeline securely store database credentials?

Use AWS Systems Manager Parameter Store with encryption.

Store the credentials in plaintext within the CI/CD pipeline configuration.

Use IAM Roles for accessing the database directly.

Pass the credentials as environment variables from the build server.

What is the best way to monitor query performance in Amazon RDS?

Use Amazon RDS Performance Insights.

Create a custom monitoring script.

A development team needs to replicate the production Amazon RDS database for testing purposes. The testing environment should contain the same data but not affect the performance of the production database. What is the BEST solution?

Restore the production database snapshot to a new RDS instance.

Create a read replica of the production database.

Export the production database to Amazon S3 and import it into a new RDS instance.

Use AWS Database Migration Service (DMS) to migrate data to a new instance.

A developer is running an Amazon RDS MySQL instance for a short-term development project. The database is only used during business hours, and the team wants to reduce costs during downtime. What is the MOST cost-effective solution?

Stop the database instance during non-business hours.

Use a smaller instance class for the RDS database.

Enable Multi-AZ deployment to improve availability.

Move the database to an on-premises server

A company is using Amazon RDS for its database backend and has a requirement to maintain a daily snapshot backup for disaster recovery. The company also wants to minimize manual intervention and ensure snapshots are deleted after 30 days. How can this requirement be achieved?

Use AWS Backup to automate the creation and retention of daily RDS snapshots.

Manually create a snapshot daily and set a calendar reminder to delete older snapshots.

Enable RDS automatic backups and use a script to delete old snapshots.

Use an AWS Lambda function triggered by an EventBridge rule to manage snapshots.

A global e-commerce platform uses an Amazon RDS MySQL database with Multi-AZ enabled. The platform experiences high read latency during peak sales events. The team is tasked with improving performance while maintaining high availability and scalability. Which approach meets these requirements?

Add multiple RDS Read Replicas and distribute read traffic across them.

Enable Amazon Aurora and migrate the database.

Increase the instance class of the primary RDS instance.

Enable RDS storage auto-scaling.

You are developing an application that uses Amazon RDS for MySQL. Your application requires occasional reporting queries that could impact the performance of the main database. To offload read traffic without compromising the high availability of your database, what is the best solution?

Deploy a read replica in a different AZ from the primary database.

Deploy a Multi-AZ RDS instance and configure query caching in the application.

Use Amazon DynamoDB as a replica for the RDS instance.

Use AWS Lambda to perform reporting queries separately.

A web application is deployed in multiple AWS Regions, and its backend uses Amazon RDS PostgreSQL with a Multi-AZ configuration in the primary Region. To reduce latency for users in other Regions, you need to replicate the database to these Regions for read operations. What should you do?

Use Amazon RDS read replicas in the target Regions.

Set up Amazon Aurora Global Database.

Use AWS Database Migration Service (DMS) to replicate the database.

Deploy a Multi-AZ RDS instance in each Region and synchronize manually.

Your application runs on Amazon EC2 and connects to an Amazon RDS for MySQL instance. You notice frequent connection timeouts during peak traffic. You need to optimize the database connection management to reduce the connection overhead. Which of the following solutions will help optimize the database connection management for the application?

Use an Amazon RDS Proxy to pool and share connections.

Increase the instance size of the Amazon RDS MySQL instance.

Implement caching with Amazon ElastiCache.

Enable Multi-AZ deployment for Amazon RDS.

You are designing a multi-tier web application. The backend tier needs a managed relational database with high availability and automated backups. The application is sensitive to data loss, so a disaster recovery mechanism is essential. Which Amazon RDS configuration provides high availability and disaster recovery for this application?

Deploy Amazon RDS in a Multi-AZ configuration.

Launch a single Amazon RDS instance with automatic backups enabled.

Use Amazon RDS Read Replicas across regions.

Configure Amazon RDS with cross-region snapshots.

You manage an application with an Amazon RDS PostgreSQL database. Your CI/CD pipeline requires the database schema to be updated frequently as part of new deployments. To ensure minimal downtime during schema migrations, you need an automated and reliable process. Which approach should you implement to perform schema migrations with minimal downtime?

Use a deployment framework like AWS CodePipeline with a step for schema migrations.

Manually apply schema changes during off-peak hours.

Use AWS Database Migration Service (AWS DMS) for every schema update.

Create a Read Replica, update the schema on it, and then promote it to the primary database.

Your company is migrating an on-premises PostgreSQL database to Amazon RDS. The migration must ensure minimal downtime and maintain data consistency during the cutover. Which approach should you use?

Use the AWS Database Migration Service (DMS) with continuous replication. *

Export the on-premises database to an S3 bucket, then import it into Amazon RDS.

Manually copy data over SSH and insert it into the RDS database.

Use RDS snapshots to import the on-premises database.

You launched an Amazon RDS instance without enabling encryption, and now you need to encrypt the database. How should you proceed?

Create a snapshot of the database, copy it with encryption enabled, and restore it to a new RDS instance. *

Enable encryption on the existing RDS instance.

Use AWS Key Management Service (KMS) to encrypt the existing RDS instance.

Create a new RDS instance with encryption enabled and manually migrate data.

You have a high-traffic e-commerce application running on Amazon RDS MySQL. The application is experiencing slow performance due to high write throughput. What is the best way to address this issue?

Use Amazon Aurora MySQL instead of RDS MySQL.*

Add a read replica to offload read traffic.

Increase the instance size of the RDS database.

Create an ElastiCache layer to cache writes.

Your RDS PostgreSQL database is experiencing performance issues due to long-running queries. What is the most effective way to monitor and optimize these queries?

Use the RDS Performance Insights dashboard to identify slow queries. *

Enable CloudWatch Logs and monitor database connections.

Configure an RDS event notification for slow queries.

Enable Multi-AZ deployment to reduce latency.

Your company runs a mission-critical RDS PostgreSQL database that must have automatic failover to minimize downtime in case of hardware failure. How should you configure the database?

Set up a read replica in another availability zone and promote it when needed.

Use AWS Backup to create frequent backups for disaster recovery.

Deploy the RDS instance in a single availability zone and monitor with CloudWatch alarms.

Your company is using RDS MySQL and is experiencing scalability issues during peak traffic hours. You want to migrate to Aurora MySQL to leverage its scalability features. What is the best way to perform this migration?

Take a snapshot of the RDS MySQL instance and restore it as an Aurora MySQL cluster. *

Export the RDS database to an S3 bucket and import it into an Aurora MySQL cluster.

Use the AWS Database Migration Service (DMS) to migrate data to Aurora MySQL.

Create a read replica of the RDS MySQL database and promote it to an Aurora MySQL instance.

Your team is running Amazon RDS for a production application and wants to minimize the impact of maintenance updates. How should you configure the maintenance window?

Select a maintenance window during low-traffic periods for the application. *

Choose a time during peak business hours to detect issues quickly.

Disable automatic maintenance updates for the RDS instance.

Configure manual maintenance updates to avoid downtime.

You are managing a critical RDS MySQL database that requires both high availability and disaster recovery across multiple regions. What is the best configuration to meet these requirements?

Enable Multi-AZ deployment for high availability within the primary region. *

Set up cross-region read replicas in another AWS region. *

Use AWS Backup to create daily backups and copy them to another region.

Deploy the database in a single availability zone and set up automated backups.

You are running an RDS PostgreSQL database for a write-intensive application that is approaching its performance limits. How can you scale the database effectively?

Upgrade to a larger instance class with more CPU and memory. *

Shard the database into multiple RDS instances based on application logic. *

Enable read replicas to offload read traffic from the primary database.

Use partitioning at the application level to distribute writes across tables.

A development team is testing a new application using an RDS MySQL database. The team wants to minimize database costs while testing and expects downtime during off-hours. Which configuration is most cost-effective?

Use RDS Aurora Serverless and configure the database to scale to zero capacity during off-hours.

Use an RDS Multi-AZ instance with a smaller instance class.

Use an RDS Single-AZ instance with storage auto-scaling enabled.

Schedule manual snapshots and delete the RDS instance after testing each day.

A global e-commerce company uses RDS PostgreSQL in multiple Regions to serve customers. The company wants to ensure data consistency between Regions. What is the best solution?

Configure logical replication between RDS PostgreSQL instances in different Regions.

Set up Multi-AZ in each Region to replicate data.

Use AWS DMS to continuously replicate data between Regions.

Use Amazon S3 to transfer data between Regions and reload it into RDS.

Your team manages a highly critical RDS instance configured with Multi-AZ. You want to test the failover process to validate application behavior. How can you perform this test with minimal disruption?

Use the "Force Failover" API action to initiate failover.

Manually reboot the RDS instance using the AWS Management Console.

Stop the primary instance and monitor failover.

Simulate failure by deleting the primary instance's subnet.

A company needs to migrate its RDS MySQL instance to a new AWS Region with minimal downtime. What is the best migration approach?

Create a cross-Region Read Replica and promote it after synchronization.

Take a snapshot of the database and restore it in the new Region.

Use AWS DMS in full-load mode to replicate the database.

Enable Multi-AZ and switch to the secondary instance in the new Region.

A developer observes frequent connection timeouts when an application interacts with an RDS PostgreSQL database during peak traffic. How can this issue be mitigated?

Use Amazon RDS Proxy to manage database connections.

Increase the max_connections parameter in the RDS parameter group.

Scale the database vertically to a larger instance size.

Implement read replicas to distribute traffic.

A compliance audit revealed that sensitive data in an RDS MySQL instance is not encrypted at rest. How can you encrypt the data with minimal disruption?

Take a snapshot, create an encrypted copy, and restore a new instance from the encrypted snapshot.

Enable encryption on the existing RDS instance.

Modify the RDS instance and select the encryption option.

Use AWS KMS to encrypt the existing instance in place.

Your team schedules maintenance windows for an RDS database. How can you ensure the database is automatically updated to the latest minor version?

Enable "Auto Minor Version Upgrade" for the RDS instance.

Manually apply updates during the maintenance window.

Configure an AWS Lambda function to apply updates.

Use AWS Systems Manager Patch Manager for RDS.

A developer needs to monitor query performance on an RDS MySQL instance. Which feature should they use to analyze slow queries?

Use the Performance Insights feature.

Enable Amazon CloudWatch Metrics.

Configure AWS CloudTrail to monitor database queries.

Enable query logging in the MySQL configuration.

A web application experiences occasional spikes in traffic, causing the RDS instance to run out of storage. How can this issue be mitigated without manual intervention?

Enable storage auto-scaling for the RDS instance.

Monitor storage usage and manually increase storage during spikes.

Configure a read replica to handle additional load.

Scale up the instance to a larger size.

AOS Tema 4 RDS 2024/23

Authored by Marcela Castro León

Architecture

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

48 questions

Show all answers

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

MULTIPLE SELECT QUESTION

3 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

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.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Acoustics in Buildings Quiz

Quiz

•

University

45 questions

Materials Science Quiz

Quiz

•

University

45 questions

Urban Housing

Quiz

•

University

50 questions

Professional Practice

Quiz

•

University

52 questions

Structural Fundamentals 1

Quiz

•

University

50 questions

Building Laws Preboard 2 of 2

Quiz

•

KG - Professional Dev...

50 questions

KUIZ RBT PDPR 3E

Quiz

•

2nd Grade - University

44 questions

quiz

Quiz

•

4th Grade - University

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Architecture

20 questions

Disney Trivia

Quiz

•

University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

14 questions

Ch.3_TEACHER-led

Quiz

•

University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University