Which command is used to unload data from a Snowflake table into a file in a stage?

• A.GET
• B.WRITE
• C.EXTRACT INTO
• D.COPY INTO

Comment: *

Name: *

Email: *

Verification: *

Which tasks will help optimize virtual warehouse costs? (Select TWO)

• A.Enabling auto-suspend
• B.Limiting statement queue times
• C.Enabling multi-cluster warehouses
• D.Limiting statement timeout seconds
• E.Enabling auto-resume

Comment: *

Name: *

Email: *

Verification: *

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Comment: *

Name: *

Email: *

Verification: *

When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

• A.When you don't want to have to manually turn on the Warehouse each time a user needs it
• B.When the compute must be available with no delay or lag time
• C.When users will be using compute at different times throughout a 24/7 period
• D.When managing a steady workload

Comment: *

Name: *

Email: *

Verification: *

When using the COPY INTO <location> command to unload table data into a CSV file, which option would compress the file using the default algorithm?

• A.SNAPPY
• B.DEFLATE
• C.NONE
• D.AUTO

Comment: *

Name: *

Email: *

Verification: *