Will data cached in a warehouse be lost when the warehouse is resized?

• A.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
• B.Yes. because the compute resource is replaced in its entirety with a new compute resource.
• C.No. because the size of the cache is independent from the warehouse size
• D.Yes. became the new compute resource will no longer have access to the cache encryption key

Comment: *

Name: *

Email: *

Verification: *

Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

• A.RETURN_-1_R0WS
• B.RETURN_n_ROWS
• C.RETURN_ERRORS
• D.RETURN ALL ERRORS

Comment: *

Name: *

Email: *

Verification: *

What does a table with a clustering depth of 1 mean in Snowflake?

• A.The table has only 1 micro-partition.
• B.The table has 1 overlapping micro-partition.
• C.The table has no overlapping micro-partitions.
• D.The table has no micro-partitions.

Comment: *

Name: *

Email: *

Verification: *

Which data type can store more than one type of data structure?

• A.JSON
• B.BINARY
• C.VARCHAR
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *

Which type of workload is recommended for Snowpark-optimized virtual warehouses?

• A.Workloads with ad hoc analytics
• B.Workloads that have large memory requirements
• C.Workloads with unpredictable data volumes for each query
• D.Workloads that are queried with small table scans and selective filters

Comment: *

Name: *

Email: *

Verification: *