Snowflake Exam COF-C02 Topic 1 Question 30 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 30
Topic #: 1

[All COF-C02 Questions]

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

1 years 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

...

1 years 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

...

1 years ago

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

upvoted 0 times

...

1 years ago

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

upvoted 0 times

...

1 years ago

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

upvoted 0 times

...

1 years ago

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

upvoted 0 times

...