• There is error. Correcty answer is 1 and 2. But 4 "Has no system data access or user data access." is correct when computed column marks as persisted and based on function, that will not have access to user/system tables.

    Does question "Creating indexes on computed columns" contain any about persisted ? - No.... I don't won 1 point.

    MS SQL 2008 MCITP x 3
    MS SQL 2012 MCSE x 2