Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

• A.DELETE
• B.DROP
• C.REMOVE
• D.TRUNCATE

Comment: *

Name: *

Email: *

Verification: *

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

• A.A table where the values are evenly distributed across all micro-partitions, with each micro-partition containing a random mix of values from A to Z.
• B.A table where the values are clustered randomly, with some micro-partitions containing many records while others contain only a few.
• C.A table where the values are grouped in a sorted or ordered manner, with micro-partitions containing contiguous ranges of values (e.g., A-D in one partition, E-H in another, etc.).
• D.A table where the values are completely unclustered, and each micro-partition has records from completely different value ranges.

Comment: *

Name: *

Email: *

Verification: *

What metrics will the show tables command in Snowsight provide?

• A.Retained for clone bytes
• B.Fail-safe bytes
• C.Active bytes
• D.Time Travel bytes

Comment: *

Name: *

Email: *

Verification: *

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

• A.0 days
• B.1 day
• C.7 days
• D.14 days

Comment: *

Name: *

Email: *

Verification: *

When does a materialized view get suspended in Snowflake?

• A.When a column is added to the base table
• B.When a column is dropped from the base table
• C.When a DML operation is run on the base table
• D.When the base table is reclustered

Comment: *

Name: *

Email: *

Verification: *