Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 105 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 105
Topic #: 1
[All SnowPro Advanced Architect Questions]

A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AWS Singapore region that the team wants to analyze.

The Architect has been given the following requirements:

1. Provide access to frequently changing data
2. Keep egress costs to a minimum
3. Maintain low latency

How can these requirements be met with the LEAST amount of operational overhead?

  • A. Use a materialized view on top of an external table against the S3 bucket in AWS Singapore.
  • B. Use an external table against the S3 bucket in AWS Singapore and copy the data into transient tables.
  • C. Copy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe for data ingestion.
  • D. Use AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an Azure Netherlands Blob storage, then use an external table against the Blob storage.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
MSIDDIQUI18
3 months, 4 weeks ago
Answer is C based on following analysis
upvoted 1 times
...
MSIDDIQUI18
3 months, 4 weeks ago
Pros: Collocating data in Azure Blob storage minimizes egress costs and latency. Snowpipe automates the data ingestion process, reducing operational overhead. Cons: Initial data transfer will have egress costs, but once collocated, costs will be minimized. Reasoning: This option balances the need for real-time or near-real-time data access, low latency, and minimized egress costs with the least operational overhead. • Data Collocation: Once the data is in Azure Blob storage, accessing it from Snowflake in Azure Netherlands will not incur additional egress costs and will have low latency. • Automated Ingestion: Using Snowpipe automates the ingestion process, reducing the need for manual intervention and continuous management. • Operational Overhead: Compared to managing replication and external tables across clouds, this approach requires less operational effort.
upvoted 1 times
...
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
Loading ...