SOL-C01 Question #114: Real Exam Question with Answer & Explanation

Question

You are responsible for optimizing data loading into Snowflake from a large set of CSV files stored in Azure Blob Storage. The files contain millions of records and are updated daily You need to choose the MOST efficient method for loading this data, considering both performance and cost. Select TWO options that would best address this scenario.

Options

• AUse Snowpipe with auto-ingest enabled and a dedicated X-SMALL virtual warehouse.
• BUse a scheduled task that executes a COPY INTO statement with a large virtual warehouse (e.g.,
• CUtilize Snowflake's Data Marketplace to subscribe to a pre-built data feed containing similar data.
• DImplement Snowpipe with a notification integration that triggers data loading only when new files
• EUse the Snowflake web IJI to manually upload the CSV files on a daily basis.

Explanation

Snowpipe with auto-ingest (A) provides continuous data loading as soon as new files are available in the stage, making it highly efficient for near real-time ingestion. It leverages serverless compute for loading, optimizing cost. Coupling it with a notification integration (D) makes the process even more event- driven and efficient, ensuring that data loading is triggered immediately upon file arrival. Options B is a batch process using scheduled tasks which is not ideal, and the other two aren't related to the data loading process that the question is asking.

No community discussion yet for this question.