Which of the following is the Snowflake Account_Usage.Metering_History view used for?

• A.Compiling an account's average cloud services cost over the previous month
• B.Gathering the hourly credit usage for an account
• C.Summarizing the throughput of Snowpipe costs for an account
• D.Calculating the funds left on an account's contract

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A.Materialized views
• B.Sequences
• C.Procedures
• D.Tables
• E.Secure User Defined Functions (UDFs)

Comment: *

Name: *

Email: *

Verification: *

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

• A.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.
• B.Returning a value is required in a stored procedure while returning values in a UDF is optional.
• C.Stored procedures can execute database operations while UDFs cannot.
• D.Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Comment: *

Name: *

Email: *

Verification: *

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

• A.There are multiple SOL UDFs with the same names and the same number of arguments.
• B.There are multiple SQL UDFs with the same names and the same number of argument types.
• C.There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
• D.There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Comment: *

Name: *

Email: *

Verification: *

What is the recommended file sizing for data loading using Snowpipe?

• A.A compressed file size greater than 10 MB, and up to 100 MB
• B.A compressed file size greater than 1 GB, and up to 2 GB
• C.A compressed file size greater than 100 MB, and up to 250 MB
• D.A compressed file size greater than 100 GB, and up to 250 GB

Comment: *

Name: *

Email: *

Verification: *