User-level network policies can be created by which of the following roles? (Select TWO).

• A.ROLEADMIN
• B.ACCOUNTADMIN
• C.SYSADMIN
• D.SECURITYADMIN
• E.USERADMIN

Comment: *

Name: *

Email: *

Verification: *

Which drivers or connectors are supported by Snowflake? (Select TWO)

• A.Perl Connector
• B.MongoDB Rust Driver
• C.Go Snowflake Driver
• D.Cobol Driver
• E.Snowflake Connector for Python

Comment: *

Name: *

Email: *

Verification: *

Which steps will help optimize query performance? (Select TWO).

• A.Decreasing the size of the virtual warehouse
• B.Increasing the size of the micro-partitions
• C.Indexing a column
• D.Using the query acceleration service
• E.Clustering a table

Comment: *

Name: *

Email: *

Verification: *

A user is setting up Snowpipe automation to load data from an Amazon S3 bucket into Snowflake. The user wants Snowflake to automatically start loading files as soon as new ones are added to the bucket. Which steps are required to configure this automation using cloud messaging? Select TWO.

• A.Configure an S3 event notification to an Amazon Simple Notification Service, or SNS, topic.
• B.Create a task that monitors the stage for new files.
• C.Call the insertFiles REST API endpoint after each file upload.
• D.Enable AUTO_INGEST on the Snowpipe definition.
• E.Define an external table and use it as the source for a materialized view.

Comment: *

Name: *

Email: *

Verification: *

What is the difference between a stored procedure and a User-Defined Function (UDF)?

• A.Stored procedures can execute database operations while UDFs cannot.
• B.Returning a value is required in a stored procedure while returning values in a UDF is optional.
• C.Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
• D.Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Comment: *

Name: *

Email: *

Verification: *