Which of the following can be executed/called with Snowpipe?

• A.A single copy_into statement
• B.A User Defined Function (UDF)
• C.A single insert__into statement
• D.A stored procedure

Comment: *

Name: *

Email: *

Verification: *

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

• A.The shared objects are transferred.
• B.The shared objects are copied.
• C.The shared objects become accessible.
• D.The shared objects can be re-shared.

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

• A.Snowflake leverages a Role-Based Access Control (RBAC) model.
• B.Snowflake requires a user to configure an IAM user to connect to the database.
• C.All data in Snowflake is encrypted.
• D.Snowflake can run within a user's own Virtual Private Cloud (VPC).
• E.All data in Snowflake is compressed.

Comment: *

Name: *

Email: *

Verification: *

Which type of workload traditionally benefits from the use of the query acceleration service?

• A.Workloads with a predictable data volume for each query
• B.Workloads that include on-demand data analyses
• C.Queries with small scans and non-selective filters
• D.Queries that do not have filters or aggregation

Comment: *

Name: *

Email: *

Verification: *

Which common query issues can be identified by the Query Profile? (Select TWO).

• A.Insufficient credit quota
• B.Inefficient query pruning
• C.Excessive query pruning
• D.Exploding joins
• E.Credit usage that exceeds a set threshold

Comment: *

Name: *

Email: *

Verification: *