Exam SOL-C01 Topic 1 Question 104 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 104
Topic #: 1
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)

Suggested Answer: A,B Vote an answer

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.

by Kennedy at Dec 11, 2025, 06:08 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10