Passive DVI to VGA adapters are for video cards that have integrated VGA functionality that is not exposed on a standard VGA connector, but is exposed on otherwise ununsed pins on the DVI-I connector . The passive adapter just links the VGA pins to those on a proper 15-pin VGA connector .
An active adapter will convert HDMI, DVI-D or Displayport signals to VGA using electronics and then expose the converted signal on a proper 15-pin VGA connector .
Newer video cards no longer have VGA functionality inside them and require an active adapter to generate the VGA signal .
Although it is possible to use an active adapter on a card that has VGA functionality through its DVI-I connector, there is typically no point as active adapters are more expensive .
TLDR : Kepler boards are old enough to still support VGA internally and will work with a passive adapter .