Exam SOL-C01 Topic 1 Question 261 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 261
Topic #: 1

You have a custom role named 'TRANSFORM ROLE that needs to load data into a table called
'ORDERS'. You want to ensure that this role can only load data into this specific table and has no other privileges. The table is located in database 'SALES DB' and schema 'PUBLIC'. Which of the following grants provides the LEAST PRIVILEGED access required for 'TRANSFORM ROLE' to perform the data load operation using COPY INTO command?

A. GRANT INSERT, SELECT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE; B. GRANT ALL PRIVILEGES ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE; C. GRANT INSERT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE; D. GRANT OWNERSHIP ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE; E. GRANT INSERT ON TABLE SALES DB.PUBLIC.ORDERS TO ROLE TRANSFORM ROLE; GRANT USAGE ON DATABASE SALES DB TO ROLE TRANSFORM ROLE; GRANT USAGE ON SCHEMA SALES DB.PUBLIC TO ROLE TRANSFORM ROLE;

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business