Would this work with a reference GTX 970 at 1920x1080p @ 60Hz, or is an active adapter required?

I am the end user and this item worked great for what I needed it for. I am not a tech guy, so I have no idea as to what your question is, sorry I cant be of more help

What types of connectors are used in the Nippon Labs DP-DVI-3 cable?

The Nippon Labs DP-DVI-3 cable features a DisplayPort Male connector on one end and a DVI-D Male connector on the other end.

What is the maximum video resolution supported by the Nippon Labs DP-DVI-3 cable?

The maximum video resolution supported by the Nippon Labs DP-DVI-3 cable is 1920x1200 or 1080P (Full HD).

Questions & Answers: Nippon Labs DP-DVI-3 3 ft. DP DisplayPort Male to DVI-D Male Converter Cable, Black - DP to DVI Adapter - 1920 x 1200

(29)

double click image to zoom in

Shop All Nippon Labs Products

Nippon Labs DP-DVI-3 3 ft. DP DisplayPort Male to DVI-D Male Converter Cable, Black - DP to DVI Adapter - 1920 x 1200 - OEM

Connecting DisplayPort port compatible PCs to an HDTV, monitor, or projector with DVI port
Transmits high-definition video from your computer to an HDTV for video streaming or gaming; Connect and configure your monitor for an Extended Desktop or Mirrored Displays
Supports video resolutions up to 1920x1200 / 1080P (Full HD)
Gold-plated connectors, bare copper conductors, and foil & braid shielding combine together to provide both superior cable performance and reliable connectivity
DisplayPort to DVI cable transmits HD video from computer to display
Ideal for video streaming, gaming, or extending a workstation
Gold-plated connectors, bare copper conductors, and foil-and-braid shielding for reliable connectivity
Works with DP, DP++, and DisplayPort++; supports video resolutions up to 1920x1200 / 1080P (Full HD)

$15^.14 –