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

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

• A.10
• B.50
• C.64
• D.256

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake's search optimization service support?

• A.Casts on table columns (except for fixed-point numbers cast to strings)
• B.Materialized views
• C.External tables
• D.Tables and views that are not protected by row access policies

Comment: *

Name: *

Email: *

Verification: *

Which function will return the URL for an external stage by using the stage name as the input?

• A.GET_ABSOLUTE_PATH
• B.GET_PRESIGNED_URL
• C.GET_STAGE_LOCATION
• D.BUILD_STAGE_FILE_URL

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

• A.Use Snowpipe.
• B.Use the INSERT command.
• C.Use an external table.
• D.Use the COPY command.

Comment: *

Name: *

Email: *

Verification: *