Snowflake COF-C02 Exam Questions
SnowPro Core (Page 42 )

Updated On: 17-Feb-2026

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

  1. The ability to scale up warehouses
  2. The use of warehouse auto scaling
  3. The ability to resize warehouses
  4. Use of multi-clustered warehouses
  5. The use of warehouse indexing

Answer(s): B,D



Which COPY INTO command outputs the data into one file?

  1. SINGLE=TRUE
  2. MAX_FILE_NUMBER=1
  3. FILE_NUMBER=1
  4. MULTIPLE=FALSE

Answer(s): A



In which scenarios would a user have to pay Cloud Services costs? (Choose two.)

  1. Compute Credits = 50 Credits Cloud Services = 10
  2. Compute Credits = 80 Credits Cloud Services = 5
  3. Compute Credits = 100 Credits Cloud Services = 9
  4. Compute Credits = 120 Credits Cloud Services = 10
  5. Compute Credits = 200 Credits Cloud Services = 26

Answer(s): A,E



A user created a new worksheet within the Snowsight UI and wants to share this with teammates.
How can this worksheet be shared?

  1. Create a zero-copy clone of the worksheet and grant permissions to teammates.
  2. Create a private Data Exchange so that any teammate can use the worksheet.
  3. Share the worksheet with teammates within Snowsight.
  4. Create a database and grant all permissions to teammates.

Answer(s): C



How can a row access policy be applied to a table or a view? (Choose two.)

  1. Within the policy DDL
  2. Within the create table or create view DDL
  3. By future APPLY for all objects in a schema
  4. Within a control table
  5. Using the command ALTER

Answer(s): B,E






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

Join the COF-C02 Discussion