SnowPro Advanced: Data Engineer — Question 111

A company using Snowflake works with a third party that provides economic data. The third-party provider recently moved their data to Snowflake.

How can the company access the third-party data in Snowflake with the LEAST amount of operational overhead?

Answer options

• A. Have the data provider enable database replication so the company can create a replica of the provider's database.
• B. Have the data provider create a share object and add the company's Snowflake account to the share.
• C. Have the data provider create a listing on the Snowflake Marketplace so the company can request access to the data.
• D. Have the data provider create a new user and role specifically for the company so the company can log into the data provider's Snowflake account to access the data.

Correct answer: B

Explanation

The correct answer is B because creating a share allows for seamless access to the third-party data without the need for complex replication or user management. Options A, C, and D involve more operational overhead, such as managing replicas or requiring additional access requests or account setups.