Used for shots with high-contrast.  The camera evaluates various aspects of the scene and applies the appropriate processing:

• reduces exposure
• highlights, shadows and mid-tones are then adjusted
• achieves optimal brightness

“Active” will adjusts the exposure before shooting to optimize the dynamic range, whereas regular D-Lighting option in the Retouch menu optimizes dynamic range in images after shooting.