What can be interpreted based on the number of nodes reported in a Query Profile?

• A.Compute required for metadata management
• B.Query execution time
• C.Data spillage
• D.Network bandwidth during query execution

Comment: *

Name: *

Email: *

Verification: *

Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

• A.TASK_HISTORY
• B.TASK_DEPENDENTS
• C.CURRENT_TASK_GRAPHS
• D.COMPLETE_TASK_GRAPHS

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of multi-cluster virtual warehouses?

• A.To create separate data warehouses to increase query optimization
• B.To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
• C.To eliminate or reduce Queuing of concurrent queries
• D.To allow the warehouse to resize automatically

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

• A.SCIM
• B.Federated authentication
• C.TLS 1.2
• D.Key-pair authentication
• E.OAuth
• F.OCSP authentication

Comment: *

Name: *

Email: *

Verification: *

What is the difference between a stored procedure and a User-Defined Function (UDF)?

• A.Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
• B.Stored procedures can execute database operations while UDFs cannot.
• C.Returning a value is required in a stored procedure while returning values in a UDF is optional.
• D.Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Comment: *

Name: *

Email: *

Verification: *