Which DDL/DML operation is allowed on an inbound data share?

The correct answer is D. SELECT. Inbound data shares grant read-only access to a consumer account. The only SQL operation permitted on objects within a share is SELECT - consumers can query the shared data but cannot modify it in any way. Write operations such as INSERT INTO (option B), MERGE (option C), and…

Data Protection and Data Sharing

Question

Options

AALTER TA3LE
BINSERT INTO
CMERGE
DSELECT

How the community answered

(26 responses)

B
4% (1)
C
4% (1)
D
92% (24)

Explanation

Inbound data shares grant read-only access to a consumer account. The only SQL operation permitted on objects within a share is SELECT - consumers can query the shared data but cannot modify it in any way. Write operations such as INSERT INTO (option B), MERGE (option C), and schema modifications like ALTER TABLE (option A) are all prohibited. This restriction protects the data provider's source data and enforces the one-way nature of data sharing in Snowflake.

Topics

#Data Sharing#Inbound Share#Read-Only Data#DML Operations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice