A.The default virtual warehouse will be used to read all data.

B.No virtual warehouse will be used, data will be read from the result cache.

C.No virtual warehouse will be used, data will be read from the local disk cache.

D.The virtual warehouse that is defined at the session level will be used to read all data.

A.Secure User-Defined Functions (UDFs)

B.Files

C.Sequences

D.Streams

E.External tables

A.Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

B.Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C.Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

D.Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

E.All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F.Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

A.ORC

B.XML

C.Avro

D.Parquet

E.JSON

A.There is minimal cost associated with running the query.

B.The query is highly optimized and does not consume many compute resources.

C.The base table gets updated frequently.

D.The results of the query do not change often and are used frequently.

E.The query consumes many compute resources every time it runs.