What are ways to create and manage data shares in Snowflake? (Select TWO)

The correct answer is A. Through the Snowflake web interface (Ul) C. Through SQL commands. Snowflake data shares can be created and managed in two primary ways: through the Snowflake web UI (Snowsight) and through SQL commands such as CREATE SHARE, ALTER SHARE, DROP SHARE, and GRANT/REVOKE on a share. Option B (DATA_SHARE=TRUE) is a fabricated parameter that does not…

Data Protection and Data Sharing

Question

Options

AThrough the Snowflake web interface (Ul)
BThrough the DATA_SHARE=TRUE parameter
CThrough SQL commands
DThrough the enable__share=true parameter
EUsing the CREATE SHARE AS SELECT * TABLE command

How the community answered

(17 responses)

A
94% (16)
E
6% (1)

Explanation

Snowflake data shares can be created and managed in two primary ways: through the Snowflake web UI (Snowsight) and through SQL commands such as CREATE SHARE, ALTER SHARE, DROP SHARE, and GRANT/REVOKE on a share. Option B (DATA_SHARE=TRUE) is a fabricated parameter that does not exist. Option D (enable__share=true) is also a fabricated parameter. Option E (CREATE SHARE AS SELECT * TABLE) is not valid SQL syntax in Snowflake - you cannot define share content inline in a CREATE SHARE statement; you must separately add objects to a share using GRANT ... TO SHARE.

Topics

#Data Sharing#Share Management#Snowflake UI#SQL Commands

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice