Free COF-C02 Exam Braindumps
SnowPro Core Questions 416–420 (page: 85)

Updated On: 10-Feb-2026

Which Snowflake tool would be BEST to troubleshoot network connectivity?

  1. SnowCLI
  2. SnowUI
  3. SnowSQL
  4. SnowCD

Answer(s): D



Increasing the size of a virtual warehouse from an X-Small to an X-Large is an example of which of the following?

  1. Right sizing
  2. Concurrent sizing
  3. Scaling out
  4. Scaling up

Answer(s): D



What are ways to create and manage data shares in Snowflake? (Choose two.)

  1. Through the Snowflake web interface (UI)
  2. Through the DATA_SHARE=TRUE parameter
  3. Through SQL commands
  4. Through the ENABLE_SHARE=TRUE parameter
  5. Using the CREATE SHARE AS SELECT * FROM TABLE command

Answer(s): A,C



What is a characteristic of data micro-partitioning in Snowflake?

  1. Micro-partitioning may introduce data skew
  2. Micro-partitioning requires the definition of a partitioning schema
  3. Micro-partitioning happens when the data is loaded
  4. Micro-partitioning can be disabled within a Snowflake account

Answer(s): C



Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?

  1. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
  2. Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user
  3. Can SHOW users, INDEX a given user, or ALTER or DELETE a user
  4. Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user

Answer(s): A



Viewing page 85 of 221
Viewing questions 421 - 425 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!