ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 20 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 20
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.
What should the company do to achieve this in the shortest amount of time?

  • A. Use a blue-green deployment with a complete application-level failover test
  • B. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover
  • C. Use RDS fault injection queries to simulate the primary node failure
  • D. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by leunamE at Nov. 10, 2021, 11:38 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
toppic26
Highly Voted 3 years, 7 months ago
B is the correct option. Use the RDS fault injection query to simulate the primary instance failure - This is a trick option. You can test the fault tolerance of your Aurora DB cluster by using fault injection queries. Fault injection queries are issued as SQL commands to an Aurora instance. Exam Alert: Fault injection queries can be only used with Aurora DB cluster and NOT with an RDS DB cluster.
upvoted 18 times
...
MultiAZ
Most Recent 1 year, 6 months ago
Selected Answer: B
Answer is B. Oracle does not support fault injection queries
upvoted 1 times
...
Pranava_GCP
1 year, 10 months ago
Selected Answer: B
B. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RebootInstance.html " Rebooting with failover is beneficial when you want to simulate a failure of a DB instance for testing, or restore operations to the original AZ after a failover occurs"
upvoted 3 times
...
Germaneli
1 year, 10 months ago
Selected Answer: D
A is irrelevant (no software-related change planned). B is possible, but the requirement mentions a "simulation", not actually doing it. C - fault injection is feasible only on Aurora, not on RDS for Oracle. D fulfills the requirement, which is to *simulate* an AZ failure (not only a failover of the database). So I'd vote for that.
upvoted 1 times
...
mraronsimon
2 years ago
Selected Answer: B
Exam Alert: Fault injection queries can be only used with Aurora DB cluster and NOT with an RDS DB cluster.
upvoted 1 times
...
Pankaj24hrs
2 years, 2 months ago
C - As question as to simulate AZ not doing it manually.
upvoted 1 times
...
ken_test1234
2 years, 3 months ago
Selected Answer: B
Because the fault injection queries wiil take too much time to fail the engine
upvoted 1 times
...
im_not_robot
2 years, 5 months ago
Selected Answer: B
A is not relevant. B is correct because it is fast to do C is incorrect because it is slower than B D is incorrect because it affects the whole subnets with multiple resources like ec2, alb,...
upvoted 1 times
...
lollyj
2 years, 7 months ago
Selected Answer: B
B is the correct option.
upvoted 1 times
...
novice_expert
3 years, 2 months ago
Selected Answer: B
reboot with failover option. You can force a crash of an Amazon Aurora instance using the ALTER SYSTEM CRASH fault injection query.
upvoted 3 times
...
tugboat
3 years, 4 months ago
Selected Answer: B
Test for failover is done via reboot with failover
upvoted 3 times
...
Shunpin
3 years, 6 months ago
I prefer B. My point is that you can't simulate real application behaviors. For example in JDBC connection, if the TCP socket disconnect detection is not in the java coder. Your connection is stuck while failover.
upvoted 3 times
...
jove
3 years, 8 months ago
It seems the RDS fault injection queries are supported only on Aurora : https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.FaultInjectionQueries.html So, for testing Oracle, B should be the correct option.
upvoted 4 times
leunamE
3 years, 8 months ago
Yes, but even if it's Aurora instead of RDS, I think the key is that the question says they want to test how the application behaves during DB instance failover activity. in this case it is always the reboot with failover option.
upvoted 1 times
...
2025flakyt
3 years, 7 months ago
Although B is the correct answer for HA testing but RDS also support fault injection https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/disaster-recovery-resiliency.html https://wellarchitectedlabs.com/reliability/300_labs/300_testing_for_resiliency_of_ec2_rds_and_s3/
upvoted 1 times
Germaneli
1 year, 10 months ago
RDS for Oracle doesn't support fault injection, and on the provided links this is also not confirmed.
upvoted 1 times
...
...
...
leunamE
3 years, 8 months ago
Option B.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel