- (Exam Topic 1)
Select the three types of tables that exist within Snowflake. Choose 3 answers
Correct Answer:ABD
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
- (Exam Topic 1)
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.
Correct Answer:A
- (Exam Topic 2)
What are value types that a VARIANT column can store? (Select TWO)
Correct Answer:BD
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics
- (Exam Topic 1)
The FLATEEN function is used to query which type of data in Snowflake?
Correct Answer:B
Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html
FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.
- (Exam Topic 3)
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Correct Answer:D