When does Dataverse win over SharePoint?

A colleague is starting a new Power Apps project. They have 50,000 records across four related tables, Tickets, Users, Departments, and SchoolSites, with role-based security needed so technicians at one site can only see tickets for that site.

Which data backend should they pick?