Which of the following are options when creating a Virtual Warehouse?

• A.Local SSD size
• B.Auto-suspend
• C.User count
• D.Auto-resume

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

• A.The virtual warehouse that is defined at the session level will be used to read all data.
• B.No virtual warehouse will be used, data will be read from the local disk cache.
• C.The default virtual warehouse will be used to read all data.
• D.No virtual warehouse will be used, data will be read from the result cache.

Comment: *

Name: *

Email: *

Verification: *

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What happens to the underlying table data when a CLUSTER BY clause is added to a
Snowflake table?

• A.Smaller micro-partitions are created for common data values to allow for more parallelism
• B.Data is hashed by the cluster key to facilitate fast searches for common data values
• C.Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
• D.Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Comment: *

Name: *

Email: *

Verification: *

Which command can be used to stage local files from which Snowflake interface?

• A.SnowSQL
• B.Snowflake classic web interface (Ul)
• C.Snowsight
• D..NET driver

Comment: *

Name: *

Email: *

Verification: *