The cheap-looking boots ___ to be waterproof during the storm.
Erklärung
Turned out introduces the final discovery that the boots really were waterproof despite appearances. Turned up would describe arrival or an increase, neither of which can express the discovered result.