SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 57

An Architect entered the following commands in sequence:

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

GRANT ROLE PUBLIC TO ROLE INTERN;

GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

Correct Answer: B, C

To allow USER1 to find the tables in the SANDBOX.PUBLIC schema using the Principle of Least Privilege, the Architect needs to provide the appropriate usage privileges. Granting USAGE on the database SANDBOX to the ROLE INTERN allows users with the INTERN role, including USER1, to connect to the database. Additionally, granting USAGE on the SANDBOX.PUBLIC schema to the ROLE INTERN allows these users to access the objects within the schema. Therefore, the correct commands are to grant usage on both the database and the schema to the role INTERN.

Discussion

hillcat111Options: BC

Answer is B,C and is validated

hillcat111Options: BC

Answer is correct B & C