In Cubesats, DVB-S2 and CCSDS are both equally present as communications standards.
Are there really any pros and cons, that is - a "best choice for a given application", or are they just standards that have birthed and grown isolated from eachother and have pretty much the same performance and coverage?