Which two statements are true about MySQL server multi-source replication? (Choose two.)
A.
It is not compatible with auto-positioning.
B.
It needs to be re-instanced after a crash to maintain consistency.
C.
It uses only time-based replication conflict resolution.
D.
It relies on relay_log_recovery for resilient operations.
E.
It does not attempt to detect or resolve replication conflicts.
F.
It must use GTID replication.
The Answer Is:
D, E
This question includes an explanation.
Explanation:
In a multi-source replication setup, MySQL relies on the relay_log_recovery option to enable or disable automatic relay log recovery just after server startup, which helps in resilient operations. Also, MySQL does not have a built-in mechanism to detect or resolve conflicts if the same data is modified by transactions from different sources. It’s the responsibility of the database administrators to ensure that the data modified by each source is distinct to avoid conflicts.
1z0-908 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"