Which Snowflake function will parse a JSON-null into a SQL-null?

• A.TO_CHAR
• B.TO_VARIANT
• C.TO_VARCHAR
• D.STRIP NULL VALUE

Comment: *

Name: *

Email: *

Verification: *

What situation is likely to cause data spillage when a query is run?

• A.When a virtual warehouse runs out of memory while executing the query.
• B.When the query contains multiple filters and no data is returned.
• C.When running queries that exceed the statement_timecut_in_seccnds parameter setting.
• D.When the number of queries exceeds the max_concurrency_level parameter setting.

Comment: *

Name: *

Email: *

Verification: *

When cloning a database, what is cloned with the database? (Choose two.)

• A.Privileges on the database
• B.Existing child objects within the database
• C.Future child objects within the database
• D.Privileges on the schemas within the database
• E.Only schemas and tables within the database

Comment: *

Name: *

Email: *

Verification: *

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

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

• A.Create a view on the table.
• B.Add a clustering key to the table
• C.Add a limit clause to the query.
• D.Add a Dynamic Data Masking policy to the table.

Comment: *

Name: *

Email: *

Verification: *