from employee where role = current_role();

from employee where role = current_role();
A . Only users with the desired role will be able to retrieve results from the view
B. Only users with the correct role assigned and SYSADMIN will be able to retrieve the results from the view
C. The operation will error out since the function used is a non-deterministic one.

View Answer

Answer: C

Explanation

It will error out with the below message

SQL compilation error: error line 3 at position 33 Invalid materialized view definition. non deterministic function ‘CURRENT_ROLE’ not allowed in view definition.

https://docs.snowflake.com/en/user-guide/views-materialized.html#limitations-on-creating-materialized-views Functions used in a materialized view must be deterministic. For example, using CURRENT_TIME or CURRENT_TIMESTAMP is not permitted.