A company has a multi-cluster warehouse with min clusters = 1 and max clusters = 4. They notice that during peak hours, all 4 clusters are active, but some queries still experience delays. They want to reduce delays without significantly increasing costs. What should they consider?

Increase the warehouse size of each cluster

Review query patterns and consider workload isolation

Set auto-suspend to a longer timeout

A data engineer notices that queries on a large fact table are scanning more data than necessary. The table is clustered on a date column, and most queries filter on that column. The engineer wants to reduce the amount of data scanned per query. What feature of Snowflake's storage layer is most directly responsible for this optimization?

Separation of compute and storage

What is the impact of Time Travel on storage costs in Snowflake?

It shifts storage costs to compute costs

It decreases storage costs by compressing historical data

It has no effect on storage costs

It increases storage costs because it retains historical versions of data

What is a key benefit of separating compute and storage in Snowflake?

You can run queries without any compute resources

You must use the same cloud provider for both compute and storage

You can scale compute and storage independently to optimize cost and performance

You can store data directly on the virtual warehouse

A company runs a daily reporting workload that is predictable and has low concurrency. They want to minimize compute costs while ensuring the workload completes within a reasonable time. What is the most cost-effective approach?

Use a multi-cluster warehouse with min clusters set to 2

Use a multi-cluster warehouse with max clusters set to 10

Use a single X-Small warehouse and set auto-suspend to a short timeout

Use a 6XL warehouse to ensure the job finishes quickly

SnowPro® Core Certification

Domain 1Objective 3

Describe the Compute (virtual Warehouse) and Storage Layers COF-C03 Practice Questions (Page 3)

Part of the Snowflake AI Data Cloud Features and Architecture domain, which accounts for 31% of the COF-C03 exam.

34questions here

7free pages

10concepts

31%of the exam

Questions 11–15

11expert · hard
A company has a multi-cluster warehouse with min clusters = 1 and max clusters = 4. They notice that during peak hours, all 4 clusters are active, but some queries still experience delays. They want to reduce delays without significantly increasing costs. What should they consider?
Select an answer first
12application · medium
A data engineer notices that queries on a large fact table are scanning more data than necessary. The table is clustered on a date column, and most queries filter on that column. The engineer wants to reduce the amount of data scanned per query. What feature of Snowflake's storage layer is most directly responsible for this optimization?
Select an answer first
13foundation · easy
What is the impact of Time Travel on storage costs in Snowflake?
Select an answer first
14foundation · easy
What is a key benefit of separating compute and storage in Snowflake?
Select an answer first
15application · medium
A company runs a daily reporting workload that is predictable and has low concurrency. They want to minimize compute costs while ensuring the workload completes within a reasonable time. What is the most cost-effective approach?
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.