ARA-C01 Question #48: Real Exam Question with Answer & Explanation

Question

A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes. What would be the MOST efficient solution?

Options

• AAsk the partner to create a share and add the company's account.
• BAsk the partner to use the data lake export feature and place the data into cloud storage where
• CKeep the current structure but request that the partner stop changing files, instead only appending
• DAsk the partner to set up a Snowflake reader account and use that account to get the data for

Explanation

The most efficient solution is to ask the partner to create a share and add the company's account (Option A). This way, the company can access the live data from the partner without any data movement or manual intervention. Snowflake's secure data sharing feature allows data providers to share selected objects in a database with other Snowflake accounts. The shared data is read- only and does not incur any storage or compute costs for the data consumers. The data consumers can query the shared data directly or create local copies of the shared objects in their

No community discussion yet for this question.