The correct answer is not provided in the possible options.

According to the link provided as proof of the answer, it expressly indicates that the "CORRECT" answer is not...

Perhaps this will provide what you are looking for 
sys.dm_exec_describe_first_result_set_for_object

You need to create an additional variable with forced values for the NULLS.

--Create the dynamic date columns string
declare @cols AS NVARCHAR(MAX)
declare @vals AS NVARCHAR(MAX)

This seems to be the simplest form of the OP's requirement.

SELECT columns
FROM table
WHERE TYPE <> 14
 OR VISIBLE = 0;


Reported as spam

Is the index on a UNIQUEIDENTIFIER column?