Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A.Security
• B.Authentication and access control
• C.Time Travel data
• D.Data loading
• E.Query execution

Comment: *

Name: *

Email: *

Verification: *

What is the default character set used when loading CSV files into Snowflake?

• A.UTF-8
• B.UTF-16
• C.ISO S859-1
• D.ANSI_X3.A

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A.When the data cache is full, the least-recently used data will be cleared to make room.
• B.A user can only access their own queries from the query result cache.
• C.When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• D.A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• E.The RESULT_SCAN table function can access and filter the contents of the query result cache.

Comment: *

Name: *

Email: *

Verification: *

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

• A.Informatica
• B.Power Bl
• C.Adobe
• D.Data Robot

Comment: *

Name: *

Email: *

Verification: *

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *