Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

• A.The new query is run using the same virtual warehouse as the previous query
• B.The user has the appropriate privileges on the objects associated with the query
• C.The query has been run within 24 hours of the previously-run query
• D.The query includes a User Defined Function (UDF)
• E.Micro-partitions have been reclustered since the query was last run

Comment: *

Name: *

Email: *

Verification: *

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

• A.Bytes written
• B.Partitions scanned
• C.Bytes read from result
• D.Partitions total
• E.Bytes scanned

Comment: *

Name: *

Email: *

Verification: *

Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

• A.Free listing
• B.Paid listing
• C.Direct share
• D.Data Exchange

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A.Customer-managed encryption keys through Tri-Secret Secure
• B.Up to 90 days of data recovery through Time Travel
• C.Column-level security to apply data masking policies to tables and views
• D.Automatic encryption of all data
• E.Object-level access control

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

• A.Storage expands without the requirement to add more compute
• B.Growth of storage and compute are tightly coupled together
• C.Multiple compute clusters can access stored data without contention
• D.Compute can be scaled up or down without the requirement to add more storage

Comment: *

Name: *

Email: *

Verification: *