The adopted building code decides.
For example, if the jurisdiction adopted the IBC, then Chapter 27 lists those items that are Emergency (Article 700) and Standby (Article 701). Fire Pump is not listed individually in Chapter 27 directly. Indirectly, if you have a High Rise for example, you are directed to go to Section 403.4.8 where you would see electrically powered fire pumps listed under Emergency Power Loads in Section 403.4.8.4. If you have a fire pump for a different type of occupancy than a high rise, such as an Underground building, you would get pushed to Section 405.8, and the same result.
If you were in a regular Business low rise building with a fire pump, then no Emergency (or legally required) source required.
Local amendments override of course.