- (Topic 2)
How long is the Fail-safe period for temporary and transient tables?
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)
Which function should be used to find the query ID of the second query executed in a current session?
Correct Answer:A
The correct function to find the query ID of the second query executed in the current session isSELECT LAST_QUERY_ID(-2). TheLAST_QUERY_IDfunction returns the query ID for the most recent query executed in the session when called with no arguments. When used with an argument, it can retrieve the ID of previous queries within the same session, where-2would reference the second most recent query executed.
References:
✑ There's a clarification needed here; Snowflake's documentation indicatesLAST_QUERY_ID()function does not accept arguments. It returns the ID of the last query executed in the session. To find the query ID of the second last executed query, users typically need to track query IDs manually or use session history views.
- (Topic 4)
Which Snowflake function will parse a JSON-null into a SQL-null?
Correct Answer:D
The STRIP_NULL_VALUE function in Snowflake is used to convert a JSON null value into a SQL NULL value1.
- (Topic 3)
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
Correct Answer:AB
In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage. These metrics suggest thatthe working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk
- (Topic 4)
What transformations are supported when loading data into a table using the COPY INTO