Font size
WorksheetsRDS Exam Questions
Total questions: 20
Worksheet time: 18mins
You run a web application with the following components Elastic Load Balancer (ELB),
3 Web/Application servers, 1 MySQL RDS database with read replicas,
and Amazon Simple Storage Service (Amazon S3) for static content.
Average response time for users is increasing slowly.
What three CloudWatch RDS metrics will allow you to identify if the database is the
bottleneck? Choose 3 answers
The number of outstanding IOs waiting to access the disk
The amount of write latency
The amount of disk space occupied by binary logs on the master.
The amount of time a Read Replica DB Instance lags behind the source DB Instance
The average number of disk I/O operations per second.
It is advised that you watch the Amazon CloudWatch “_____” metric (available via the AWS Management Console or Amazon Cloud Watch APIs) carefully and recreate the Read Replica should it fall behind due to replication errors.
Write Lag
Read Replica
Replica Lag
Single Replica
Can I encrypt connections between my application and my DB Instance using SSL?
No
Yes
Only in VPC
Only in certain regions
Which of these configuration or deployment practices is a security risk for RDS?
Storing SQL function code in plaintext
Non-Multi-AZ RDS instance
Having RDS and EC2 instances exist in the same subnet
RDS in a public subnet
If I modify a DB Instance or the DB parameter group associated with the instance, should I reboot the instance for the changes to take effect?
No
Yes
What is the minimum charge for the data transferred between Amazon RDS and Amazon EC2 Instances in the same Availability Zone?
USD 0.10 per GB
No charge. It is free.
USD 0.02 per GB
USD 0.01 per GB
Does Amazon RDS allow direct host access via Telnet, Secure Shell (SSH), or Windows Remote Desktop Connection?
Yes
No
Depends on if it is in VPC or not
A user plans to use RDS as a managed DB platform. Which of the below mentioned features is not supported by RDS?
Automated backup
Automated scaling to manage a higher load
Automated failure detection and recovery
Automated software patching
Amazon RDS DB snapshots and automated backups are stored in
Amazon S3
Amazon EBS Volume
Amazon RDS
Amazon EMR
Disabling automated backups ______ disable the point-in-time recovery.
if configured to can
will never
will
You can modify the backup retention period; valid values are 0 (for no backup retention) to a maximum of ___________ days.
45
35
15
5
What happens to the I/O operations while you take a database snapshot?
I/O operations to the database are suspended for a few seconds/minutes while the backup is in progress.
I/O operations to the database are sent to a Replica (if available) for a few minutes while the backup is in progress.
I/O operations will be functioning normally
I/O operations to the database are suspended for an hour while the backup is in progress
When you perform a restore operation to a point in time or from a DB Snapshot, a new DB Instance is created with a new endpoint.
True
False
A user has launched an RDS MySQL DB with the Multi AZ feature. The user has scheduled the scaling of instance storage during maintenance window. What is the correct order of events during maintenance window?
1. Perform maintenance on standby
2. Promote standby to primary
3. Perform maintenance on original primary
4. Promote original master back as primary
1, 2, 3, 4
1, 2, 3
2, 3, 4, 1
You are running a successful multi-tier web application on AWS and your marketing department has asked you to add a reporting tier to the application. The reporting tier will aggregate and publish status reports every 30 minutes from user-generated information that is being stored in your web applications database. You are currently running a Multi-AZ RDS MySQL instance for the database tier. You also have implemented ElastiCache as a database caching layer between the application tier and database tier. Please select the answer that will allow you to successfully implement the reporting tier with as little impact as possible to your database.
Continually send transaction logs from your master database to an S3 bucket and generate the reports off the S3 bucket using S3 byte range requests.
Generate the reports by querying the synchronously replicated standby RDS MySQL instance maintained through Multi-AZ
Launch a RDS Read Replica connected to your Multi-AZ master database and generate reports by querying the Read Replica
Generate the reports by querying the ElastiCache database caching tier.
What would happen to an RDS (Relational Database Service) multi-Availability Zone deployment if the primary DB instance fails?
IP of the primary DB Instance is switched to the standby DB Instance.
A new DB instance is created in the standby availability zone
The canonical name record (CNAME) is changed from primary to standby.
The RDS (Relational Database Service) DB instance reboots.
Your business is building a new application that will store its entire customer database on a RDS MySQL database, and will have various applications and users that will query that data for different purposes. Large analytics jobs on the database are likely to cause other applications to not be able to get the query results they need to, before time out. Also, as your data grows, these analytics jobs will start to take more time, increasing the negative effect on the other applications. How do you solve the contention issues between these different workloads on the same data?
Enable Multi-AZ mode on the RDS instance.
Use ElastiCache to offload the analytics job data
Create RDS Read-Replicas for the analytics work
Run the RDS instance on the largest size possible
Is creating a Read Replica of another Read Replica supported?
Only in certain regions
Only with MySQL based RDS
Only for Oracle RDS types
No
A user is configuring the Multi-AZ feature of an RDS DB. The user came to know that this RDS DB does not use the AWS technology, but uses server mirroring to achieve replication. Which DB is the user using right now?
MySQL
Oracle
MS SQL
PostgreSQL
If I have multiple Read Replicas for my master DB Instance and I promote one of them, what happens to the rest of the Read Replicas?
The remaining Read Replicas will still replicate from the older master DB Instance
The remaining Read Replicas will be deleted
The remaining Read Replicas will be combined to one read replica
