Which command will unload data from a table into an external stage?

• A.PUT
• B.INSERT
• C.COPY INTO <location>
• D.GET

Comment: *

Name: *

Email: *

Verification: *

How can a Snowflake user access a JSON object, given the following table? (Select TWO).

• A.src:salesperson.name
• B.src:sa1esPerson. name
• C.src:salesperson.Name
• D.SRC:salesperson.name
• E.SRC:salesperson.Name

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the Snowflake Cloud Services layer?

• A.Coordinates activities in the Snowflake account
• B.Executes queries submitted by the Snowflake account users
• C.Manages quotas on the Snowflake account storage
• D.Manages the virtual warehouse cache to speed up queries

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 sizeSmall 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: *

Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

• A.Transient table
• B.Permanent table
• C.Temporary table
• D.External table

Comment: *

Name: *

Email: *

Verification: *