AWS Relational Database Service – RDS practice questions-

 


1. What does Amazon RDS stand for?

  1. Regional Data Server.
  2. Relational Database Service
  3. Regional Database Service.

 

[showhide type=”q1″ more_text=”Answer is…” less_text=”Show less…”]

2. Relational Database Service

[/showhide]

 

2. How many relational database engines does RDS currently support?

  1. MySQL, Postgres, MariaDB, Oracle and Microsoft SQL Server
  2. Just two: MySQL and Oracle.
  3. Five: MySQL, PostgreSQL, MongoDB, Cassandra and SQLite.
  4. Just one: MySQL.

 

[showhide type=”q2″ more_text=”Answer is…” less_text=”Show less…”]

  1. MySQL, Postgres, MariaDB, Oracle and Microsoft SQL Server

[/showhide]

 

3. 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?

  1. No
  2. Yes

 

[showhide type = “q3″ more_text=”Answer is…” less_text=”Show less…”]

2. Yes

[/showhide]

 

4. What is the name of licensing model in which I can use your existing Oracle Database licenses to run Oracle deployments on Amazon RDS?

  1. Bring Your Own License
  2. Role Bases License
  3. Enterprise License
  4. License Included

 

[showhide type=”q4″ more_text=”Answer is…” less_text=”Show less…”]1. Bring Your Own License[/showhide]

 

5. Will I be charged if the DB instance is idle?

  1. No
  2. Yes
  3. Only is running in GovCloud
  4. Only if running in VPC

 

[showhide type=”q5″ more_text=”Answer is…” less_text=”Show less…”]

2. Yes

[/showhide]

 

6. What is the minimum charge for the data transferred between Amazon RDS and Amazon EC2 Instances in the same Availability Zone?

  1. USD 0.10 per GB
  2. No charge. It is free.
  3. USD 0.02 per GB
  4. USD 0.01 per GB

 

[showhide type=”q6″ more_text=”Answer is…” less_text=”Show less…”]

2. No charge. It is free.

[/showhide]

 

7. Does Amazon RDS allow direct host access via Telnet, Secure Shell (SSH), or Windows Remote Desktop Connection?

  1. Yes
  2. No
  3. Depends on if it is in VPC or not

 

[showhide type=”q7″ more_text=”Answer is…” less_text=”Show less…”]

2. No

[/showhide]

 

8. What are the two types of licensing options available for using Amazon RDS for Oracle?

  1. BYOL and Enterprise License
  2. BYOL and License Included
  3. Enterprise License and License Included
  4. Role based License and License Included

 

[showhide type=”q8″ more_text=”Answer is…” less_text=”Show less…”]

2. BYOL and License Included

[/showhide]

 

9. A user plans to use RDS as a managed DB platform. Which of the below mentioned features is not supported by RDS?

  1. Automated backup
  2. Automated scaling to manage a higher load
  3. Automated failure detection and recovery
  4. Automated software patching

 

[showhide type=”q9″ more_text=”Answer is…” less_text=”Show less…”]

2. Automated scaling to manage a higher load

[/showhide]

 

10. A user is launching an AWS RDS with MySQL. Which of the below mentioned options allows the user to configure the InnoDB engine parameters?

  1. Options group
  2. Engine parameters
  3. Parameter groups
  4. DB parameters

 

[showhide type=”q10″ more_text=”Answer is…” less_text=”Show less…”]

3. Parameter groups

[/showhide]




11. A user is planning to use the AWS RDS with MySQL. Which of the below mentioned services the user is not going to pay?

  1. Data transfer
  2. RDS CloudWatch metrics
  3. Data storage
  4. I/O requests per month

 

[showhide type=”q11″ more_text=”Answer is…” less_text=”Show less…”]

2. RDS CloudWatch metrics

[/showhide]

 

12. 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.

  1. 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.
  2. Generate the reports by querying the synchronously replicated standby RDS MySQL instance maintained through Multi-AZ
  3. Launch a RDS Read Replica connected to your Multi-AZ master database and generate reports by querying the Read Replica.
  4. Generate the reports by querying the ElastiCache database caching tier.

 

[showhide type=”q12″ more_text=”Answer is…” less_text=”Show less…”]

3. Launch a RDS Read Replica connected to your Multi-AZ master database and generate reports by querying the Read Replica

[/showhide]

 

13. 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?

  1. MySQL Installed on two Amazon EC2 Instances in a single Availability Zone
  2. Amazon RDS for MySQL with Multi-AZ
  3. Amazon ElastiCache
  4. Amazon DynamoDB

 

[showhide type=”q13″ more_text=”Answer is…” less_text=”Show less…”]

2. Amazon RDS for MySQL with Multi-AZ

[/showhide]

 

14. 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)

  1. Deploy ElastiCache in-memory cache running in each availability zone
  2. Implement sharding to distribute load to multiple RDS MySQL instances
  3. Increase the RDS MySQL Instance size and Implement provisioned IOPS
  4. Add an RDS MySQL read replica in each availability zone

 

[showhide type=”q14″ more_text=”Answer is…” less_text=”Show less…”]

  1. Deploy ElastiCache in-memory cache running in each availability zone.       &          4. Add an RDS MySQL read replica in each availability zone

[/showhide]

 

15. 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?

  1. For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region
  2. For each regional deployment, use MySQL on EC2 with a master in the region and send hourly EBS snapshots to the HQ region
  3. For each regional deployment, use RDS MySQL with a master in the region and send hourly RDS snapshots to the HQ region
  4. 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
  5. Use Direct Connect to connect all regional MySQL deployments to the HQ region and reduce network latency for the batch process

 

[showhide type=”q15″ more_text=”Answer is…” less_text=”Show less…”]

3. For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region

[/showhide]

 

16. What would happen to an RDS (Relational Database Service) multi-Availability Zone deployment if the primary DB instance fails?

  1. IP of the primary DB Instance is switched to the standby DB Instance.
  2. A new DB instance is created in the standby availability zone.
  3. The canonical name record (CNAME) is changed from primary to standby.
  4. The RDS (Relational Database Service) DB instance reboots.

 

[showhide type=”q16″ more_text=”Answer is…” less_text=”Show less…”]

3. The canonical name record (CNAME) is changed from primary to standby

[/showhide]

 

17. 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?

  1. Enable Multi-AZ mode on the RDS instance
  2. Use ElastiCache to offload the analytics job data
  3. Create RDS Read-Replicas for the analytics work
  4. Run the RDS instance on the largest size possible

 

[showhide type=”q17″ more_text=”Answer is…” less_text=”Show less…”]

3. Create RDS Read-Replicas for the analytics work

[/showhide]

 

18. Will my standby RDS instance be in the same Availability Zone as my primary?

  1. Only for Oracle RDS types
  2. Yes
  3. Only if configured at launch
  4. No

 

[showhide type=”q18″ more_text=”Answer is…” less_text=”Show less…”]

4. No

[/showhide]

 

19. Is creating a Read Replica of another Read Replica supported?

  1. Only in certain regions
  2. Only with MySQL based RDS
  3. Only for Oracle RDS types
  4. No

 

[showhide type=”q19″ more_text=”Answer is…” less_text=”Show less…”]

2. Only with MySQL based RDS

[/showhide]

 

20. A user is planning to set up the Multi-AZ feature of RDS. Which of the below mentioned conditions won’t take advantage of the Multi-AZ feature?

  1. Availability zone outage
  2. A manual failover of the DB instance using Reboot with failover option
  3. Region outage
  4. When the user changes the DB instance’s server type

 

[showhide type=”q20″ more_text=”Answer is…” less_text=”Show less…”]

3. Region outage

[/showhide]




21. When you run a DB Instance as a Multi-AZ deployment, the “_____” serves database writes and reads

  1. secondary
  2. backup
  3. stand by
  4. primary

 

[showhide type=”q21″ more_text=”Answer is…” less_text=”Show less…”]

4. Primary

[/showhide]

 

22. When running my DB Instance as a Multi-AZ deployment, can I use the standby for read or write operations?

  1. Yes
  2. Only with MSSQL based RDS
  3. Only for Oracle RDS instances
  4. No

 

[showhide type=”q22″ more_text=”Answer is…” less_text=”Show less…”]

4. No

[/showhide]

 

23. Read Replicas require a transactional storage engine and are only supported for the _________ storage engine

  1. OracleISAM
  2. MSSQLDB
  3. InnoDB
  4. MyISAM

 

[showhide type=”q23″ more_text=”Answer is…” less_text=”Show less…”]

3. InnoDB

[/showhide]

 

24. 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?

  1. MySQL
  2. Oracle
  3. MS SQL
  4. PostgreSQL

 

[showhide type=”q24″ more_text=”Answer is…” less_text=”Show less…”]

3. MS SQL

[/showhide]

 

25. 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?

  1. The remaining Read Replicas will still replicate from the older master DB Instance
  2. The remaining Read Replicas will be deleted
  3. The remaining Read Replicas will be combined to one read replica

 

[showhide type=”q25″ more_text=”Answer is…” less_text=”Show less…”]

  1. The remaining Read Replicas will still replicate from the older master DB Instance

[/showhide]

 

26. If you have chosen Multi-AZ deployment, in the event of a planned or unplanned outage of your primary DB Instance, Amazon RDS automatically switches to the standby replica. The automatic failover mechanism simply changes the ______ record of the main DB Instance to point to the standby DB Instance.

  1. DNAME
  2. CNAME
  3. TXT
  4. MX

 

[showhide type=”q26″ more_text=”Answer is…” less_text=”Show less…”]

2. CNAME

[/showhide]

 

27. When automatic failover occurs, Amazon RDS will emit a DB Instance event to inform you that automatic failover occurred. You can use the _____ to return information about events related to your DB Instance

  1. FetchFailure
  2. DescriveFailure
  3. DescribeEvents
  4. FetchEvents

 

[showhide type=”q27″ more_text=”Answer is…” less_text=”Show less…”]

3. DescribeEvents

[/showhide]

 

28. The new DB Instance that is created when you promote a Read Replica retains the backup window period.

  1. TRUE
  2. FALSE

 

[showhide type=”q28″ more_text=”Answer is…” less_text=”Show less…”]

  1. True

[/showhide]

 

29. Will I be alerted when automatic failover occurs?

  1. Only if SNS configured
  2. No
  3. Yes
  4. Only if Cloudwatch configured

 

[showhide type=”q29″ more_text=”Answer is…” less_text=”Show less…”]

  1. Only if SNS configured

[/showhide]

 

30. Can I initiate a “forced failover” for my MySQL Multi-AZ DB Instance deployment?

  1. Only in certain regions
  2. Only in VPC
  3. Yes
  4. No

 

[showhide type=”q30″ more_text=”Answer is…” less_text=”Show less…”]

3. Yes

[/showhide]




31. A user is accessing RDS from an application. The user has enabled the Multi-AZ feature with the MS SQL RDS DB. During a planned outage how will AWS ensure that a switch from DB to a standby replica will not affect access to the application?

  1. RDS will have an internal IP which will redirect all requests to the new DB
  2. RDS uses DNS to switch over to standby replica for seamless transition
  3. The switch over changes Hardware so RDS does not need to worry about access
  4. RDS will have both the DBs running independently and the user has to manually switch over

 

[showhide type=”q31″ more_text=”Answer is…” less_text=”Show less…”]

2. RDS uses DNS to switch over to standby replica for seamless transition

[/showhide]

 

32. Which of the following is part of the failover process for a Multi-AZ Amazon Relational Database Service (RDS) instance?

  1. The failed RDS DB instance reboots.
  2. The IP of the primary DB instance is switched to the standby DB instance.
  3. The DNS record for the RDS endpoint is changed from primary to standby.
  4. A new DB instance is created in the standby availability zone.

 

[showhide type=”q32″ more_text=”Answer is…” less_text=”Show less…”]

3. The DNS record for the RDS endpoint is changed from primary to standby

[/showhide]

 

33. Which of these is not a reason a Multi-AZ RDS instance will failover?

  1. An Availability Zone outage
  2. A manual failover of the DB instance was initiated using Reboot with failover
  3. To autoscale to a higher instance class (Refer link)
  4. Master database corruption occurs
  5. The primary DB instance fails

 

[showhide type=”q33″ more_text=”Answer is…” less_text=”Show less…”]

4. Master database corruption occurs

[/showhide]

 

34. You need to scale an RDS deployment. You are operating at 10% writes and 90% reads, based on your logging. How best can you scale this in a simple way?

  1. Create a second master RDS instance and peer the RDS groups.
  2. Cache all the database responses on the read side with CloudFront.
  3. Create read replicas for RDS since the load is mostly reads.
  4. Create a Multi-AZ RDS installs and route read traffic to standby.

 

[showhide type=”q34″ more_text=”Answer is…” less_text=”Show less…”]

  1. Create read replicas for RDS since the load is mostly reads.

[/showhide]

 

35. How does Amazon RDS multi Availability Zone model work?

  1. A second, standby database is deployed and maintained in a different availability zone from master, using synchronous replication. 
  2. A second, standby database is deployed and maintained in a different availability zone from master using asynchronous replication.
  3. A second, standby database is deployed and maintained in a different region from master using asynchronous replication.
  4. A second, standby database is deployed and maintained in a different region from master using synchronous replication.

 

[showhide type=’q35″ more_text=”Answer is…” less_text=”Show less…”]

  1. A second, standby database is deployed and maintained in a different availability zone from master, using synchronous replication

[/showhide]

 

36. A customer is running an application in US-West (Northern California) region and wants to setup disaster recovery failover to the Asian Pacific (Singapore) region. The customer is interested in achieving a low Recovery Point Objective (RPO) for an Amazon RDS multi-AZ MySQL database instance. Which approach is best suited to this need?

  1. Synchronous replication
  2. Asynchronous replication
  3. Route53 health checks
  4. Copying of RDS incremental snapshots

 

[showhide type=”q36″ more_text=”Answer is…” less_text=”Show less…”]

2. Asynchronous replication

[/showhide]

 

37. A user is using a small MySQL RDS DB. The user is experiencing high latency due to the Multi AZ feature. Which of the below mentioned options may not help the user in this situation?

  1. Schedule the automated back up in non-working hours
  2. Use a large or higher size instance
  3. Use PIOPS
  4. Take a snapshot from standby Replica

 

[showhide type=”q37″ more_text=”Answer is…” less_text=”Show less…”]

4. Take a snapshot from standby Replica

[/showhide]

 

38. Are Reserved Instances available for Multi-AZ Deployments?

  1. Only for Cluster Compute instances
  2. Yes for all instance types
  3. Only for M3 instance types

 

[showhide type=”q38″ more_text=”Answer is…” less_text=”Show less…”]

2. Yes for all instance types

[/showhide]

 

39. My Read Replica appears “stuck” after a Multi-AZ failover and is unable to obtain or apply updates from the source DB Instance. What do I do?

  1. You will need to delete the Read Replica and create a new one to replace it.
  2. You will need to disassociate the DB Engine and re associate it.
  3. The instance should be deployed to Single AZ and then moved to Multi- AZ once again
  4. You will need to delete the DB Instance and create a new one to replace it.

 

[showhide type=”q39″ more_text=”Answer is…” less_text=”Show less…”]

  1. You will need to delete the Read Replica and create a new one to replace it

[/showhide]

 

40. What is the charge for the data transfer incurred in replicating data between your primary and standby?

  1. No charge. It is free.
  2. Double the standard data transfer charge
  3. Same as the standard data transfer charge
  4. Half of the standard data transfer charge

 

[showhide type=”q40″ more_text=”Answer is…” less_text=”Show less…”]

  1. No charge. It is free

[/showhide]




41. A user has enabled the Multi AZ feature with the MS SQL RDS database server. Which of the below mentioned statements will help the user understand the Multi AZ feature better?

  1. In a Multi AZ, AWS runs two DBs in parallel and copies the data asynchronously to the replica copy
  2. In a Multi AZ, AWS runs two DBs in parallel and copies the data synchronously to the replica copy
  3. In a Multi AZ, AWS runs just one DB but copies the data synchronously to the standby replica
  4. AWS MS SQL does not support the Multi AZ feature

 

[showhide type=”q41″ more_text=”Answer is…” less_text=”Show less…”]

3. In a Multi AZ, AWS runs just one DB but copies the data synchronously to the standby replica

[/showhide]

 

42. A company is running a batch analysis every hour on their main transactional DB running on an RDS MySQL instance to populate their central Data Warehouse running on Redshift. During the execution of the batch their transactional applications are very slow. When the batch completes they need to update the top management dashboard with the new data. The dashboard is produced by another system running on-premises that is currently started when a manually-sent email notifies that an update is required The on-premises system cannot be modified because is managed by another team. How would you optimize this scenario to solve performance issues and automate the process as much as possible?

  1. Replace RDS with Redshift for the batch analysis and SNS to notify the on-premises system to update the dashboard
  2. Replace RDS with Redshift for the batch analysis and SQS to send a message to the on-premises system to update the dashboard
  3. Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard
  4. Create an RDS Read Replica for the batch analysis and SQS to send a message to the on-premises system to update the dashboard.

 

[showhide type=”q42″ more_text=”Answer is…” less_text=”Show less…”]

3. Create an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard

[/showhide]

 

43. When should I choose Provisioned IOPS over Standard RDS storage?

  1. If you have batch-oriented workloads
  2. If you use production online transaction processing (OLTP) workloads
  3. If you have workloads that are not sensitive to consistent performance

 

[showhide type=”q43″ more_text=”Answer is…” less_text=”Show less…”]

2. If you use production online transaction processing (OLTP) workloads

[/showhide]

 

44. Is decreasing the storage size of a DB Instance permitted?

  1. Depends on the RDMS used
  2. Yes
  3. No

 

[showhide type=”q44″ more_text=”Answer is…” less_text=”Show less…”]

3. No

[/showhide]

 

45. Because of the extensibility limitations of striped storage attached to Windows Server, Amazon RDS does not currently support increasing storage on a _____ DB Instance.

  1. SQL Server
  2. MySQL
  3. Oracle

 

[showhide type=”q45″ more_text=”Answer is…” less_text=”Show less…”]

  1. SQL Server

[/showhide]

 

46. If I want to run a database in an Amazon instance, which is the most recommended Amazon storage option?

  1. Amazon Instance Storage
  2. Amazon EBS
  3. You can’t run a database inside an Amazon instance.
  4. Amazon S3

 

[showhide type=”q46″ more_text=”Answer is…” less_text=”Show less…”]

2. Amazon EBS

[/showhide]

 

47. For each DB Instance class, what is the maximum size of associated storage capacity?

  1. 1TB
  2. 2TB
  3. 500GB
  4. 6TB

 

[showhide type=”q47″ more_text=”Answer is…” less_text=”Show less…”]

4. 6TB

[/showhide]

 

48. Amazon RDS automated backups and DB Snapshots are currently supported for only the __________ storage engine

  1. InnoDB
  2. MyISAM

 

[showhide type=”q48″ more_text=”Answer is…” less_text=”Show less…”]

  1. InnoDB

[/showhide]

 

49. Automated backups are enabled by default for a new DB Instance.

  1. TRUE
  2. FALSE

 

[showhide type=”q49″ more_text=”Answer is…” less_text=”Show less…”]

  1. TRUE

[/showhide]




50. Amazon RDS DB snapshots and automated backups are stored in

  1. Amazon S3
  2. Amazon EBS Volume
  3. Amazon RDS
  4. Amazon EMR

 

[showhide type=”q50″ more_text=”Answer is…” less_text=”Show less…”]

  1. Amazon S3

[/showhide]

 

51. 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?

  1. Multi-AZ RDS
  2. RDS snapshots
  3. RDS read replicas
  4. RDS automated backup

 

[showhide type=”q51″ more_text=”Answer is…” less_text=”Show less…”]

4. RDS automated backup

[/showhide]

 

52. Disabling automated backups ______ disable the point-in-time recovery.

  1. if configured to can
  2. will never
  3. will

 

[showhide type=”q52″ more_text=”Answer is…” less_text=”Show less…”]

3. will

[/showhide]

 

53. Changes to the backup window take effect ______.

  1. from the next billing cycle
  2. after 30 minutes
  3. immediately
  4. after 24 hours

 

[showhide type=”q53″ more_text=”Answer is…” less_text=”Show less…”]

3. immediately

[/showhide]

 

54. You can modify the backup retention period; valid values are 0 (for no backup retention) to a maximum of ___________ days.

  1. 45
  2. 35
  3. 15
  4. 5

 

[showhide type=”q54″ more_text=”Answer is…” less_text=”Show less…”]

2. 35

[/showhide]

 

55. Amazon RDS automated backups and DB Snapshots are currently supported for only the ______ storage engine

  1. MyISAM
  2. InnoDB

 

[showhide type=”q55″ more_text=”Answer is…” less_text=”Show less…”]

2. InnoDB

[/showhide]

 

56. What happens to the I/O operations while you take a database snapshot?

  1. I/O operations to the database are suspended for a few minutes while the backup is in progress.
  2. I/O operations to the database are sent to a Replica (if available) for a few minutes while the backup is in progress.
  3. I/O operations will be functioning normally
  4. I/O operations to the database are suspended for an hour while the backup is in progress

 

[showhide type=”q56″ more_text=”Answer is…” less_text=”Show less…”]

  1. I/O operations to the database are suspended for a few minutes while the backup is in progress

[/showhide]

 

57. True or False: 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.

  1. FALSE
  2. TRUE

 

[showhide type=”q57″ more_text=”Answer is…” less_text=”Show less…”]

2. True

[/showhide]

 

58. True or False: Manually created DB Snapshots are deleted after the DB Instance is deleted.

  1. TRUE
  2. FALSE

 

[showhide type=”q58″ more_text=”Answer is…” less_text=”Show less…”]

2. False

[/showhide]

 

59. 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?

  1. Pause the RDS activities from CLI until it is required in the future
  2. Stop the RDS instance
  3. Create a snapshot of RDS to launch in the future and terminate the instance now
  4. Change the instance size to micro

 

[showhide type=”q59″ more_text=”Answer is…” less_text=”Show less…”]

3. Create a snapshot of RDS to launch in the future and terminate the instance now

[/showhide]

 

60. Can I encrypt connections between my application and my DB Instance using SSL?

  1. No
  2. Yes
  3. Only in VPC
  4. Only in certain regions

 

[showhide type=”q60″ more_text=”Answer is…” less_text=”Show less…”]

2. Yes

[/showhide]




61. Which of these configuration or deployment practices is a security risk for RDS?

  1. Storing SQL function code in plaintext
  2. Non-Multi-AZ RDS instance
  3. Having RDS and EC2 instances exist in the same subnet
  4. RDS in a public subnet

 

[showhide type=”q61″ more_text=”Answer is…” less_text=”Show less…”]

4. RDS in public subnet

[/showhide]

 

62. 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. 1, 2, 3, 4
  2. 1, 2, 3
  3. 2, 3, 4, 1

 

[showhide type=”q62″ more_text=”Answer is…” less_text=”Show less…”]

2. 1, 2, 3

[/showhide]

 

63. Can I control if and when MySQL based RDS Instance is upgraded to new supported versions?

  1. No
  2. Only in VPC
  3. Yes

 

[showhide type=”q63″ more_text=”Answer is…” less_text=”Show less…”]

3. Yes

[/showhide]

 

64. 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?

  1. Enabling Read Replica
  2. Making the DB Multi AZ
  3. DB password change
  4. Security patching

 

[showhide type=”q64″ more_text=”Answer is…” less_text=”Show less…”]

4. Security Patching

[/showhide]

 

65. 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?

  1. AWS will not allow to update the DB until the maintenance window is configured
  2. AWS will select the default maintenance window if the user has not provided it
  3. AWS will ask the user to specify the maintenance window during the update
  4. It is not possible to change the DB size from micro to large with RDS

 

[showhide type=”q65″ more_text=”Answer is…” less_text=”Show less…”]

2. AWS will select the default maintenance window if the user has not provided it

[/showhide]

 

66. Can I test my DB Instance against a new version before upgrading?

  1. No
  2. Yes
  3. Only in VPC

 

[showhide type=”q66″ more_text=”Answer is…” less_text=”Show less…”]

2. Yes

[/showhide]

 

67. 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

  1. The number of outstanding IOs waiting to access the disk
  2. The amount of write latency
  3. The amount of disk space occupied by binary logs on the master.
  4. The amount of time a Read Replica DB Instance lags behind the source DB Instance
  5. The average number of disk I/O operations per second.

 

[showhide type=”q67″ more_text=”Answer is…” less_text=”Show less…”]

  1. The number of outstanding IOs waiting to access the disk  &   2. The amount of write latency     &   4. The amount of time a Read Replica DB Instance lags behind the source DB Instance

[/showhide]

 

68. Typically, you want your application to check whether a request generated an error before you spend any time processing results. The easiest way to find out if an error occurred is to look for an __________ node in the response from the Amazon RDS API.

  1. Incorrect
  2. Error
  3. FALSE

 

[showhide type=”q68″ more_text=”Answer is…” less_text=”Show less…”]

2. Error

[/showhide]

 

69. In the Amazon CloudWatch, which metric should I be checking to ensure that your DB Instance has enough free storage space?

  1. FreeStorage
  2. FreeStorageSpace
  3. FreeStorageVolume
  4. FreeDBStorageSpace

 

[showhide type=”q69″ more_text=”Answer is…” less_text=”Show less…”]

2. FreeStorageSpace

[/showhide]

 

70. 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?

  1. Change the Disable button for notification to “Yes” in the RDS console
  2. Set the send mail flag to false in the DB event notification console
  3. The only option is to delete the notification from the console
  4. Change the Enable button for notification to “No” in the RDS console

 

[showhide type=”q70″ more_text=”Answer is…” less_text=”Show less…”]

4. Change the Enable button for notification to “No” in the RDS console

[/showhide]




71. 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?

  1. DB security group
  2. DB snapshot
  3. DB options group
  4. DB parameter group

 

[showhide type=”q71″ more_text=”Answer is…” less_text=”Show less…”]

3. DB options group

[/showhide]

 

72. A user is planning to setup notifications on the RDS DB for a snapshot. Which of the below mentioned event categories is not supported by RDS for this snapshot source type?

  1. Backup
  2. Creation
  3. Deletion
  4. Restoration

 

[showhide type=”q72″ more_text=”Answer is…” less_text=”Show less…”]

  1. Backup

[/showhide]

 

73. A system admin is planning to setup event notifications on RDS. Which of the below mentioned services will help the admin setup notifications?

  1. AWS SES
  2. AWS Cloudtrail
  3. AWS CloudWatch
  4. AWS SNS

 

[showhide type=”q73″ more_text=”Answer is…” less_text=”Show less…”]

4. AWS SNS

[/showhide]

 

74. 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?

  1. It is not possible to get the notifications on a change in the security group
  2. Configure SNS to monitor security group changes
  3. Configure event notification on the DB security group
  4. Configure the CloudWatch alarm on the DB for a change in the security group

 

[showhide type=”q74″ more_text=”Answer is…” less_text=”Show less…”]

3. Configure event notification on the DB security group

[/showhide]

 

75. 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.

  1. Write Lag
  2. Read Replica
  3. Replica Lag
  4. Single Replica

 

[showhide type=”q75″ more_text=”Answer is…” less_text=”Show less…”]

3. Replica Lag

[/showhide]

 

76. You are running a database on an EC2 instance, with the data stored on Elastic Block Store (EBS) for persistence At times throughout the day, you are seeing large variance in the response times of the database queries Looking into the instance with the isolate command you see a lot of wait time on the disk volume that the database’s data is stored on. What two ways can you improve the performance of the database’s storage while maintaining the current persistence of the data? Choose 2 answers

  1. Move to an SSD backed instance
  2. Move the database to an EBS-Optimized Instance
  3. Use Provisioned IOPs EBS
  4. Use the ephemeral storage on an m2.4xLarge Instance Instead

 

[showhide type=”q76″ more_text=”Answer is…” less_text=”Show less…”]

2. Move the database to an EBS-Optimized Instance      &      3. Use Provisioned IOPs EBS

[/showhide]

 

77. Amazon RDS automated backups and DB Snapshots are currently supported for only the __________ storage engine

  1. InnoDB
  2. MyISAM

 

[showhide type=”q77″ more_text=”Answer is…” less_text=”Show less…”]

  1. InnoDB

[/showhide]