A user accidentally deletes a table and wants to restore it. The table was created 3 days ago, and the warehouse has a data retention period of 1 day. What is the most likely outcome?

The table cannot be restored because the retention period has expired

The table can be restored using a clone from 2 days ago

The table can be restored by resuming the warehouse

The table can be restored using Time Travel because the retention period is 1 day

How is storage billed in Snowflake?

Per gigabyte of data scanned by queries

Per terabyte of data stored per month

A team has a multi-cluster warehouse with min clusters = 1 and max clusters = 5. During a peak period, all 5 clusters are active. After the peak, the workload drops. What happens to the extra clusters?

They are immediately terminated when the workload drops

They continue running and incur credits until the warehouse is suspended

They are automatically suspended after a period of inactivity, down to the minimum number of clusters

They remain active until manually suspended

A company has a warehouse with auto-suspend set to 10 minutes and auto-resume enabled. They notice that the warehouse is frequently resuming and suspending throughout the day, leading to startup delays for users. They want to reduce these delays without significantly increasing costs. What is the best action?

Increase the auto-suspend timeout to 30 minutes

How do micro-partitions improve query performance?

By storing data in memory for faster access

By compressing data to reduce I/O

By indexing every column for faster lookups

By allowing queries to skip irrelevant data through pruning

SnowPro® Core Certification

Domain 1Objective 3

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

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 26–30

26application · medium
A user accidentally deletes a table and wants to restore it. The table was created 3 days ago, and the warehouse has a data retention period of 1 day. What is the most likely outcome?
Select an answer first
27foundation · easy
How is storage billed in Snowflake?
Select an answer first
28application · medium
A team has a multi-cluster warehouse with min clusters = 1 and max clusters = 5. During a peak period, all 5 clusters are active. After the peak, the workload drops. What happens to the extra clusters?
Select an answer first
29expert · hard
A company has a warehouse with auto-suspend set to 10 minutes and auto-resume enabled. They notice that the warehouse is frequently resuming and suspending throughout the day, leading to startup delays for users. They want to reduce these delays without significantly increasing costs. What is the best action?
Select an answer first
30foundation · easy
How do micro-partitions improve query performance?
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.