Multiple non-primary verticals are producing the same assets

[MilenaHristova]

Implementing #4157 revealed that there are assets which are not produced in the main vertical (Windows x64) but are produced in multiple other non-primary verticals

Examples:

 assets/symbols/FSharp.Compiler.Service.43.9.100-preview.24466.6.symbols.nupkg Produced by: AzureLinux_x64_Cross_Alpine_arm64, AzureLinux_x64_Cross_Alpine_arm, AzureLinux_x64_Cross_Alpine_x64, AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_arm64, AzureLinux_x64_Cross_x64, OSX_arm64, OSX_x64, Ubuntu2404_x64
assets/symbols/FSharp.Core.9.0.100-beta.24466.6.symbols.nupkg Produced by: AzureLinux_x64_Cross_Alpine_arm64, AzureLinux_x64_Cross_Alpine_arm, AzureLinux_x64_Cross_Alpine_x64, AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_arm64, AzureLinux_x64_Cross_x64, OSX_arm64, OSX_x64, Ubuntu2404_x64
assets/symbols/InteractiveHost32.Symbols.4.12.0-3.24463.1.symbols.nupkg Produced by: AzureLinux_x64_Cross_Alpine_arm64, AzureLinux_x64_Cross_Alpine_arm, AzureLinux_x64_Cross_Alpine_x64, AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_arm64, AzureLinux_x64_Cross_x64, OSX_arm64, OSX_x64, Ubuntu2404_x64
Microsoft.AspNetCore.App.Runtime.linux-arm Produced by: AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_Alpine_arm
aspnetcore/Runtime/9.0.0-rc.1.24414.4/aspnetcore-runtime-9.0.0-rc.1.24414.4-linux-arm.tar.gz Produced by: AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_Alpine_arm
aspnetcore/Runtime/9.0.0-rc.1.24414.4/aspnetcore-runtime-9.0.0-rc.1.24414.4-linux-arm.tar.gz.sha512 Produced by: AzureLinux_x64_Cross_arm, AzureLinux_x64_Cross_Alpine_arm

dotnet/sdk#43627 adds printing a list of duplicate assets at the end of the final join

We should investigate why assets are produced in multiple non-primary verticals and improve the selection in the final join point
(Some of the duplicates can be avoided by excluding full verticals from the final join)

[dotnet-issue-labeler]

I couldn't figure out the best area label to add to this issue. If you have write-permissions please help me learn by adding exactly one area label.

[dotnet-issue-labeler]

I couldn't figure out the best area label to add to this issue. If you have write-permissions please help me learn by adding exactly one area label.