When creating a custom role that will be allowed to create warehouses and databases, which system-defined role does Snowflake recommend also be assigned to the custom role?
Correct Answer: D
Question 32
How can a Snowflake user traverse semi-structured data?
Correct Answer: A
To traverse semi-structured data in Snowflake, a user can insert a colon (:) between the VARIANT column name and any first-level element.This path syntax is used to retrieve elements in a VARIANT column4.
Question 33
Which functions can be used to extract values from a VARIANT column by specifying a hierarchy name? Select TWO.
Correct Answer: A,C
The correct answers are A. GET() and C. GET_PATH() . Snowflake supports functions for extracting values from semi-structured data stored in a VARIANT, OBJECT, or ARRAY column. GET() and GET_PATH() can retrieve values by specifying keys, indexes, or paths. Why A is correct: GET() extracts a value from an object or array. For an object, it can retrieve the value associated with a specified key. Example: SELECT GET(src, ' customer ' ) FROM my_table; Why C is correct: GET_PATH() extracts a value from semi-structured data using a path expression. This is useful when specifying a hierarchy or nested path. Example: SELECT GET_PATH(src, ' customer.name ' ) FROM my_table; Why the other options are incorrect: B). TO_JSON() converts a VARIANT value to a JSON string. It does not extract values by hierarchy name. D). PARSE_JSON() parses a string into a VARIANT. It does not extract an existing nested value. E). LATERAL FLATTEN expands arrays or objects into rows. It is useful for traversing semi-structured data, but it is not a scalar extraction function that retrieves a value by specifying a hierarchy name. Official Snowflake documentation reference: Snowflake documentation describes GET() as a function that extracts a value from an object or array, and GET_PATH() as a function that extracts a value from semi-structured data using a path name. Reference: Snowflake Documentation - GET; Snowflake Documentation - GET_PATH; Snowflake Documentation - Querying semi-structured data; SnowPro Core Study Guide - Working with Semi- Structured Data.
Question 34
A user needs to MINIMIZE the cost of large tables that are used to store transitory dat a. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?
Correct Answer: B
For minimizing the cost of large tables that are used to store transitory data, which does not need to be protected against failures because it can be reconstructed outside of Snowflake, the best table type to use is Transient. Transient tables in Snowflake are designed for temporary or transitory data storage and offer reduced storage costs compared to permanent tables. However, unlike temporary tables, they persist across sessions until explicitly dropped. Why Transient Tables: Transient tables provide a cost-effective solution for storing data that is temporary but needs to be available longer than a single session. They have lower data storage costs because Snowflake does not maintain historical data (Time Travel) for as long as it does for permanent tables. Creating a Transient Table: To create a transient table, use the TRANSIENT keyword in the CREATE TABLE statement: CREATE TRANSIENT TABLE my_transient_table (...); Use Case Considerations: Transient tables are ideal for scenarios where the data is not critical, can be easily recreated, and where cost optimization is a priority. They are suitable for development, testing, or staging environments where data longevity is not a concern.
Question 35
What is the purpose of an External Function?
Correct Answer: A
The purpose of an External Function in Snowflake is to call code that executes outside of the Snowflake environment. This allows Snowflake to interact with external servicesand leverage functionalities that are not natively available within Snowflake, such as calling APIs or running custom code hosted on cloud services3. https://docs.snowflake.com/en/sql-reference/external-functions.html
