Exam AWS Certified Database - Specialty topic 1 question 180 discussion

ZeroDowntime patching wont work if any of the following is true: - Binary Logging is Enabled - Long Running queries/transactions are in progress - Temporary Tables are in use - Table Locks are in use - SSL connections are Open By Elimination The answer is (D) - which actually makes sense since it makes no difference to patching.

I think its A In Aurora MySQL 2.10 and higher, Aurora can perform a zero-downtime patch when binary log replication is enabled. Aurora MySQL automatically drops the connection to the binlog target during a ZDP operation. Aurora MySQL automatically reconnects to the binlog target and resumes replication after the restart finishes. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html

A. Binary logging is enabled, or binary log replication is in progress. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html "In Aurora MySQL version 2.10 and higher and version 3, Aurora can perform a zero-downtime patch whether or not binary log replication is enabled. If binary log replication is enabled, Aurora MySQL automatically drops the connection to the binlog target during a ZDP operation. Aurora MySQL automatically reconnects to the binlog target and resumes replication after the restart finishes."

Answer is A. ZDP might not complete successfully under the following conditions: Long-running queries or transactions are in progress. If Aurora can perform ZDP in this case, any open transactions are canceled. Open Secure Socket Layer (SSL) connections exist. Temporary tables or table locks are in use, for example while data definition language (DDL) statements run. If Aurora can perform ZDP in this case, any open transactions are canceled. Pending parameter changes exist. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.Patching.html

if question likes : Which element will have tnothing on ZDP's success. so we can easliy asnswer .

MINIMUM influence os key to answer question

A. Binary logging is enabled, or binary log replication is in progress. (used to block before MySQL 2.10, no longer affects ZDP ) x B. Current SSL connections are open to the database. (affects ZDP) C. Temporary tables or table locks are in use.(affects ZDP) D. The value of the lower_case_table_names server parameter was set to 0 when the tables were created. (unrelated to ZDP)

I think D has no influence on ZDP's success and B and C has major influence, so, A should have the minimum influence.. Thoughts?