A.Standard and secure view results

B.Persisted query results

C.Snowflake parameters

D.Query history

E.Micro-partitions

A.Snowflake eliminates resource contention with its virtual warehouse implementation

B.Zero-copy cloning creates a mirror copy of a database that updates with the original

C.Software updates are automatically applied on a quarterly basis

D.Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

E.Multi-cluster warehouses allow users to run a query that spans across multiple clusters

A.Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

B.Smaller micro-partitions are created for common data values to allow for more parallelism

C.Data is hashed by the cluster key to facilitate fast searches for common data values

D.Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

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

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.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

A.Within the data files

B.In the virtual warehouse layer

C.In the remote storage layer

D.In the cloud services layer