- (Topic 4)
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

1. A. FLATTEN
2. B. GET_PATH
3. C. CHECK_JSON
4. D. PARSE JSON

Correct Answer: A
The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object. This function is particularly useful for working with semi-structured data in Snowflake

- (Topic 3)
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

1. A. Auto-scale mode
2. B. Maximized mode
3. C. Economy scaling policy
4. D. Standard scaling policy

Correct Answer: A
In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode. This mode allowsSnowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases

- (Topic 4)
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

1. A. GET_PRESIGNED_URL
2. B. GET_ABSOLUTE_PATH
3. C. BUILD_STAGE_FILE_URL
4. D. BUILD SCOPED FILE URL

Correct Answer: C
The BUILD_STAGE_FILE_URL function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

- (Topic 6)
Which command can be used to list all network policies available in an account?

1. A. DESCRIBE SESSION POLICY
2. B. DESCRIBE NETWORK POLICY
3. C. SHOW SESSION POLICIES
4. D. SHOW NETWORK POLICIES

Correct Answer: D
To list all network policies available in an account, the correct command is SHOW NETWORK POLICIES. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. TheSHOW NETWORK POLICIEScommand provides a list of all network policies defined within the account, along with their details.
TheDESCRIBE SESSION POLICYandDESCRIBE NETWORK POLICYcommands do not
exist in Snowflake SQL syntax. TheSHOW SESSION POLICIEScommand is also incorrect, as it does not pertain to the correct naming convention used by Snowflake for network policy management.
UsingSHOW NETWORK POLICIESwithout any additional parameters will display all network policies in the account, which is useful for administrators to review and manage the security configurations pertaining to network access.
Reference: Snowflake Documentation on Network Policies
(https://docs.snowflake.com/en/sql-reference/sql/show-network-policies.html)

- (Topic 3)
Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

1. A. A User-Defined Table Function (UDTF)
2. B. A Scalar User Function (UDF)
3. C. A stored procedure
4. D. A task

Correct Answer: A
In Snowflake, a User-Defined Table Function (UDTF) can be accessed in the FROM clause of a query. UDTFs return a set of rows with one or more columns, which can be queried like a regular table