these are the same questions our compliance team asked. checking the docs and reaching out to support helped. from what i can tell data is encrypted at rest and they have DPA agreements available. for automatic deletion you can build a workflow that runs on a schedule and deletes records older than your retention period
for right to erasure we built a workflow triggered by a form where the user enters their email. the workflow searches all tables for that email, exports the data, sends it to the user, then deletes the records. took a day to build but now its fully automated
the automated erasure workflow is clever. we need something similar for our CCPA compliance