• Correct answer is "C", not "D".

    Clauses, WHEN MATCHED and WHEN NOT MATCHED are the standards as per ANSI.

    Microsoft extended these to WHEN NOT MATCHED BY SOURCE to make things more simpler for supporting some complex logic. But this clause does not involve Source tables and its columns. You can only use Target table columns here.