SOL-C01 Question #228: Real Exam Question with Answer & Explanation

Question

A data provider wants to share a secure view 'SECURE VIEW SALES' from database 'DB RETAIL' to a consumer account using a private listing within the Snowflake Data Exchange. The provider has already created the listing. Which of the following steps are necessary to grant the consumer access, assuming the consumer account identifier is 'XYZ 12345'?

Options

• AGrant the 'IMPORTED PRIVILEGES' privilege on the share to the account `XYZ12345'.
• BGrant 'SELECT' privilege on the share to the account 'XYZ12345.
• CGrant the `IMPORTED PRIVILEGES privilege on the database created from the share to a role
• DAdd the consumer account 'XYZ12345 to the listing from the Data Exchange provider interface.
• ECreate a new role, grant 'SELECT on to the role, and grant that role to the consumer account

Explanation

Adding the consumer account to the private listing from the Data Exchange provider interface is the action that allows the consumer to access the share. The other options are not directly related to providing access via a private listing within the Data Exchange. Granting privileges on the share is typically done for direct shares, not data exchange shares. Consumers consume the whole shared database.

No community discussion yet for this question.