The Yammer files get stored on SharePoint if you are in Microsoft 365-connected groups. However, for those on Yammer basic network or without Microsoft 365 connected groups, the files are stored on the Yammer cloud.