A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

• A.When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
• B.When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• C.When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• D.When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Comment: *

Name: *

Email: *

Verification: *

What can a Snowflake user do in the Activity section in Snowsight?

• A.Create dashboards.
• B.Write and run SQL queries.
• C.Explore databases and objects.
• D.Explore executed query performance.

Comment: *

Name: *

Email: *

Verification: *

Which use case does the search optimization service support?

• A.Join predicates on VARIANT columns
• B.Conjunctions (AND) of multiple equality predicates
• C.LIKE/ILIKE/RLIKE join predicates
• D.Disjuncts (OR) in join predicates

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

• A.Reorder the rows in a relational table and then unload the rows into a file
• B.Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.
• C.Reorder the data columns according to a target table definition and then unload the rows into the table.
• D.Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Comment: *

Name: *

Email: *

Verification: *

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

• A.SKIP BYTE ORDER MARK
• B.ESCAPE_UNENCLOSED_FIELD
• C.BINARY_FORMAT
• D.FIELD_OPTIONALLY_ENCLOSED_BY

Comment: *

Name: *

Email: *

Verification: *