Nikon D780 has a
25.0MP Full frame (35.9 x 23.9 mm ) sized BSI-CMOS sensor and features Expeed 6 processor. On the other hand, Sony A9 II has a
24.0MP Full frame (35.6 x 23.8 mm ) sized Stacked BSI-CMOS sensor and features BIONZ X processor.
Below you can see the D780 and A9 Mark II sensor size comparison.
Sensor Size and Resolution Comparison image of Nikon D780 and Sony A9 II Cameras
Nikon D780 and Sony A9 II have almost the same sensor size, so neither of them has any significant advantage over the other in terms of providing control over depth of field when used with the same focal length and aperture.
Sensor size sets the circle of confusion, so it drives how much depth of field each
of these bodies gives you at a given aperture. You can calculate it exactly for the
Nikon D780
or the
Sony A9 II ,
including hyperfocal distance.