SOL-C01 · Question #114
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 choos
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.
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.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-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.