Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by NachoPrendes at July 18, 2024, 10:55 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
NachoPrendes
4 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel