[SalesForce] How to recover deleted data extensions from Marketing Cloud

Unfortunately this isn’t supported as natively as you might want. Even on objects synchronised from Sales Cloud, fields that are pick lists in SC are only provided as text fields in MC.

You will need to do some custom configuration, where you create a separate DE, holding all the options for your pick list fields, and reference it in e.g. Cloud Pages, using LookupOrderedRows to populate drop down input field options.

If this is the use case you are in need of supporting, I can elaborate more on the solution if needed. If you need the pick list values to be available within MC, e.g. when working with Data Extensions in Contact Builder - I’m afraid there is not much we can do there.

Deleting a contact in SFDC will not automatically trigger a delete of the Contact in SFMC. Although there has been great progress in integrating these tools, such core concepts are still split. Deleting a contact in SFDC should remove the contact from the Synchronized Data Extension, which means that you can cannot rely on the isDeleted flag to be set as the entire record would likely be gone.

Generally, I would say you have three basic options

1. Run a query to calculate which contacts are in your All Subscribers (and MobileConnect Demographics and MobilePush Demographics if you use those) compare with who is in your Contact synchronized data extension. Then once every week/month you run a manual delete request -> https://help.salesforce.com/articleView?id=mc_cab_delete_contact.htm&type=5
2. Create a SSJS activity which triggers a delete using Contact Key or List (as calculated in 1) once per hour/day/etc to the API -> https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-apis.meta/mc-apis/restrict-contact-key.htm
3. Trigger the above mentioned API as part of an onDelete trigger in SFDC (I would usually go with this one)