What are value types that a VARIANT column can store? (Select TWO)

• A.STRUCT
• B.OBJECT
• C.BINARY
• D.ARRAY
• E.CLOB

Comment: *

Name: *

Email: *

Verification: *

Snowflake is designed for which type of workloads? (Choose two.)

• A.OLAP (Analytics) workloads
• B.OLTP (Transactional) workloads
• C.Concurrent workloads
• D.On-premise workloads

Comment: *

Name: *

Email: *

Verification: *

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

• A.Queries on the table are running slower than expected
• B.The table has a small number of micro-partitions
• C.DML statements that are being issued against the table are blocked
• D.The table contains a column that has very low cardinality
• E.The clustering depth for the table is large

Comment: *

Name: *

Email: *

Verification: *

Select the different types of Internal Stages: (Choose three.)

• A.Named Stage
• B.Schema Stage
• C.Table Stage
• D.User Stage

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster warehouse be used in auto-scaling mode?

• A.When it is unknown how much compute power is needed
• B.If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• C.If the runtime of the executed query is very slow
• D.When a large number of concurrent queries are run on the same warehouse

Comment: *

Name: *

Email: *

Verification: *