Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

• A.1 Hour
• B.3 Hours
• C.12 hours
• D.24 hours

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements would be used to export/unload data from Snowflake?

• A.EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
• B.INSERT INTO @stage
• C.COPY INTO @slage
• D.EXPORT TO @stage

Comment: *

Name: *

Email: *

Verification: *

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

• A.To accommodate a more complex workload
• B.To accommodate more queries
• C.To accommodate fluctuations in workload
• D.To accommodate more users

Comment: *

Name: *

Email: *

Verification: *

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

• A.Use the DELETE LOAD HISTORY command after the load completes.
• B.Specify the TEMPORARY option when creating the file format.
• C.Use the REMOVE command after the load completes.
• D.Specify the PURGE copy option in the COPY INTO <table> command.
• E.Use the DROP <file> command after the load completes.

Comment: *

Name: *

Email: *

Verification: *

Which of the following are best practices for loading data into Snowflake? (Choose three.)

• A.Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
• B.Enclose fields that contain delimiter characters in single or double quotes.
• C.Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
• D.When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
• E.Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
• F.Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Comment: *

Name: *

Email: *

Verification: *