Answer: SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

The question asks which command shows all privileges granted to the schema ANALYTICS_DW.MARKETING. Option B, 'SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING', is correct because it directly queries grants on the specified schema object, listing all privileges (including OWNERSHIP held by DATA_SCIENCE) assigned to it. The community discussion unanimously supports B with 100% agreement and upvoted comments referencing Snowflake documentation, confirming this syntax. Option A is incorrect as it queries grants on a role, not the schema. Option C is incorrect as it shows grants to a user, not the schema. Option D is incorrect because 'SHOW GRANTS OF ROLE' is not valid Snowflake syntax; the correct variant for roles is 'SHOW GRANTS TO ROLE'.

Author: LeetQuiz Editorial Team