Not so much CPU frequency, but rather the maximum RAM frequency that the integrated memory controller can handle. It is only guaranteed to handle 2666MHz as per Intel specifications, anything above that, requires overclocking and is not guaranteed.
XMP is actually a factory overclocking preset, as mentioned earlier.
If you get a 9900K with a poor IMC, you may struggle to run particularly high RAM frequencies, while a different 9900K may allow you to run speeds above 4000MHz - this is just an example, there are tonnes of variables, but you get the idea.
But anything above 3600MHz and you might need to fiddle with RAM settings eventhough there's an XMP profile for them.
But the RAM you mention, should not require anything...