SnowPro Core Recertification Exam
COF-R02 Exam

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

  1. True
  2. False

Answer(s): B


Reference:

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



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

  1. More micro-partitions
  2. Better query scheduling
  3. Double the numbers of servers In the compute duster
  4. Higher storage costs

Answer(s): C



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

  1. It was built specifically for the cloud
  2. it was built as an on-premises solution and then potted to the cloud
  3. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
  4. It was built for Hadoop architecture
  5. It's based on an Oracle Architecture

Answer(s): A



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

  1. The complexity of each query
  2. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
  3. The size of the data required for each query
  4. The tool that s executing the query

Answer(s): A,C


Reference:

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




Parag
Hi, Let me appreciate your Study Guide. I passed the exam with 92%. All the questions were from the study guide. I am still wondering where I went wrong for not scoring 100%. I will not hesitate to recommend your site to my friends and colleagues. Thanks
- UNITED STATES
Upvote


J M
Hello, I purchased your 640-801 last week and I was able to pass my exam with 96%. The questions were all the same. I wondering how you guys do it? Keep up the good job. I appreciate your service and your best price. Thanks
- UNITED STATES
Upvote

Read more ...