Exam SOL-C01 Topic 1 Question 123 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 123
Topic #: 1
A data analyst needs to create a view named that aggregates sales data by month. The base table sales_transactions' contains columns 'transaction_id' , 'transaction_date' , and
'sales_amount' . The analyst wants to ensure that only users with the 'ANALYST' role can query this view. Which of the following SQL statements correctly creates the view and grants the necessary privileges?

Suggested Answer: B Vote an answer

Option B correctly creates or replaces the view to aggregate sales data by month and then grants the SELECT privilege on the view to the `ANALYST role, enabling them to query the view. Option A will fail if the view already exists. Option C incorrectly adds row access policy which is not necessary here. Option D is about Future grants and not correct here. Option E Creates a secure view, while correct is not the most optimal or requested answer to resolve the problem statement.

by Ryan at Nov 25, 2025, 11:21 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