• My first reading of the third option -- Useful in a targeted security environment -- made me think of a potential disadvantage.

    Targeted, in the answers, was referring to selecting which columns required encryption and which do not.

    It got me thinking, that if columns with a limited domain are encrypted, that might actually provide an attack vector.

    Useful question...