WorksheetsAWS_RDS
Total questions: 30
Worksheet time: 15mins
What does Amazon RDS stand for?
Regional Data Server.
Relational Database Service
Regional Database Service.
How many relational database engines does RDS currently support?
MySQL, Postgres, MariaDB, Oracle and Microsoft SQL Server
Just two: MySQL and Oracle.
Five: MySQL, PostgreSQL, MongoDB, Cassandra and SQLite.
Just one: MySQL.
What is the name of licensing model in which I can use your existing Oracle Database licenses to run Oracle deployments on Amazon RDS?
Bring Your Own License
Role Bases License
Enterprise License
License Included
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
What are the two types of licensing options available for using Amazon RDS for Oracle?
BYOL and Enterprise License
BYOL and License Included
Enterprise License and License Included
Role based License and License Included
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
A user is launching an AWS RDS with MySQL. Which of the below mentioned options allows the user to configure the InnoDB engine parameters?
Options group
Engine parameters
Parameter groups
DB parameters
A user is planning to use the AWS RDS with MySQL. Which of the below mentioned services the user is not going to pay?
Data transfer
RDS CloudWatch metrics
Data storage
I/O requests per month
Amazon RDS DB snapshots and automated backups are stored in
Amazon S3
Amazon EBS Volume
Amazon RDS
Amazon EMR
You receive a frantic call from a new DBA who accidentally dropped a table containing all your customers. Which Amazon RDS feature will allow you to reliably restore your database to within 5 minutes of when the mistake was made?
Multi-AZ RDS
RDS snapshots
RDS read replicas
RDS automated backup
What happens to the I/O operations while you take a database snapshot?
I/O operations to the database are suspended for a few 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
A user is running a MySQL RDS instance. The user will not use the DB for the next 3 months. How can the user save costs?
Pause the RDS activities from CLI until it is required in the future
Stop the RDS instance
Create a snapshot of RDS to launch in the future and terminate the instance now
Change the instance size to micro
When should I choose Provisioned IOPS over Standard RDS storage?
If you have batch-oriented workloads
If you use production online transaction processing (OLTP) workloads
If you have workloads that are not sensitive to consistent performance
If I want to run a database in an Amazon instance, which is the most recommended Amazon storage option?
Amazon Instance Storage
Amazon EBS
You can’t run a database inside an Amazon instance.
Amazon S3
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.
A company is deploying a new two-tier web application in AWS. The company has limited staff and requires high availability, and the application requires complex queries and table joins. Which configuration provides the solution for the company’s requirements?
MySQL Installed on two Amazon EC2 Instances in a single Availability Zone
Amazon RDS for MySQL with Multi-AZ
Amazon ElastiCache
Amazon DynamoDB
Your company is getting ready to do a major public announcement of a social media site on AWS. The website is running on EC2 instances deployed across multiple Availability Zones with a Multi-AZ RDS MySQL Extra Large DB Instance. The site performs a high number of small reads and writes per second and relies on an eventual consistency model. After comprehensive tests you discover that there is read contention on RDS MySQL. Which are the best approaches to meet these requirements? (Choose 2 answers)
Deploy ElastiCache in-memory cache running in each availability zone
Implement sharding to distribute load to multiple RDS MySQL instances
Increase the RDS MySQL Instance size and Implement provisioned IOPS
Add an RDS MySQL read replica in each availability zone
Your company has HQ in Tokyo and branch offices all over the world and is using logistics software with a multi-regional deployment on AWS in Japan, Europe and US. The logistic software has a 3-tier architecture and currently uses MySQL 5.6 for data persistence. Each region has deployed its own database. In the HQ region you run an hourly batch process reading data from every region to compute cross-regional reports that are sent by email to all offices this batch process must be completed as fast as possible to quickly optimize logistics. How do you build the database architecture in order to meet the requirements?
For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region
For each regional deployment, use MySQL on EC2 with a master in the region and send hourly EBS snapshots to the HQ region
For each regional deployment, use RDS MySQL with a master in the region and send hourly RDS snapshots to the HQ region
For each regional deployment, use MySQL on EC2 with a master in the region and use S3 to copy data files hourly to the HQ region
Use Direct Connect to connect all regional MySQL deployments to the HQ region and reduce network latency for the batch process
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
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
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
A user has scheduled the maintenance window of an RDS DB on Monday at 3 AM. Which of the below mentioned events may force to take the DB instance offline during the maintenance window?
Enabling Read Replica
Making the DB Multi AZ
DB password change
Security patching
A user has launched an RDS postgreSQL DB with AWS. The user did not specify the maintenance window during creation. The user has configured RDS to update the DB instance type from micro to large. If the user wants to have it during the maintenance window, what will AWS do?
AWS will not allow to update the DB until the maintenance window is configured
AWS will select the default maintenance window if the user has not provided it
AWS will ask the user to specify the maintenance window during the update
It is not possible to change the DB size from micro to large with RDS
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.
In the Amazon CloudWatch, which metric should I be checking to ensure that your DB Instance has enough free storage space?
FreeStorage
FreeStorageSpace
FreeStorageVolume
FreeDBStorageSpace
A user is receiving a notification from the RDS DB whenever there is a change in the DB security group. The user does not want to receive these notifications for only a month. Thus, he does not want to delete the notification. How can the user configure this?
Change the Disable button for notification to “Yes” in the RDS console
Set the send mail flag to false in the DB event notification console
The only option is to delete the notification from the console
Change the Enable button for notification to “No” in the RDS console
A sys admin is planning to subscribe to the RDS event notifications. For which of the below mentioned source categories the subscription cannot be configured?
DB security group
DB snapshot
DB options group
DB parameter group
A system admin is planning to setup event notifications on RDS. Which of the below mentioned services will help the admin setup notifications?
AWS SES
AWS Cloudtrail
AWS CloudWatch
AWS SNS
A user has setup an RDS DB with Oracle. The user wants to get notifications when someone modifies the security group of that DB. How can the user configure that?
It is not possible to get the notifications on a change in the security group
Configure SNS to monitor security group changes
Configure event notification on the DB security group
Configure the CloudWatch alarm on the DB for a change in the security group
