U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-C03 Exam - Topic 2 Question 3 Discussion

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.Which command will show all privileges granted to that schema?
B) SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
A) SHOW GRANTS ON ROLE DATA_SCIENCE
C) SHOW GRANTS TO USER INQUISITIVE_PERSON
D) SHOW GRANTS OF ROLE DATA_SCIENCE

Snowflake COF-C03 Exam - Topic 2 Question 3 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 3
Topic #: 2
[All COF-C03 Questions]

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Show Suggested Answer Hide Answer
Suggested Answer: B

To showall privileges granted to a specific schema, the commandSHOW GRANTS ON SCHEMA <schema_name>should beused3. In this case, it would beSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. Reference: [COF-C03] SnowPro Core Certification Exam Study Guide


by Stefany at Jul 02, 2026, 12:25 AM

Limited Time Offer

25%

Off

Get Premium COF-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel