I think that this is a pretty good question. But asking which answer is "most correct" is asking for a judgement call, rather than just for knowledge of a fact, so some people may claim it is not a good question - but DBAs and developers have to make judgement calls every day, so why shouldn't a QotD require one?

I picked the "they will still work" option over "they won't work because it has changed" because although neither is absolutely correct I believe that "it will work" will be true far more often than not. Why should I expect to create or delete collections in an MDS staging process? Surely once that has been done the process is staging the data as required, it shouldn't ever need to do that. Much the same applies to to reactivating deactivated collections and to reactivating deactivated members or adding members to or removing members from collections. So while some staging processes in SQL Server2008R2 may have done some of those things, and thus won't work in 2014, it's going to be much more common that the processes that need to be carried forward to the latest release don't do any of those things, so there's no reason they won't work.