DBS-C01 · Question #190
DBS-C01 Question #190: Real Exam Question with Answer & Explanation
The correct answer is D: The value of the lower_case_table_names server parameter was set to 0 when the tables were. 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 OpenPatching.html
Question
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?
Options
- ABinary logging is enabled, or binary log replication is in progress.
- BCurrent SSL connections are open to the database.
- CTemporary tables or table locks are in use.
- DThe value of the lower_case_table_names server parameter was set to 0 when the tables were
Explanation
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 OpenPatching.html
Topics
Community Discussion
No community discussion yet for this question.