Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam COF-R02 Topic 5 Question 50 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 50
Topic #: 5
[All COF-R02 Questions]

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Show Suggested Answer Hide Answer
Suggested Answer: D

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

VALIDATION_MODE=RETURN_n_ROWS|RETURN_ERRORS|RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data filesinsteadof loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:


Contribute your Thoughts:

Kerry
1 days ago
I think the correct answer is D. It makes sense to shut down a cluster when the load on the least-loaded cluster can be redistributed, which would be more efficient.
upvoted 0 times
...

Save Cancel