If you want 'Are you sure?' as a column for query results in a T-SQL query you have to enclose it in single quotes.

Spaces and question marks do not otherwise play nicely with column names.

SELECT Affirmation, SignOff as 'Are you sure?'
FROM Whatever