When a schema is cloned what happens to the tags that reside in that schema or database?

• A.The tags are automatically cloned with the schema, maintaining all associations.
• B.The tags remain in the source schema unchanged.
• C.The tags are deleted and must be redefined in the target schema.
• D.The tags become temporarily inactive until they are manually reactivated.

Comment: *

Name: *

Email: *

Verification: *

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

• A.Authentication
• B.Resource management
• C.Virtual warehouse caching
• D.Query parsing and optimization
• E.Query execution
• F.Physical storage of micro-partitions

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

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

Comment: *

Name: *

Email: *

Verification: *

Which configuration of the function PARSE_JSON (<expr>) will retrieve a valid SQL HULL value?

• A.SELECT parse_json (NULL)
• B.SELECT parse_json('null*)
• C.SELECT parse_json('[ null ]')
• D.SELECT parse json('{"a": null)'):a

Comment: *

Name: *

Email: *

Verification: *

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

• A.Newline Delimited JSON
• B.Plain text file containing XML elements
• C.Binary file in Avro
• D.Binary file in Parquet
• E.Comma-separated JSON

Comment: *

Name: *

Email: *

Verification: *