Comprehensive and Detailed Explanation:
The correct answer is A - Set up and pull data from a SendLog Archive Data Extension.
* To keep SendLogs manageable, best practice is to archive older data periodically to a different data extension.
* This allows marketers to pull data for analysis without affecting the live SendLog performance.
* Queries can then target the Archive DE based on email address for troubleshooting.
#Why others are wrong:
* B: Filtering on a massive SendLog DE without archiving is inefficient and slow.
* C: Data Views (_Sent, _Subscriber) only store general send tracking data, not full SendLog personalization snapshots.
* D: Tracking Extracts are for broader system tracking (sent, opens, clicks), not detailed troubleshooting with personalization.
Exact Extract from Salesforce Official Documentation:
Salesforce Help - SendLog Management Best Practices:
"To maintain optimal performance, implement archiving for SendLog data by moving old records to archive Data Extensions at regular intervals." (Source:https://help.salesforce.com/s/articleView?id=sf.mc_es_sendlog_best_practices.htm)
-