Font size
S
M
L
XL
WorksheetsAOS Tema 4 RDS 2024/23
Total questions: 48
Worksheet time: 2hrs 24mins
Name
Class
Date
1.
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?
a)
Set up a cross-region read replica in another AWS region, such as us-west-2.
b)
Create a Multi-AZ deployment in the us-east-1 region.
c)
Configure an S3 bucket in another region to store daily RDS snapshots.
d)
Use Amazon Aurora Global Database to replicate data across regions.
2.
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?
a)
Enable Multi-AZ deployment for the RDS instance.
b)
Create a read replica in another AWS Region.
c)
Use AWS Backup to take snapshots of the database.
d)
Deploy the database in a single Availability Zone with automated backups.
3.
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?
a)
Store database credentials in Lambda environment variables.
b)
Use AWS Secrets Manager to store and retrieve the credentials.
c)
Hardcode the database credentials in the Lambda code.
d)
Use an IAM role for Lambda to access the RDS database directly.
4.
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?
a)
Create a snapshot of the on-premises database and import it into Amazon RDS.
b)
Use AWS DataSync to migrate the database directly to Amazon RDS.
c)
Use AWS Database Migration Service (DMS) with change data capture (CDC) enabled to replicate ongoing changes to Amazon RDS.
d)
Migrate the database manually by exporting the data and importing it into Amazon RDS.
5.
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?
a)
Enable encryption for the Amazon RDS instance at the time of creation.
b)
Store the credentials in AWS Secrets Manager and access them securely from the application.
c)
Use client-side encryption to encrypt the credentials before storing them in the database.
d)
Encrypt the credentials in transit using SSL.
6.
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?
a)
Enable automated backups and set the retention period to 7 days.
b)
Enable automated backups with point-in-time recovery (PITR).
c)
Take manual snapshots daily.
d)
Use AWS Backup to schedule daily snapshots.
7.
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?
a)
Ensure the RDS instance is configured for Multi-AZ deployment.
b)
Configure an RDS read replica in a different availability zone.
c)
Use AWS Elastic Load Balancing in front of the RDS instance.
d)
Set up Route 53 with health checks pointing to the RDS instance.
8.
An application needs to connect to an Amazon RDS PostgreSQL database. Which of the following ensures secure communication between the application and the database?
a)
Enable SSL/TLS for connections to the RDS instance.
b)
Ensure the application connects using an IAM authentication token.
c)
Use a VPN to connect to the RDS instance.
d)
Encrypt the database credentials using AWS KMS before using them.
9.
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?
a)
Use AWS CloudWatch metrics and alarms.
b)
Enable Enhanced Monitoring for the RDS instance and configure CloudWatch alarms.
c)
Deploy a custom monitoring script on the RDS instance.
d)
Use AWS Trusted Advisor for performance alerts.
10.
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?
a)
Configure Multi-AZ deployment for the RDS instance.
b)
Create one or more read replicas for the RDS instance.
c)
Use Amazon ElastiCache in front of the database.
d)
Increase the instance size of the primary database.
11.
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?
a)
Manually connect to the database using a SQL client and run the schema creation scripts.
b)
Use AWS CloudFormation with a custom resource that executes the schema creation script.
c)
Use AWS Lambda to execute schema creation scripts after the RDS instance is available.
d)
Write an application script to deploy the schema.
12.
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?
a)
Deploy Amazon RDS Oracle in a Multi-AZ configuration.
b)
Use Amazon Aurora as a replacement for the Oracle database.
c)
Use AWS Database Migration Service (DMS) to migrate the database to RDS Oracle with Multi-AZ enabled.
d)
Migrate the database to an Amazon EC2 instance and set up replication.
13.
How can a developer ensure that data stored in an Amazon RDS database is encrypted at rest?
a)
Enable encryption when creating the RDS instance.
b)
Use AWS Key Management Service (KMS) to encrypt specific database tables.
c)
Manually encrypt data before storing it in RDS.
d)
Use RDS Reserved Instances for encryption.
14.
How can a Solutions Architect ensure high availability for an Amazon RDS database?
a)
Use Read Replicas in another Region.
b)
Enable Multi-AZ deployment.
c)
Use Elastic Load Balancing in front of RDS.
d)
Set up Auto Scaling for RDS instances.
15.
You are migrating an on-premises database to Amazon RDS. Which AWS service can help simplify this migration?
a)
AWS Database Migration Service (DMS)
b)
AWS Snowball
c)
Amazon Athena
d)
AWS Glue
16.
How can a Solutions Architect improve query performance for a heavily used Amazon RDS database?
a)
Increase instance size and enable Multi-AZ.
b)
Use RDS Proxy.
c)
Create Read Replicas and distribute queries.
d)
Enable Amazon ElastiCache.
17.
How can a DevOps Engineer minimize downtime during an RDS maintenance window?
a)
Enable Multi-AZ deployment.
b)
Schedule maintenance during off-peak hours.
c)
Use RDS Read Replicas.
d)
Use Amazon Aurora instead.
18.
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?
a)
Use AWS Systems Manager Parameter Store with encryption.
b)
Store the credentials in plaintext within the CI/CD pipeline configuration.
c)
Use IAM Roles for accessing the database directly.
d)
Pass the credentials as environment variables from the build server.
19.
What is the best way to monitor query performance in Amazon RDS?
a)
Use CloudWatch Metrics.
b)
Enable Enhanced Monitoring.
c)
Use Amazon RDS Performance Insights.
d)
Create a custom monitoring script.
20.
A company’s database must automatically failover in case of instance failure. Which Amazon RDS feature ensures this?
a)
Read Replicas
b)
Multi-AZ deployment
c)
RDS Proxy
d)
AWS Backup
21.
A developer needs to handle increased database load during peak times. Which feature of Amazon RDS can help scale the read workload effectively?
a)
Multi-AZ Deployment
b)
RDS Read Replica
c)
RDS Reserved Instances
d)
Amazon ElastiCache
22.
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?
a)
Create a read replica of the production database.
b)
Restore the production database snapshot to a new RDS instance.
c)
Export the production database to Amazon S3 and import it into a new RDS instance.
d)
Use AWS Database Migration Service (DMS) to migrate data to a new instance.
23.
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?
a)
Stop the database instance during non-business hours.
b)
Use a smaller instance class for the RDS database.
c)
Enable Multi-AZ deployment to improve availability.
d)
Move the database to an on-premises server
24.
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?
a)
Use AWS Backup to automate the creation and retention of daily RDS snapshots.
b)
Manually create a snapshot daily and set a calendar reminder to delete older snapshots.
c)
Enable RDS automatic backups and use a script to delete old snapshots.
d)
Use an AWS Lambda function triggered by an EventBridge rule to manage snapshots.
25.
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?
a)
Enable Amazon Aurora and migrate the database.
b)
Add multiple RDS Read Replicas and distribute read traffic across them.
c)
Increase the instance class of the primary RDS instance.
d)
Enable RDS storage auto-scaling.
26.
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?
a)
Deploy a Multi-AZ RDS instance and configure query caching in the application.
b)
Deploy a read replica in a different AZ from the primary database.
c)
Use Amazon DynamoDB as a replica for the RDS instance.
d)
Use AWS Lambda to perform reporting queries separately.
27.
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?
a)
Use Amazon RDS read replicas in the target Regions.
b)
Set up Amazon Aurora Global Database.
c)
Use AWS Database Migration Service (DMS) to replicate the database.
d)
Deploy a Multi-AZ RDS instance in each Region and synchronize manually.
28.
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?
a)
Increase the instance size of the Amazon RDS MySQL instance.
b)
Use an Amazon RDS Proxy to pool and share connections.
c)
Implement caching with Amazon ElastiCache.
d)
Enable Multi-AZ deployment for Amazon RDS.
29.
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?
a)
Launch a single Amazon RDS instance with automatic backups enabled.
b)
Deploy Amazon RDS in a Multi-AZ configuration.
c)
Use Amazon RDS Read Replicas across regions.
d)
Configure Amazon RDS with cross-region snapshots.
30.
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?
a)
Manually apply schema changes during off-peak hours.
b)
Use AWS Database Migration Service (AWS DMS) for every schema update.
c)
Use a deployment framework like AWS CodePipeline with a step for schema migrations.
d)
Create a Read Replica, update the schema on it, and then promote it to the primary database.
31.
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?
a)
Export the on-premises database to an S3 bucket, then import it into Amazon RDS.
b)
Use the AWS Database Migration Service (DMS) with continuous replication. *
c)
Manually copy data over SSH and insert it into the RDS database.
d)
Use RDS snapshots to import the on-premises database.
32.
You launched an Amazon RDS instance without enabling encryption, and now you need to encrypt the database. How should you proceed?
a)
Enable encryption on the existing RDS instance.
b)
Create a snapshot of the database, copy it with encryption enabled, and restore it to a new RDS instance. *
c)
Use AWS Key Management Service (KMS) to encrypt the existing RDS instance.
d)
Create a new RDS instance with encryption enabled and manually migrate data.
33.
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?
a)
Add a read replica to offload read traffic.
b)
Increase the instance size of the RDS database.
c)
Use Amazon Aurora MySQL instead of RDS MySQL.*
d)
Create an ElastiCache layer to cache writes.
34.
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?
a)
Use the RDS Performance Insights dashboard to identify slow queries. *
b)
Enable CloudWatch Logs and monitor database connections.
c)
Configure an RDS event notification for slow queries.
d)
Enable Multi-AZ deployment to reduce latency.
35.
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?
a)
Enable Multi-AZ deployment for the RDS instance. *
b)
Set up a read replica in another availability zone and promote it when needed.
c)
Use AWS Backup to create frequent backups for disaster recovery.
d)
Deploy the RDS instance in a single availability zone and monitor with CloudWatch alarms.
36.
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?
a)
Export the RDS database to an S3 bucket and import it into an Aurora MySQL cluster.
b)
Use the AWS Database Migration Service (DMS) to migrate data to Aurora MySQL.
c)
Create a read replica of the RDS MySQL database and promote it to an Aurora MySQL instance.
d)
Take a snapshot of the RDS MySQL instance and restore it as an Aurora MySQL cluster. *
37.
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?
a)
Choose a time during peak business hours to detect issues quickly.
b)
Select a maintenance window during low-traffic periods for the application. *
c)
Disable automatic maintenance updates for the RDS instance.
d)
Configure manual maintenance updates to avoid downtime.
38.
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?
a)
Enable Multi-AZ deployment for high availability within the primary region. *
b)
Set up cross-region read replicas in another AWS region. *
c)
Use AWS Backup to create daily backups and copy them to another region.
d)
Deploy the database in a single availability zone and set up automated backups.
39.
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?
a)
Upgrade to a larger instance class with more CPU and memory. *
b)
Shard the database into multiple RDS instances based on application logic. *
c)
Enable read replicas to offload read traffic from the primary database.
d)
Use partitioning at the application level to distribute writes across tables.
40.
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?
a)
Use an RDS Multi-AZ instance with a smaller instance class.
b)
Use an RDS Single-AZ instance with storage auto-scaling enabled.
c)
Use RDS Aurora Serverless and configure the database to scale to zero capacity during off-hours.
d)
Schedule manual snapshots and delete the RDS instance after testing each day.
41.
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?
a)
Set up Multi-AZ in each Region to replicate data.
b)
Use AWS DMS to continuously replicate data between Regions.
c)
Configure logical replication between RDS PostgreSQL instances in different Regions.
d)
Use Amazon S3 to transfer data between Regions and reload it into RDS.
42.
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?
a)
Manually reboot the RDS instance using the AWS Management Console.
b)
Use the "Force Failover" API action to initiate failover.
c)
Stop the primary instance and monitor failover.
d)
Simulate failure by deleting the primary instance's subnet.
43.
A company needs to migrate its RDS MySQL instance to a new AWS Region with minimal downtime. What is the best migration approach?
a)
Take a snapshot of the database and restore it in the new Region.
b)
Create a cross-Region Read Replica and promote it after synchronization.
c)
Use AWS DMS in full-load mode to replicate the database.
d)
Enable Multi-AZ and switch to the secondary instance in the new Region.
44.
A developer observes frequent connection timeouts when an application interacts with an RDS PostgreSQL database during peak traffic. How can this issue be mitigated?
a)
Increase the max_connections parameter in the RDS parameter group.
b)
Use Amazon RDS Proxy to manage database connections.
c)
Scale the database vertically to a larger instance size.
d)
Implement read replicas to distribute traffic.
45.
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?
a)
Enable encryption on the existing RDS instance.
b)
Take a snapshot, create an encrypted copy, and restore a new instance from the encrypted snapshot.
c)
Modify the RDS instance and select the encryption option.
d)
Use AWS KMS to encrypt the existing instance in place.
46.
Your team schedules maintenance windows for an RDS database. How can you ensure the database is automatically updated to the latest minor version?
a)
Manually apply updates during the maintenance window.
b)
Enable "Auto Minor Version Upgrade" for the RDS instance.
c)
Configure an AWS Lambda function to apply updates.
d)
Use AWS Systems Manager Patch Manager for RDS.
47.
A developer needs to monitor query performance on an RDS MySQL instance. Which feature should they use to analyze slow queries?
a)
Enable Amazon CloudWatch Metrics.
b)
Use the Performance Insights feature.
c)
Configure AWS CloudTrail to monitor database queries.
d)
Enable query logging in the MySQL configuration.
48.
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?
a)
Monitor storage usage and manually increase storage during spikes.
b)
Enable storage auto-scaling for the RDS instance.
c)
Configure a read replica to handle additional load.
d)
Scale up the instance to a larger size.
Reset
