What compute resource is used when loading data using Snowpipe?

• A.Snowpipe uses virtual warehouses provided by the user.
• B.Snowpipe uses an Apache Kafka server for its compute resources.
• C.Snowpipe uses compute resources provided by Snowflake.
• D.Snowpipe uses cloud platform compute resources provided by the user.

Comment: *

Name: *

Email: *

Verification: *

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

• A.1 hour
• B.2 hours
• C.4 hours
• D.8 hours

Comment: *

Name: *

Email: *

Verification: *

In which hierarchy is tag inheritance possible?

• A.Organization - Account- Role
• B.Account - User - Schema
• C.Database - View - Column
• D.Schema - Table - Column

Comment: *

Name: *

Email: *

Verification: *

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

• A.Create a view on the table.
• B.Add a clustering key to the table
• C.Add a limit clause to the query.
• D.Add a Dynamic Data Masking policy to the table.

Comment: *

Name: *

Email: *

Verification: *

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

• A.Pruning
• B.Spilling
• C.Initialization
• D.Local Disk I/O
• E.Percentage of data read from cache

Comment: *

Name: *

Email: *

Verification: *