Snowflake COF-C03: SnowPro Core Certification

Last checked October 22, 2026 against the official Snowflake exam page.

1. Question 1Snowflake Architecture and Key Features

   Snowflake separates storage from compute. Which layer provides the virtual warehouses that execute queries?

   1. AStorage layer
   2. BCloud services layer
   3. CCompute layer
   4. DMetadata catalog layer
   Show answer and explanationHide answer

   Correct answer: C

   Virtual warehouses form the compute layer, and they can scale independently of stored data. The cloud services layer handles authentication, metadata and query compilation, and the storage layer holds the micro-partitions.

2. Question 2Account Access and Security

   A security administrator needs a role that creates users and roles but does not own databases or warehouses. Which system role fits this?

   1. AACCOUNTADMIN
   2. BUSERADMIN
   3. CPUBLIC
   4. DSYSADMIN
   Show answer and explanationHide answer

   Correct answer: B

   USERADMIN manages users and roles and is designed for identity administration without owning data objects. ACCOUNTADMIN has the broadest account rights, SYSADMIN owns databases and warehouses, and PUBLIC is granted to everyone by default.

3. Question 3Performance Concepts

   An identical query is run again within 24 hours, and the underlying data has not changed. Which cache returns the result without using a running warehouse?

   1. AResult cache
   2. BLocal disk cache
   3. CMetadata cache
   4. DRemote storage cache
   Show answer and explanationHide answer

   Correct answer: A

   The result cache stores query results for up to 24 hours and returns them without a warehouse when the data is unchanged. The local disk cache lives on the warehouse, and the metadata cache helps compilation rather than returning results.

4. Question 4Data Loading and Unloading

   Which command loads data from files in a stage into a table?

   1. APUT
   2. BLIST
   3. CCOPY INTO table
   4. DGET
   Show answer and explanationHide answer

   Correct answer: C

   COPY INTO table reads staged files and loads them into the target table. PUT uploads local files to a stage, GET downloads files from a stage, and LIST shows the files present.

5. Question 5Data Transformations

   A pipeline must capture inserts, updates and deletes made to a table so that a downstream process can consume only the changes. Which object provides this change tracking?

   1. ASequence
   2. BStream
   3. CTask
   4. DPipe
   Show answer and explanationHide answer

   Correct answer: B

   A stream records changes to a table since its last offset, which enables change data capture. A task runs SQL on a schedule, a pipe loads files, and a sequence generates numbers.