A.Account

B.Virtual warehouse

C.Table

D.Schema

E.Database

A.Yes. became the new compute resource will no longer have access to the cache encryption key

B.Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

D.No. because the size of the cache is independent from the warehouse size

A.Time Travel on the historical data is dropped.

B.The data moves to Fail-safe

C.The object containing the historical data is dropped.

D.The data is cloned into a historical object.

A.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

B.By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

C.Use the ENCODING file format option to change the encoding from the default UTF-8.

D.Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

E.When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

A.CHECK_JSON

B.FLATTEN

C.TO_JSON

D.PARSE_JSON