You asked
Is the nikon z5 ii good in low light?
The Nikon Z5 II is a full frame camera, and that's the main reason it does well in dim conditions. A bigger sensor collects more light at the same framing and f-number, so images stay cleaner at high ISO. Full frame has roughly a stop of advantage over APS-C, which adds up quickly when the light drops.
Low light also depends heavily on the lens. A fast prime gathers far more light than a slow kit zoom, and a 50mm f/1.8 is one of the cheapest ways to get there. The Z5 II's Nikon Z mount has plenty of options, including the Nikon Z 35mm f/1.8 S and Nikon Z 50mm f/1.8 S, both good starting points for dim rooms and events.
If you want the reasoning behind all this, see Sensor sizes and Lenses.
Written by Claude from this site's pages.