You will get Video + Audio from the 6900XT USB-C port. The video will run through USB-C Alt mode (DisplayPort video). However for some reason audio doesn't come out of the USBC port under macOS with the 6900XT, probably related to the lack of audio drivers in macOS, since it works fine in Windows. You also won't get data out of it, which is why a single cable going to a Studio Display doesn't allow you to use the displays special features like Webcam, monitor control (brightness/audio), display speakers, USBC hub, or anything related to Thunderbolt.
The workaround is the cable I provided. It passes DisplayPort data into the monitor via USBC and the extra USB cable allows you to also use the built in monitor features. You connect the DisplayPort + USB cable to the Mac Pro and the USBC end to the monitor. The only downside here as mentioned is that the data feature will be limited to USB2.0 so if your hub on the monitor is USB3.0 it will run slower. I personally don't care, I don't connect fast devices on the dual studio display hubs, I just connect things like DACs, USB mice receivers and a microphone. For anything faster like an SSD (Thunderbolt or USBC) I just connect directly to the Mac.
You will just need 1 of these cables if you have 1 of these monitors. 2 if you have 2 of them (like I have with dual Studio Displays). If you don't care about the hub, monitor speakers, monitor display controls etc, you can just run DisplayPort (6900XT) > Displayport (monitor) and get a video signal with no issues. But your hub and other things won't work.
A single Thunderbolt (or USBC) cable can run a lot of different types of data inside of it, that's why people get confused. You just have to find a workaround for what you're trying to do.
If you have a MPX card, no issues. If you have a MacBook Pro, no issues. If you have a Mac Studio, no issues. A single Thunderbolt cable will take care of everything, but not in your case since you have an OEM 6900XT. The card was not designed for a Mac, but it works because macOS has drivers for it.
I personally use the
Belkin version of this cable (2 of them) and have for years with no issues. I heard the one I sent previously works just as good but haven't personally tested. The Belkin cable used to be $60 you should be able to find it as well if you want to spend that much. I can definitely tell you that the Belkin one works since I use it daily. It has 2 USB cables vs 1 in the one I sent, so not sure what the difference is. I guess have to try it, Amazon has a good return policy.