just to add my own experience, I bought my car new with 17 miles on it, picked it up a month ago, I believe my car was built around sept 2024 or later.
P2CEF came on around 975 miles on the odo, started the car up and didn't even make it out a block. I was literally taking the car out to finish the 1000 mile break-in. I cleared the code. It has not come back since, I've driven roughly 200miles on it so far. I hope it's a VERY small amount of sand and is just stuck somewhere now and doesn't restrict any flow or get my thermostats stuck.... I can live with it just being stuck somewhere and not flowing around.... I really don't want to have to take it in to the dealer to let them take 2 months to diagnose or have to do a full flush in attempt to get the sand out.
Or even better, hope it was just a fluke, but i doubt it.