Exam SnowPro Advanced Architect topic 1 question 82 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 82
Topic #: 1

[All SnowPro Advanced Architect Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by NachoPrendes at July 18, 2024, 10:55 a.m.

Comments

Submit Cancel

AleksM

1 week, 2 days ago

Selected Answer: A

json is prepared from some table(tables) and extracts to FTP. they can create a share with secure view which will contain all data with logic in place

upvoted 1 times

...

NachoPrendes

5 months ago

Selected Answer: B

A. No, users sharing a share that includes a database cannot see the files contained in an stage within that database by default.

upvoted 2 times

...

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 82 discussion

Comments

AleksM

NachoPrendes

SY0-701