Snowflake Exam COF-C02 Topic 1 Question 30 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 30
Topic #: 1

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

AUSAGE on the specific tables in the database.

BUSAGE on the specific tables in the database.

CMODIFY on 1Mb specific tables in the database.

DUSAGE on the database and the schema containing the tables to share

EOPEBATE on the database and the schema containing the tables to share.

Show Suggested Answer

Suggested Answer: C, D

by Cora at May 03, 2024, 02:38 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

7 months ago

Makes sense. So, D for database and schema, and B for the specific tables. That’s what I'd go with.

upvoted 0 times

...

7 months ago

Exactly. Without USAGE on the database and schema, the tables can’t be accessed even if you have table-specific USAGE.

upvoted 0 times

...

7 months ago

Yeah, I agree with B. But isn’t D about needing access to the overall database and schema?

upvoted 0 times

...

7 months ago

I think the right answers are D and B. USAGE on the database and schema, and USAGE on tables.

upvoted 0 times

...

7 months ago

It’s a bit confusing. Seems like they want to know the required privileges for sharing data.

upvoted 0 times

...

8 months ago

Hey, what do you think about this question on Snowflake privileges?

upvoted 0 times

...