A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

• A.The database the Virtual Warehouse resides in
• B.The queries currently being run by the Virtual Warehouse
• C.The primary duster in the virtual warehouse
• D.The entire Virtual Warehouse

Comment: *

Name: *

Email: *

Verification: *

What are common issues found by using the Query Profile? (Choose two.)

• A.Identifying logical issues with the queries
• B.Identifying inefficient micro-partition pruning
• C.Identifying queries that will likely run very slowly before executing them
• D.Locating queries that consume a high amount of credits
• E.Data spilling to a local or remote disk

Comment: *

Name: *

Email: *

Verification: *

True or False: A Virtual Warehouse can be resized while suspended.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes external functions in Snowflake?

• A.They are a type of User-defined Function (UDF).
• B.They contain their own SQL code.
• C.They call code that is stored inside of Snowflake.
• D.They can return multiple rows for each row received

Comment: *

Name: *

Email: *

Verification: *

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?

• A.Row access policies
• B.Role based access control
• C.Data masking policies
• D.Data encryption

Comment: *

Name: *

Email: *

Verification: *