AWS Certified Database – Specialty – Question180

A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database.
Multiple processing applications are using SSL certificates to connect to database endpoints and the read replicas.
Which factor will have the LEAST impact on the success of ZDP?

A.
Binary logging is enabled, or binary log replication is in progress.
B. Current SSL connections are open to the database.
C. Temporary tables or table locks are in use.
D. The value of the lower_case_table_names server parameter was set to 0 when the tables were created.

Correct Answer: A

Explanation:

Explanation:
Aurora MySQL 2.10 and higher, Aurora can perform a zero-downtime patch when binary log replication is enabled.
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora…