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

Question

Your team is loading data into Snowflake using Snowpipe. You've noticed that data loading is significantly slower than expected, even though your virtual warehouse is sized appropriately. Which of the following factors could contribute to this performance bottleneck? (Select TWO)

Options

• AThe virtual warehouse is configured with auto-suspend, causing it to frequently start and stop.
• BThe files being loaded are very small (e.g., less than 1 MB) and numerous.
• CThe Snowflake table has a clustering key that is poorly chosen, resulting in uneven data
• DSnowpipe is configured to use the COPY INTO statement directly, bypassing the Snowpipe
• EThe IAM role used for accessing data in S3 has insufficient permissions.

Explanation

Frequent auto-suspension of the virtual warehouse (A) will introduce latency as the warehouse needs to start up each time data is available. Loading many small files (B) can also create a bottleneck because of the overhead associated with processing each file. A poorly chosen clustering key (C) impacts query performance, not Snowpipe loading directly. Snowpipe uses COPY INTO implicitly; (D) is contradictory. Insufficient IAM permissions (E) would prevent data loading altogether, not just slow it down.

No community discussion yet for this question.