nerdexam
SnowflakeSnowflake

ARA-C01 · Question #161

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

Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #161. The question stem and answer options stay visible for context.

Architectural Principles and Best Practices

Question

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?

Options

  • AUse a materialized view on top of an external table against the S3 bucket in AWS Singapore.
  • BUse an external table against the S3 bucket in AWS Singapore and copy the data into transient
  • CCopy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe
  • DUse AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an

Unlock ARA-C01 to see the answer

You've previewed enough free ARA-C01 questions. Unlock ARA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data Ingestion#External Tables#Cost Optimization#Cross-Cloud Data Management
Full ARA-C01 PracticeBrowse All ARA-C01 Questions