Snowflake SnowPro Core Certification - COF-C01 Exam Practice Test
Question 1
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Correct Answer: A
Question 2
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)
Choose 2 answers
Choose 2 answers
Correct Answer: A,C
Question 3
Which of the following commands sets the Virtual Warehouse for a session?
Correct Answer: B
Question 4
Which of the following are options when creating a Virtual Warehouse?
Correct Answer: A,D
Question 5
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
Correct Answer: B
Question 6
True or False: Fail-safe can be disabled within a Snowflake account.
Correct Answer: B
Question 7
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
Correct Answer: B
Question 8
The PUT command: (Choose two.)
Correct Answer: C,D
Question 9
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Correct Answer: B
Question 10
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Correct Answer: A
Question 11
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
Correct Answer: B
