nerdexam
Snowflake

COF-C02 · Question #662

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

The correct answer is A. Via the Snowflake Web Interface (Ul) C. Via SQL commands. Snowflake Data Shares can be created and managed through the Snowflake Web UI (Snowsight) or via SQL DDL commands such as CREATE SHARE, ALTER SHARE, and GRANT <privilege> ON <object> TO SHARE. There is no 'data_share=true' parameter in Snowflake. Virtual Warehouses are compute…

Data Protection and Data Sharing

Question

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Options

  • AVia the Snowflake Web Interface (Ul)
  • BVia the data_share=true parameter
  • CVia SQL commands
  • DVia Virtual Warehouses

How the community answered

(34 responses)
  • A
    94% (32)
  • B
    3% (1)
  • D
    3% (1)

Explanation

Snowflake Data Shares can be created and managed through the Snowflake Web UI (Snowsight) or via SQL DDL commands such as CREATE SHARE, ALTER SHARE, and GRANT <privilege> ON <object> TO SHARE. There is no 'data_share=true' parameter in Snowflake. Virtual Warehouses are compute resources used for query execution and have no role in creating or managing data shares.

Topics

#Data Sharing#Snowflake Web Interface#SQL#Data Management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice