Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?

Digital Marketing, LinkedIn Amazon Web Services (AWS) Skill Quiz Answers

You no longer need to be worried if you are taking the LinkedIn Amazon Web Services (AWS) Skill Quiz Exam and are unsure about the proper answer to the question “Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?”. I have provided the right answer to your question below.

Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?

Options

  • The server running the .NET utilities is caching the DNS lookup on the database cluster address. Flush the DNS cache of the server and force the C# utilities to open new connections to the database.
  • The NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database server using a try/catch.
  • Use the RDS console to force a reboot of the database instance so that the primary server becomes the master server again.
  • A.NET application will retain the IP address of a connection string until the host machine is rebooted.

The Correct Answer Is:

  • The NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database server using a try/catch.

Conclusion

I believe I was successful in answering your query “Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?”. I hope you easily pass the certification exam and get the certificate as soon as possible. Have a great time! Good luck!