Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
CD are correct
Correct Answer: C & D GRANT SELECT ON ALL TABLES IN SCHEMA <SCHEMA NAME> TO ROLE <ROLENAME>; GRANT SELECT ON FUTURE TABLES IN SCHEMA <SCHEMA NAME> TO ROLE <ROLENAME>; Source : https://docs.snowflake.com/en/sql-reference/sql/grant-privilege
They are asking for select only not modify so A will not be an answer, c & d os correct