AWS Certified Database – Specialty — Question 171

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?

Answer options

• 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: D

Explanation

The lower_case_table_names server parameter being set to 0 has minimal influence on the ZDP process, as it primarily affects case sensitivity in table names rather than database operation during patching. In contrast, factors like binary logging, open SSL connections, and the use of temporary tables or locks directly impact the database's ability to perform updates without downtime.