When loading data into Snowflake, the COPY command supports: Choose 2 answers

A. Joins

B. Fitters

C. Data type conversions

D. Column reordering

E. Aggregates

As a best practice, clustering keys should only be defined on tables of which minimum size?

A. Multi-Kilobyte (KB) Range

B. Multi-Megabyte (MB) Range

C. Multi-Gigabyte (GB) Range

D. Multi-Terabyte (TB) Range

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A. True

B. False

How long is the Fail-safe period for temporary and transient tables?

A. There is no Fail-safe period for these tables.

B. 1 day

C. 7 days

D. 31 days

E. 90 days

Which statement accurately describes how a virtual warehouse functions?

A. Increasing the size of a virtual warehouse will always improve data loading performance.

B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.

C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

For a multi-cluster virtual warehouse, which parameters are used to calculate the number of credits billed? (Choose two.)

A. Cache size

B. Warehouse size

C. Number of clusters

D. Volume of data processed

E. Number of queries executed

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Choose two.)

A. Search optimization service

B. Automatic clustering

C. Row access policies

D. Multi-cluster virtual warehouses

E. Secure views

Which virtual warehouse privilege is required to view a load-monitoring chart?

A. MONTTOR

B. MODIFY

C. OPERATE

D. USAGE

Which pages are included in the Activity area of Snowsight? (Choose two.)

A. Contacts

B. Sharing settings

C. Copy History

D. Query History

E. Automatic Clustering History

The use of which technique or tool will improve Snowflake query performance on very large tables?

A. Indexing

B. Clustering keys

C. Multi-clustering

D. Materialized views