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

Question

A company is designing a process for importing a large amount of loT JSON data from cloud storage into Snowflake. New sets of loT data get generated and uploaded approximately every 5 minutes. Once the loT data is in Snowflake, the company needs up-to-date information from an external vendor to join to the data. This data is then presented to users through a dashboard that shows different levels of aggregation. The external vendor is a Snowflake customer. What solution will MINIMIZE complexity and MAXIMIZE performance?

Options

• A1. Create an external table over the JSON data in cloud storage.
• B1. Create an external table over the JSON data in cloud storage.
• C1. Create a Snowpipe to bring the JSON data into Snowflake.
• D1. Create a Snowpipe to bring the JSON data into Snowflake.

Explanation

Using Snowpipe for continuous, automated data ingestion minimizes the need for manual intervention and ensures that data is available in Snowflake promptly after it is generated. Leveraging Snowflake's data sharing capabilities allows for efficient and secure access to the vendor's data without the need for complex API integrations. Materialized views provide pre- aggregated data for fast access, which is ideal for dashboards that require high performance.

No community discussion yet for this question.