Online Access Free COF-C02 Practice Test

Which function should be used to find the query ID of the second query executed in a current session?

• A.Select LAST_QUERY_ID(2)
• B.Select LAST_QUERY_ID(1)
• C.Select LAST_QUERY_ID(-2)
• D.Select LAST_QUERY_ID(2)

What can the Snowflake SCIM API be used to manage? (Select TWO).

• A.Integrations
• B.Network policies
• C.Session policies
• D.Users
• E.Roles

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

• A.UUID_STRING
• B.JOB_ID
• C.CURRENT_STATEMENT
• D.Last_QUERY_ID

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

• A.True
• B.False

What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

• A.Named file format
• B.Storage integration
• C.Task
• D.Stream