The FLATEEN function is used to query which type of data in Snowflake?

• A.Semi-structured data
• B.Both of the above
• C.None of the above
• D.Structured data

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster virtual warehouse be used in Snowflake?

• A.When dynamic vertical scaling is being used in the warehouse
• B.When there are no concurrent queries running on the warehouse
• C.When there is significant disk spilling shown on the Query Profile
• D.When queuing is delaying query execution on the warehouse

Comment: *

Name: *

Email: *

Verification: *

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

• A.Java
• B.Javascript
• C.Scala
• D.Python
• E.SQL

Comment: *

Name: *

Email: *

Verification: *

What do temporary and transient tables have m common in Snowflake? (Select TWO).

• A.Both tables have no Fail-safe period.
• B.Both tables have data retention period maximums of one day.
• C.Both tables are visible only to a single user session.
• D.For both tables the retention period ends when the tables are dropped.
• E.For both tables, the retention period does not end when the session ends

Comment: *

Name: *

Email: *

Verification: *

Which is a best practice recommendation when planning to load data into a table?

• A.Use the largest size virtual warehouse allowed to maximize the available threads for uploading files.
• B.Dedicate separate virtual warehouses for loading operations and querying operations.
• C.Use different stages to store files, identifying data source identifiers.
• D.Upload files that are equal to or larger than 100 GB each.

Comment: *

Name: *

Email: *

Verification: *