SnowPro Advanced: Architect — Question 97

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?

Answer options

• A. Ask the partner to create a share and add the company's account.
• B. Ask the partner to use the data lake export feature and place the data into cloud storage where Snowflake can natively ingest it (schema-on-read).
• C. Keep the current structure but request that the partner stop changing files, instead only appending new files.
• D. Ask the partner to set up a Snowflake reader account and use that account to get the data for ingestion.

Correct answer: A

Explanation

The most efficient solution is to ask the partner to create a share and add the company's account, as it allows direct access to the data without the need for manual uploads or changes. The other options either complicate the process, require additional steps, or do not address the need for efficiency in data access.