Font size
WorksheetsAWS RDS Quiz
Total questions: 10
Worksheet time: 50mins
In Your company is hosting an application in AWS. The application is read intensive and consists of a set of web servers and AWS RDS. It has been noticed that the response time of the application increases due to the load on the AWS RDS instance. Which of the following measures can be taken to scale the data tier? Choose 2 answers from the options given below.
Create Amazon DB Read Replicas. Configure the application layer to query the ReadReplicas for query needs.
Use Auto Scaling to scale out and scale in the database tier.
Use SQS to cache the database queries.
Use ElastiCache in front of your Amazon RDS DB to cache common queries.
In Your company currently has a set of EC2 Instances running a web application which sits behind an Elastic Load Balancer. You also have an Amazon RDS instance which is accessible from the web application. You have been asked to ensure that this architecture is self-healing in nature and cost-effective. Which of the following would fulfill this requirement? Choose 2 answers from the options given below.
Use CloudWatch metrics to check the utilization of the web layer. Use Auto ScalingGroup to scale the web instances accordingly based on the CloudWatch metrics.
Use CloudWatch metrics to check the utilization of the databases servers. UseAuto Scaling Group to scale the database instances accordingly based on theCloudWatch metrics.
Utilize the Read Replica feature for the Amazon RDS layer.
Utilize the Multi-AZ feature for the Amazon RDS layer.
Your organization is building a collaboration platform for which they chose AWS EC2 for web and application servers and MySQL RDS instance as the database. Due to the nature of the traffic to the application, they would like to increase the number of connections to RDS instance. How can this be achieved?
Login to RDS instance and modify database config file under /etc/mysql/my.cnf
Create a new parameter group, attach it to DB instance and change the setting.
Create a new option group, attach it to DB instance and change the setting.
Modify setting in default options group attached to DB instance.
You have an AWS RDS PostgreSQL database hosted in the Singapore region. You need to ensure that a backup database is in place and the data is asynchronously copied. Which of the following would help fulfill this requirement?
Enable Multi-AZ for the database
Enable Read Replicas for the database
Enable Asynchronous replication for the database
Enable manual backups for the database
An application currently consists of an EC2 Instance hosting a Web application. The Web application connects to an AWS RDS database. Which of the following can be used to ensure that the database layer is highly available?
Create another EC2 Instance in another Availability Zone and host a replica of thedatabase.
Create another EC2 Instance in another Availability Zone and host a replica of the Webserver.
Enable Read Replica for the AWS RDS database.
Enable Multi-AZ for the AWS RDS database.
You are performing a Load Testing exercise on your application hosted on AWS. While testing your Amazon RDS MySQL DB Instance, you notice that your application becomes non responsive when you reach 100% CPU utilization. Your application is read-heavy. What methods will help scale your data-tier to meet the application’s needs? Choose three answers from the options given below.
Add Amazon RDS DB Read Replicas, and have your application direct read queries tothem.
Add your Amazon RDS DB Instance to an Auto Scaling group and configure yourCloudWatch metric based on CPU utilization.
Shard your data set among multiple Amazon RDS DB Instances.
Use ElastiCache in front of your Amazon RDS DB to cache common queries
A company is hosting a MySQL database in AWS using the AWS RDS service. To offload the reads, a Read Replica has been created and reports are run off the Read Replica database. But at certain times, the reports show stale data. Why may this be the case?
The Read Replica has not been created properly.
The backup of the original database has not been set properly.
This is due to the replication lag.
The Multi-AZ feature is not enabled.
A customer planning on hosting an AWS RDS instance, needs to ensure that the underlying data is encrypted. How can this be achieved? Choose 2 answers from the options given below.
Ensure that the right instance class is chosen for the underlying instance.
Choose only General Purpose SSD since only this volume type supports encryption ofdata.
Encrypt the database during creation.
Enable encryption of the underlying EBS Volume.
In Below are the requirements for a data store in AWS:a) Ability to perform SQL queriesb) Integration with existing business intelligence toolsc) High concurrency workload that generally involves reading and writing all columns of a small number of records at a timeWhich of the following would be an ideal data store for the above requirements? Choose 2 answers from the options below.
AWS Redshift
AWS RDS
AWS Aurora
AWS S3
A database is being hosted using the AWS RDS service. This database is to be made into a production database and is required to have high availability. Which of the following can be used to achieve this requirement?
Use Multi-AZ for the RDS instance to ensure that a secondary database is created inanother region.
Use the Read Replica feature to create another instance of the DB in another region.
Use Multi-AZ for the RDS instance to ensure that a secondary database is created inanother Availability Zone.
Uset he Read Replica feature to create another instance of the DB in anotherAvailability Zone.
