Snowpro Core · Free Practice Question Medium
Question 98
As the database administrator, you defined new clustering keys for a large table. So, while Snowflake re-clusters data, what should you expect? Select all that apply.
- A SELECT queries are blocked from execution while Snowflake redistributes data in micro-partitions.
- B DML queries continue to execute as normal while Snowflake redistributes data in micro-partitions.
- C DML queries are disallowed while Snowflake redistributes data in micro-partitions.
- D SELECT queries continue to execute as normal while Snowflake redistributes data in micro-partitions.
Reveal correct answers
Correct answers: B, D
Explanation
Snowflake's re-clustering operation is transparent to the user and does not block any DML or SELECT queries. A table that is being re-clustered will behave exactly like any other table when being queried, updated, or changed. https://docs.snowflake.com/en/user-guide/tables-auto-reclustering#non-blocking-dmlDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
