COF-C02 Question 135

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  Users can see result sets from queries executed by other users when they are using the same role, because Snowflake result access is role-based in this case. Official Snowflake docs for RESULT_SCAN say that if a user is operating with the same role, they can use RESULT_SCAN to access query results. Snowflake stores query results for 24 hours.

• Chose B1

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations#viewing-query-results

• 1

  B False