Exit DEA-C01 SnowPro Advanced: Data Engineer Certification (DEA-C01)
Question 1 of 5
0% complete
Q1 Single choice

A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA right to use this stored procedure.

What is a characteristic of the stored procedure being called using ROLEA?

  • A

    The stored procedure must run with caller's rights it cannot be converted later to run with owner's rights

  • B

    If the stored procedure accesses an object that ROLEA does not have access to the stored procedure will fail

  • C

    The stored procedure will run in the context (database and schema) where the owner created the stored procedure

  • D

    ROLEA will not be able to see the source code for the stored procedure even though the role has usage privileges on the stored procedure

Previous Next