Which command enables the search optimization service on a Snowflake table?

ALTER TABLE ... ENABLE SEARCH OPTIMIZATION

ALTER TABLE ... ADD SEARCH INDEX

What is the primary purpose of defining a clustering key on a large Snowflake table?

To improve query performance by co-locating similar values in micro-partitions

To distribute data evenly across warehouses

To automatically compress the table to reduce storage

To enforce uniqueness of rows in the table

What is a common technique to reduce the amount of data processed in a query that joins two large tables?

Filtering rows in each table before the join using WHERE clauses

Using SELECT * to retrieve all columns

Removing all WHERE clauses to let the optimizer decide

Using a CROSS JOIN to combine all rows

A table stores `order_id` as a VARCHAR(50) and `order_total` as a NUMBER(38,2). Queries frequently filter on `order_id` and aggregate `order_total`. The table has 500 million rows. The team notices that queries are slow and want to optimize the schema. What is the most effective schema change?

Create a materialized view on the aggregation.

Add a clustering key on `order_total`.

Change `order_id` to a NUMBER if it contains only digits.

SnowPro® Core Certification

Domain 2Objective 1

Optimize Query Performance COF-C03 Practice Questions (Page 2)

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

29questions here

6free pages

10concepts

21%of the exam

Questions 6–10

6foundation · easy
Which command enables the search optimization service on a Snowflake table?
Select an answer first
7foundation · easy
What is the primary purpose of defining a clustering key on a large Snowflake table?
Select an answer first
8foundation · easy
What is a common technique to reduce the amount of data processed in a query that joins two large tables?
Select an answer first
9application · medium
A table stores `order_id` as a VARCHAR(50) and `order_total` as a NUMBER(38,2). Queries frequently filter on `order_id` and aggregate `order_total`. The table has 500 million rows. The team notices that queries are slow and want to optimize the schema. What is the most effective schema change?
Select an answer first
10foundation · easy
Which Snowflake command is used to define a clustering key on an existing table?
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.