Answer-first summary for fast verification
Answer: Through the Snowflake web interface (UI), Through SQL commands
The correct answers are A and C. In Snowflake, data shares can be created and managed through the Snowflake web interface (UI) using the 'Data Sharing' section, and through SQL commands such as CREATE SHARE, ALTER SHARE, and DROP SHARE. Option B (DATA_SHARE=TRUE parameter) is incorrect as no such parameter exists for creating shares. Option D (ENABLE_SHARE=TRUE parameter) is also incorrect; while there is an ENABLE_SHARE parameter, it is used for enabling share replication in replication groups, not for creating shares. Option E is invalid syntax; the correct SQL command is CREATE SHARE followed by GRANT statements to add objects to the share. The community discussion shows 100% consensus on AC with upvoted comments confirming these as the correct methods.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are two methods for creating and managing data shares in Snowflake?
A
Through the Snowflake web interface (UI)
B
Through the DATA_SHARE=TRUE parameter
C
Through SQL commands
D
Through the ENABLE_SHARE=TRUE parameter
E
Using the CREATE SHARE AS SELECT * FROM TABLE command
No comments yet.