What happens to event notifications that are received when an automated Snowpipe is paused?
Correct Answer: C
Question 52
Which command can be performed on a Snowflake secure view?
Correct Answer: C
Question 53
Which queries will require a running virtual warehouse? (Select TWO).
Correct Answer: B,D
Question 54
What can a Snowflake user do with the information included in the details section of a Query Profile?
Correct Answer: A
The details section of a Query Profile in Snowflake provides users with various statistics and information about the execution of a query. One of the key pieces of information that can be determined from this section is the total duration of the query, which helps in understanding the performance and identifying potential bottlenecks.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 55
What information is included in the output of an EXPLAIN_PLAN?
Correct Answer: D
The correct answer is D. The total number of micro-partitions that the operation will reference . In Snowflake, EXPLAIN or EXPLAIN USING returns the logical execution plan for a SQL statement. The plan can include information about the operations Snowflake expects to perform, such as table scans, filters, joins, and estimated partitions involved in the query. Why D is correct: The explain plan can show partition-related information for table scan operations, including the number of partitions that may be scanned. This is useful for understanding how well Snowflake can prune micro- partitions. Why the other options are incorrect: A). EXPLAIN_PLAN does not provide a guaranteed predicted query runtime. Actual execution time depends on warehouse size, load, caching, pruning, and other runtime factors. B). EXPLAIN_PLAN does not directly state the number of credits the query will consume. Credit consumption is based mainly on warehouse runtime and size. C). EXPLAIN_PLAN describes the execution plan, not the actual result data type returned by the query. Official Snowflake documentation reference: Snowflake documentation explains that the EXPLAIN command displays the logical execution plan for a SQL statement. Query plans can include details about operations such as scans, joins, filters, and partitions. Reference: Snowflake Documentation - EXPLAIN; Snowflake Documentation - Query Profile and query optimization; SnowPro Core Study Guide - Performance Optimization.
