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

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

Comment: *

Name: *

Email: *

Verification: *

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

• A.GET_STATE_LOCATION
• B.GET_PRESENT_URL
• C.BUILD_SCOPED_FILE_URL
• D.BUILD_STAGE_FILE_URL

Comment: *

Name: *

Email: *

Verification: *

What MINIMUM permissions are required to create a pipe in Snowflake? (Select TWO).

• A.SELECT and INSERT on the table in the pipe definition
• B.CREATE SCHEMA at the database level
• C.CREATE PIPE at the schema level
• D.OWNERSHIP on the table in the pipe definition
• E.USAGE on the virtual warehouse

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

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

• A.Standard
• B.Premium
• C.Enterprise
• D.Business Critical

Comment: *

Name: *

Email: *

Verification: *