Data lifecycle & deletion propagation: deleting that row from the primary DB doesn't mean the data is actually gone
In one sentence govern by "data lineage + deletion propagation," and don't read "deleted from the primary DB" as "deleted" — that's the most common false security here.