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.
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.
Latest DEA-C01 Dumps Valid Version with 100 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund