If you take a MCP6274 with a unity gain bandwidth of 2MHz, then you have no gain reserve at 2MHz. At 200kHz you have a gain reserve of factor 10, at 20kHz a gain resreve of factor 100, and so on. To make your OPamp work properly you must have a gain reserve of at least a factor of 10, better a factor of 100, at the highest frequency of interest (sine signals assumed!). So, if you plan to handle frequencies up to 100kHz, you can install only a gain of about factor 2 with your OPamp circuit containing the MCP6274. Then you will have a gain reserve of about factor 10 at 100kHz. Higher gains cannot be accomplished by the MCP6274 at 100kHz without ruining the signal integrity.

So, how much gain can be installed at 100kHz depends on the bandwidth of OPamp. An OPamp with 10MHz unity gain bandwidth has a gain reserve of 10MHz/100kHz=100 at 100kHz. So, a gain of factor 10 can be installed at 100kHz. Using such an OPamp only one gain stage would be sufficient to provide a gain of 8 (see above).

Things get worse, if your signal isn't a sine but has harmonics, like a square wave or else. In such a case you would need sufficient gain reserve even for the harmonics and your OPamp should be faster by at least a factor of about 10 than when only handling 100kHz sines.