Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake ADA-C01 Exam - Topic 4 Question 55 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 55
Topic #: 4

[All ADA-C01 Questions]

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

ADatabase: Usage
Schema: Usage
Table: Select, Create Stream

BDatabase: Usage
Schema: Usage
Table: Select

CDatabase: Usage, Create Stream
Schema: Usage
Table: Select

DDatabase: Usage
Schema: Usage, Create Stream
Table: Select

Show Suggested Answer

Suggested Answer: A

by Tomas at Jun 21, 2026, 05:35 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jannette

2 days ago

Definitely D), can't manage streams without Create Stream!

upvoted 0 times

...

Carisa

7 days ago

I think B) is missing something important.

upvoted 0 times

...

Dorothy

12 days ago

A) is correct, you need Create Stream on the table.

upvoted 0 times

...

Suzan

18 days ago

I believe it’s definitely A or D since both include the necessary grants for managing streams, but I can't recall which one is correct.

upvoted 0 times

...

Stevie

23 days ago

I’m a bit confused; I thought you only needed usage on the database and schema, but now I’m not sure if select is enough for the table.

upvoted 0 times

...

Chuck

28 days ago

I remember practicing a similar question, and I feel like the correct answer should include "Create Stream" at the table level.

upvoted 0 times

...

Nadine

1 month ago

I think the minimum grants needed are related to usage and select permissions, but I'm not entirely sure about the stream creation part.

upvoted 0 times

...