Exam SOL-C01 Topic 1 Question 101 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 101
Topic #: 1
You have created a custom role called `ANALYST ROLE in Snowflake. You want to grant this role the ability to create views in the 'REPORTING SCHEMA' schema of the 'ANALYTICS' database and query these views. Which set of privileges must be granted to the 'ANALYST ROLE'?

Suggested Answer: E Vote an answer

To create views, the 'CREATE VIEW privilege is required on the schema. To query the created views, the `SELECT privilege is needed. Using 'ON FUTURE VIEWS' ensures that the role automatically has 'SELECT privileges on any new views created in that schema. The USAGE' privilege is also required on the schema in order to access objects within that schema.

by Ted at Nov 07, 2025, 11:10 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10