Question 420
A data engineer wants to see how an expensive query spent time rather than judging performance from total elapsed time. The proposed response is: Open the completed query's profile from supported Snowflake query-history tools. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
The profile diagnoses one execution; it does not guarantee an optimization will generalize to other workloads. It qualifies the proposed action: open the completed query's profile from supported Snowflake query-history tools.
Incorrect Answers
Sequence-generated values are not promised to be consecutive without gaps under every workload. This is a trade-off for the separate proposal: use a Snowflake sequence object as the source of generated numeric values. The proposed choice instead requires acknowledging this risk: the profile diagnoses one execution; it does not guarantee an optimization will generalize to other workloads.
Creating a stage does not load the files into a target table by itself. This is a trade-off for the separate proposal: create a named external stage referencing the authorized cloud storage location and credentials integration. The proposed choice instead requires acknowledging this risk: the profile diagnoses one execution; it does not guarantee an optimization will generalize to other workloads.
Changing compute size affects execution capacity and credits, not the storage location or table ownership. This is a trade-off for the separate proposal: explain that Snowflake stores persisted table data in a storage layer separate from virtual warehouse compute. The proposed choice instead requires acknowledging this risk: the profile diagnoses one execution; it does not guarantee an optimization will generalize to other workloads.





SnowPro Core COF-C03 Practice Tests