| Exam Name: | SnowPro Core Certification Exam | ||
| Exam Code: | COF-C02 Dumps | ||
| Vendor: | Snowflake | Certification: | SnowPro Core Certification |
| Questions: | 693 Q&A's | Shared By: | tara |
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Options:
Compute layer
Storage layer
Cloud infrastructure layer
Cloud services layer
Answer:
DExplanation:
Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects of the Snowflake service, including authentication, infrastructure management, metadata management, query parsing and optimization, and security. By handling these tasks, the Cloud Services layer enables the Compute layer to focus on executing queries, while the Storage layer is dedicated to persistently storing data.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowflake Architecture1
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Options:
Removing a column from the query SELECT list
Stopping the virtual warehouse that the query is running against
Clustering of the data used by the query
Executing the RESULTS_SCAN() table function
Changing a column that is not in the cached query
Answer:
B, DExplanation:
The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D). Stopping the warehouse clears the local disk cache, including the ResultSet cache1. The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Options:
Use the DROP
Specify the TEMPORARY option when creating the file format.
Specify the PURGE copy option in the COPY INTO
