How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

• A.A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
• B.A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
• C.A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
• D.Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Comment: *

Name: *

Email: *

Verification: *

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

• A.Key pair authentication
• B.Client-side encryption
• C.Hierarchical key model
• D.Tri-secret secure encryption

Comment: *

Name: *

Email: *

Verification: *

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

• A.Management of metadata
• B.Computing the data
• C.Maintaining Availability Zones
• D.Infrastructure security
• E.Parsing and optimizing queries

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster virtual warehouse be used in Snowflake?

• A.When queuing is delaying query execution on the warehouse
• B.When there is significant disk spilling shown on the Query Profile
• C.When dynamic vertical scaling is being used in the warehouse
• D.When there are no concurrent queries running on the warehouse

Comment: *

Name: *

Email: *

Verification: *

Which authentication method requires access to a secure file that is only stored on the user's local device?

• A.Key-pair authentication
• B.Password authentication
• C.Federated authentication
• D.Multi-Factor Authentication (MFA)

Comment: *

Name: *

Email: *

Verification: *