Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

• A.Caching
• B.Cluster depth
• C.Query pruning
• D.Retrieval optimization

Comment: *

Name: *

Email: *

Verification: *

What is the MAXIMUM Time Travel retention period for a transient table?

• A.90 days
• B.1 day
• C.7 days
• D.O days

Comment: *

Name: *

Email: *

Verification: *

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

• A.Tri-Secret Secure
• B.Time Travel
• C.Fail-safe
• D.Data encryption
• E.External stages

Comment: *

Name: *

Email: *

Verification: *

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

• A.View
• B.Secure view
• C.Materialized view
• D.External table

Comment: *

Name: *

Email: *

Verification: *

What is a Snowflake recommendation for the use of key pair authentication?

• A.Keys should be stored in a secure location on the ACCOUNTADMIN file system.
• B.Operator access should be limited to read-only access.
• C.Key pair rotation should be automated.
• D.Role access should be designed to cover the operations that the user account anticipates needing.

Comment: *

Name: *

Email: *

Verification: *