What does a clustering depth value of 1 indicate about a table's clustering?

The table is poorly clustered and needs manual reclustering

The table has no clustering key defined

The table has exactly one micro-partition

The table is perfectly clustered on its clustering key

Which SQL command enables Search Optimization on a Snowflake table?

CREATE SEARCH INDEX ON TABLE ...

ALTER TABLE ... ENABLE SEARCH OPTIMIZATION

ALTER TABLE ... ADD SEARCH OPTIMIZATION

A data team has a large `events` table with a clustering key on `event_date`. They notice that automatic clustering is not keeping up with the volume of new data, and clustering depth is increasing. They want to improve performance without incurring excessive costs. Which approach should they take?

Disable automatic clustering and rely on manual reclustering only.

Change the clustering key to a column with lower cardinality.

Manually recluster the table after each bulk load.

Schedule manual reclustering during off-peak hours and keep automatic clustering enabled.

What triggers automatic clustering in Snowflake?

The table is created with a clustering key

A query that filters on the clustering key is executed

A user manually runs ALTER TABLE ... CLUSTER BY

The table's clustering depth exceeds a threshold after DML operations

SnowPro® Core Certification

Domain 2Objective 2

Use Clustering and the Search Optimization Service COF-C03 Practice Questions (Page 1)

Part of the Performance Optimization, Querying, and Transformation domain, which accounts for 21% of the COF-C03 exam.

24questions here

5free pages

9concepts

21%of the exam

Questions 1–5

1foundation · easy
What does a clustering depth value of 1 indicate about a table's clustering?
Select an answer first
2foundation · easy
Which SQL command enables Search Optimization on a Snowflake table?
Select an answer first
3foundation · easy
Which Snowflake feature relies on clustering keys to reduce the amount of data scanned during query execution?
Select an answer first
4expert · hard
A data team has a large `events` table with a clustering key on `event_date`. They notice that automatic clustering is not keeping up with the volume of new data, and clustering depth is increasing. They want to improve performance without incurring excessive costs. Which approach should they take?
Select an answer first
5foundation · easy
What triggers automatic clustering in Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.