Which command can be used to load data files into a Snowflake stage?

• A.COPY INTO
• B.PUT
• C.GET
• D.JOIN

Comment: *

Name: *

Email: *

Verification: *

How would a user run a multi-cluster warehouse in maximized mode?

• A.Configure the maximum clusters setting to "Maximum."
• B.Set the minimum clusters and maximum clusters settings to different values.
• C.Set the minimum Clusters and maximum Clusters settings to the same value.
• D.Turn on the additional clusters manually after starting the warehouse.

Comment: *

Name: *

Email: *

Verification: *

What happens when a virtual warehouse is resized?

• A.When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
• B.Users who are trying to use the warehouse will receive an error message until the resizing is complete
• C.When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
• D.The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Comment: *

Name: *

Email: *

Verification: *

Which file format will keep floating-point numbers from being truncated when data is unloaded?

• A.CSV
• B.JSON
• C.Parquet
• D.ORC

Comment: *

Name: *

Email: *

Verification: *

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

• A.Tri-Secret Secure
• B.Time Travel
• C.Fail-safe
• D.Data encryption
• E.External stages

Comment: *

Name: *

Email: *

Verification: *