- (Topic 3)
How does a scoped URL expire?

1. A. When the data cache clears.
2. B. When the persisted query result period ends.
3. C. The encoded URL access is permanent.
4. D. The length of time is specified in the expiration_time argument.

Correct Answer: B
A scoped URL expires when the persisted query result period ends, which is typically after the results cache expires. This is currently set to 24 hours

- (Topic 2)
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a
Large warehouse?

1. A. 4
2. B. 8
3. C. 16
4. D. 32

Correct Answer: B
In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

- (Topic 3)
How can a Snowflake user access a JSON object, given the following table? (Select TWO).

1. A. src:salesperson.name
2. B. src:sa1esPerso
3. C. name
4. D. src:salesperson.Name
5. E. SRC:salesperson.name
6. F. SRC:salesperson.Name

Correct Answer: AC
To access a JSON object in Snowflake, dot notation is used where the path to the object is specified after the column name containing the JSON data. Both lowercase and uppercase can be used for attribute names, so both ??name?? and ??Name?? are valid. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 2)
How long is the Fail-safe period for temporary and transient tables?

1. A. There is no Fail-safe period for these tables.
2. B. 1 day
3. C. 7 days
4. D. 31 days
5. E. 90 days

Correct Answer: A
Temporary and transient tables in Snowflake do not have a Fail-safe period. Once the session ends or the tables are dropped, the data is purged and not recoverable1.
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

- (Topic 6)
How can the Query Profile be used to troubleshoot a problematic query?

1. A. It will indicate if a virtual warehouse memory is too small to run the query
2. B. It will indicate if a user lacks the privileges needed to run the query.
3. C. It will indicate if a virtual warehouse is in auto-scale mode
4. D. It will indicate if the user has enough Snowflake credits to run the query

Correct Answer: A
The Query Profile in Snowflake provides detailed insights into the execution of a query. It helps in troubleshooting performance issues by showing the steps of the query execution and the resources consumed. One of the key aspects it reveals is whether the virtual warehouse memory was sufficient for the query.
✑ Access Query Profile:Navigate to the Query History page and select the query you
want to analyze.
✑ Examine Query Execution Steps:The Query Profile displays the different stages of the query execution, including the time taken and resources used at each step.
✑ Identify Memory Issues:Look for indicators of memory issues, such as spilling to disk or memory errors, which suggest that the virtual warehouse memory might be too small.
References:
✑ Snowflake Documentation: Query Profile
✑ Snowflake Documentation: Optimizing Queries