Snowflake cof-r02 practice test

SnowPro Core Recertification Exam

Last exam update: Nov 18 ,2025
Page 1 out of 22. Viewing questions 1-15 out of 330

Question 1

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

  • A. True
  • B. False
Mark Question:
Answer:

B


Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 2

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in
what?
Select one.

  • A. More micro-partitions
  • B. Better query scheduling
  • C. Double the numbers of servers In the compute duster
  • D. Higher storage costs
Mark Question:
Answer:

C


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

Which of the following statement is true of Snowflake?
Select one.

  • A. It was built specifically for the cloud
  • B. it was built as an on-premises solution and then potted to the cloud
  • C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  • D. It was built for Hadoop architecture
  • E. It's based on an Oracle Architecture
Mark Question:
Answer:

A


User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

  • A. The complexity of each query
  • B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
  • C. The size of the data required for each query
  • D. The tool that s executing the query
Mark Question:
Answer:

A, C


Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

Which of the following statements would be used to export/unload data from Snowflake?

  • A. COPY INTO @stage
  • B. EXPORT TO @stage
  • C. INSERT INTO @stage
  • D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Mark Question:
Answer:

A


Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

True or False: It is possible to unload structured data to semi-structured formats such as JSON and
parquet.

  • A. True
  • B. False
Mark Question:
Answer:

A


Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 7

What are the three layers that make up Snowflake’s architecture?
Choose 3 answer

  • A. Compute
  • B. Tri-Secret Secure
  • C. Storage
  • D. Cloud Services
Mark Question:
Answer:

A, C, D


Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which type of table corresponds to a single Snowflake session?

  • A. Temporary
  • B. Translent
  • C. Provisional
  • D. Permanent
Mark Question:
Answer:

A


Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL
data, session-specific data). Temporary tables only exist within the session in which they were
created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remaind
er%20of%20the%20session
.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

True or False: It is possible to query data from an Internal or named External stage without loading
the data into Snowflake.

  • A. True
  • B. False
Mark Question:
Answer:

A


User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 10

True or False: Snowflake allows its customers to directly access the micro-partition files that make up
its tables.

  • A. True
  • B. False
Mark Question:
Answer:

B


User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 11

True or False: Micro-partition metadata enables some operations to be completed without requiring
Compute.

  • A. True
  • B. False
Mark Question:
Answer:

A


Explanation:
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 12

Which of the following are options when creating a Virtual Warehouse?

  • A. Auto-suspend
  • B. Auto-resume
  • C. Local SSD size
  • D. User count
Mark Question:
Answer:

A, B


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

Which of the following DML commands isn’t supported by Snowflake?

  • A. UPSERT
  • B. MERGE
  • C. UPDATE
  • D. TRUNCATE TABLE
Mark Question:
Answer:

A


Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also
use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  • A. True
  • B. False
Mark Question:
Answer:

B


Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/connecting.html

User Votes:
A
50%
B
50%
Discussions
vote your answer:
A
B
0 / 1000

Question 15

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

  • A. A multi-cluster Warehouse can add clusters automatically based on query activity
  • B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
  • C. A multi-cluster Warehouse can scale down when query activity slows
  • D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Mark Question:
Answer:

A, B, C, D


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2