| Exam Name: | SnowPro Core Certification 2026 Exam | ||
| Exam Code: | COF-C03 Dumps | ||
| Vendor: | Snowflake | Certification: | SnowPro Core Certification |
| Questions: | 1102 Q&A's | Shared By: | marcie |
What command will return a list of files that have been unloaded to a user stage?
Options:
DESC @~
GET @~
SHOW @~
LIST @~
What virtual warehouse configuration should be used when processing a large number of complex queries?
Options:
Use the auto-resume feature.
Run the warehouse in auto-scale mode.
Increase the size of the warehouse.
Increase the number of warehouse clusters.
Answer:
DExplanation:
To handle a large number of complex queries, configuring the warehouse in auto-scale mode by increasing the number of warehouse clusters is recommended. This setup allows Snowflake to dynamically add clusters as demand increases, ensuring better performance and concurrency. Increasing the number of clusters provides scalability for concurrent users and heavy workloads, improving response times without impacting individual query performance.
What is the effect of using FORCE = TRUE in a COPY INTO < table > command?
Options:
All files will be loaded, even ones with a load status of unknown.
Files that have already been successfully loaded into the table will be loaded again.
Files that have already been successfully loaded into the table will not be loaded again.
String columns longer than the length specified in the column definition will be loaded anyway.
Answer:
BExplanation:
The correct answer is B. Files that have already been successfully loaded into the table will be loaded again .
By default, Snowflake uses load metadata to prevent the same files from being loaded into a table more than once. Setting FORCE = TRUE overrides this behavior and reloads files even if Snowflake load metadata indicates that the files were already successfully loaded.
Why B is correct:
FORCE = TRUE tells Snowflake to ignore previous load history and load files again.
Why the other options are incorrect:
A. FORCE = TRUE is not specifically about files with unknown load status.
C. This describes the default behavior when FORCE = FALSE, not when FORCE = TRUE.
D. Loading strings longer than the target column length is controlled by other loading behavior and error handling, not by FORCE.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < table > describes FORCE as an option that loads all files, regardless of whether they have been loaded previously.
