nerdexam
Snowflake

COF-C02 · Question #230

How can a data provider ensure that a data consumer is going to have access to the required objects?

The correct answer is A. Enable the data sharing feature in the account and validate the view. To share data with a consumer, the provider must enable the data sharing feature in their Snowflake account and validate that the shared views or objects are accessible. Snowflake's secure data sharing uses a reader account or direct sharing mechanism. Validating the view…

Data Protection and Data Sharing

Question

How can a data provider ensure that a data consumer is going to have access to the required objects?

Options

  • AEnable the data sharing feature in the account and validate the view.
  • BUse the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
  • CUse the CURRENT_ function to authorize users from a specific account to access rows in a base
  • DSet the SIMULATED DATA SHARING CONSUMER session parameter to the name of the

How the community answered

(28 responses)
  • A
    93% (26)
  • C
    4% (1)
  • D
    4% (1)

Explanation

To share data with a consumer, the provider must enable the data sharing feature in their Snowflake account and validate that the shared views or objects are accessible. Snowflake's secure data sharing uses a reader account or direct sharing mechanism. Validating the view ensures the consumer account can correctly access and query the shared objects before the share goes live.

Topics

#Data Sharing#Data Provider#Consumer Access#Shared Objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice