Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

• A.FLATTEN
• B.OBJECT_AS
• C.OBJECT_CONSTRUCT
• D.TO VARIANT

Comment: *

Name: *

Email: *

Verification: *

Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

• A.The procedure will be run with the privileges of the caller.
• B.The owner can set the caller's session variables.
• C.The owner will inherit the caller's current virtual warehouse.
• D.The owner can view the caller's session variables.

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

What is the minimum Snowflake edition that has column-level security enabled?

• A.Standard
• B.Virtual Private Snowflake
• C.Enterprise
• D.Business Critical

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?

• A.Query history
• B.Visualization chart
• C.Query Profile
• D.Query acceleration service

Comment: *

Name: *

Email: *

Verification: *