How does Snowflake utilize clustering information to improve query performance?

• A.It prunes unnecessary micro-partitions based on clustering metadata.
• B.It compresses the data within micro-partitions for faster querying.
• C.It automatically allocates additional resources to improve query execution.
• D.It organizes clustering information to speed-up data retrieval from storage

Comment: *

Name: *

Email: *

Verification: *

What objects can be cloned within Snowflake? (Select TWO).

• A.Schemas
• B.Users
• C.External tables
• D.Internal named stages
• E.External named stages

Comment: *

Name: *

Email: *

Verification: *

Which pages are included in the Activity area of Snowsight? (Select TWO).

• A.Contacts
• B.Sharing settings
• C.Copy History
• D.Query History
• E.Automatic Clustering History

Comment: *

Name: *

Email: *

Verification: *

What Snowflake service or feature can be used to ensure that Snowflake-hosted data is still available if an account becomes inaccessible because of a regional cloud service provider outage?

• A.Time Travel
• B.Fail-safe
• C.A data share
• D.Cross-region replication

Comment: *

Name: *

Email: *

Verification: *

The customer table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? {Select TWO).

• A.SELECT privilege on the customer table
• B.ownership privilege on the customer table
• C.All privileges on the T1 database
• D.All privileges on the customer table
• E.CREATE TABIE privilege on the T1 database

Comment: *

Name: *

Email: *

Verification: *