How can staged files be removed during data loading once the files have loaded successfully?

• A.Use the DROP command
• B.Use the purge copy option.
• C.Use the FORCE = TRUE parameter
• D.Use the LOAD UNCERTAIN FILES copy option.

Comment: *

Name: *

Email: *

Verification: *

Which use case does the search optimization service support?

• A.Join predicates on VARIANT columns
• B.Conjunctions (AND) of multiple equality predicates
• C.UKE/ILIKE/RLIKE join predicates
• D.Disjuncts (OR) in join predicates

Comment: *

Name: *

Email: *

Verification: *

Which statement will trigger a stream to advance its offset?

• A.DESCRIBE STREAM
• B.ALTER STREAM
• C.DROP STREAM
• D.CREATE OR REPLACE STREAM

Comment: *

Name: *

Email: *

Verification: *

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

• A.INSERT
• B.PUT
• C.GET
• D.COPY

Comment: *

Name: *

Email: *

Verification: *

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

• A.4
• B.8
• C.16
• D.32

Correct Answer: B

In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Comment: *

Name: *

Email: *

Verification: *