Scenario reduction revisited: fundamental limits and guarantees