Which Snowflake tool would be BEST to troubleshoot network connectivity?
Correct Answer: D
SnowCD (Snowflake Connectivity Diagnostic Tool) is the best tool provided by Snowflake for troubleshooting network connectivity issues.It helps diagnose and resolve issues related to connecting to Snowflake services https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.
Question 472
Which stage type can be altered and dropped?
Correct Answer: B
External stages can be altered and dropped in Snowflake. An external stage points to an external location, such as an S3 bucket, where data files are stored. Users can modify the stage's definition or drop it entirely if it's no longer needed. This is in contrast to table stages, which are tied to specific tables and cannot be altered or dropped independently. References: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Stages1
Question 473
A Snowflake user is investigating a slow-running query using the Query Profile. What would be a reason to increase the size of the virtual warehouse?
Correct Answer: B
The correct answer is B. Processing: 51.8% . A high percentage of query time spent in Processing indicates that the query is spending significant time on CPU-intensive work, such as joins, aggregations, sorting, window functions, or expression evaluation. Increasing the virtual warehouse size can provide more compute resources and may reduce processing time. Why B is correct: If the Query Profile shows a large portion of time spent in processing, scaling up the warehouse can help because a larger warehouse provides more compute power. Why the other options are incorrect: A). A high percentage scanned from cache is generally positive. It means much of the data was served from cache instead of remote storage. C). High remote disk I/O may indicate data is being read from remote storage. Increasing warehouse size may not be the first or best fix; improving pruning, clustering, filters, or reducing scanned data may be more appropriate. D). Bytes Scanned: 3.24 GB by itself is not enough to justify increasing warehouse size. The reason to scale up is usually compute pressure, not simply a raw scan number. Official Snowflake documentation reference: Snowflake documentation explains that Query Profile helps identify time spent in processing, local disk I/O, remote disk I/O, synchronization, and other execution categories. Increasing warehouse size can help when queries are constrained by compute processing. Reference: Snowflake Documentation - Query Profile; Snowflake Documentation - Virtual warehouse performance; SnowPro Core Study Guide - Performance Optimization.
Question 474
Which of the following describes the Snowflake Cloud Services layer?
Correct Answer: A
The Snowflake Cloud Services layer is a collection of services that coordinate activities across Snowflake, tying together all the different components to process user requests, from login to query dispatch1. References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1
Question 475
Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).
Correct Answer: B,E
User-Defined Function (UDF) handlers must be written inline for Javascript and SQL. These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.
