Snowflake SnowPro Core Certification - COF-C01 Exam Practice Test
In which layer of its architecture does Snowflake store its metadata statistics?
Correct Answer: B
Vote an answer
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
Correct Answer: A,D
Vote an answer
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Correct Answer: B
Vote an answer
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Correct Answer: D
Vote an answer
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
Correct Answer: A
Vote an answer
True or False: Snowflake supports federated authentication in all editions.
Correct Answer: B
Vote an answer
What is the minimum duration charged when starting a virtual warehouse?
Correct Answer: D
Vote an answer
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers
Correct Answer: A,B
Vote an answer
The FLATEEN function is used to query which type of data in Snowflake?
Correct Answer: B
Vote an answer
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
Correct Answer: A,B,C,D
Vote an answer
What is the minimum Snowflake edition that provides data sharing?
Correct Answer: D
Vote an answer
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Correct Answer: C
Vote an answer
Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)
Correct Answer: A,B,D
Vote an answer