MENU
When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).
Suggested Answer: C, D
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
24 comments · newest first
CO
Cordell
11 months ago
USAGE is a must, but I’m not sure about the second one.
EL
Elouise
11 months ago
Wait, is OPEBATE even a real privilege? Sounds off.
LE
Lenita
11 months ago
Definitely USAGE on the specific tables!
EV
Evangelina
11 months ago
I thought MODIFY was necessary too, but I guess not!
TO
Tommy
11 months ago
You need USAGE on the database and schema for sure.
KA
Kandis
12 months ago
I feel like both USAGE on the database and schema are correct, but I can't recall if we need anything else.
MA
Marion
12 months ago
I’m a bit confused; I thought MODIFY was important, but it seems like it’s not relevant here.
AR
Ardella
12 months ago
I remember practicing a question like this, and I think USAGE is definitely one of the privileges we need.
CH
Chaya
1 year ago
I think we need USAGE on the database and schema, but I'm not sure about the tables.
HI
Hildred
1 year ago
This seems straightforward. The provider needs to grant USAGE on the specific tables and the database/schema containing the tables. I'll select those two options.
MA
Marleen
1 year ago
I'm a bit confused by the wording of the question. Can the provider grant privileges on just the tables, or do they need to grant privileges on the entire database and schema as well?
FE
Fernanda
1 year ago
Okay, let's see. I think the key is understanding the difference between USAGE and MODIFY privileges. I'll need to review that before answering.
JA
Jarod
1 year ago
Hmm, this is a tricky one. I'll need to think carefully about the privileges required for sharing data in Snowflake.
CA
Carlee
1 year ago
I'm pretty confident I know the answer to this one. The provider needs to grant USAGE on the specific tables and the database/schema containing the tables.
CA
Carmela
1 year ago
Hmm, I'm not totally sure about this one. I think it might be A, but I'm also considering D, proving that nothing about your identity has been altered. I'll have to think it through a bit more.
FR
Freeman
1 year ago
This looks like a tricky question on subqueries. I'll need to carefully read through each option and think about the different ways subqueries can be used.
LA
Lashonda
1 year ago
This seems like a tricky one. I'll need to think through the impact on the different ratios carefully.
KA
Katina
1 year ago
I'm not totally sure, but I remember the caret (^) is usually for the start of a line. Maybe that helps?
NA
Natalie
2 years ago
Makes sense. So, D for database and schema, and B for the specific tables. That’s what I'd go with.
AR
Art
2 years ago
Exactly. Without USAGE on the database and schema, the tables can’t be accessed even if you have table-specific USAGE.
JE
Jesusita
2 years ago
Yeah, I agree with B. But isn’t D about needing access to the overall database and schema?
NA
Natalie
2 years ago
I think the right answers are D and B. USAGE on the database and schema, and USAGE on tables.
JU
Juliana
2 years ago
It’s a bit confusing. Seems like they want to know the required privileges for sharing data.
JE
Jesusita
2 years ago
Hey, what do you think about this question on Snowflake privileges?