Free COF-C02 Exam Braindumps
SnowPro Core Questions 466–470 (page: 95)

Updated On: 10-Feb-2026

What technique does Snowflake recommend for determining which virtual warehouse size to select?

  1. Always start with an X-Small and increase the size if the query does not complete in 2 minutes
  2. Experiment by running the same queries against warehouses of different sizes
  3. Use the default size Snowflake chooses
  4. Use X-Large or above for tables larger than 1 GB

Answer(s): B



Which command should be used when loading many flat files into a single table?

  1. PUT
  2. INSERT
  3. COPY INTO
  4. MERGE

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html



How can a Snowflake user share data with another user who does not have a Snowflake account?

  1. Share the data by implementing User-Defined Functions (UDFs)
  2. Create a reader account and create a share of the data
  3. Grant the READER privilege to the database that is going to be shared
  4. Move the Snowflake account to a region where data sharing is enabled

Answer(s): B



Which semi-structured data formats can be loaded into Snowflake with a COPY command? (Choose two.)

  1. CSV
  2. EDI
  3. HTML
  4. ORC
  5. XML

Answer(s): D,E



Which statements reflect valid commands when using secondary roles? (Choose two.)

  1. USE SECONDARY ROLES RESUME
  2. USE SECONDARY ROLES SUSPEND
  3. USE SECONDARY ROLES ALL
  4. USE SECONDARY ROLES ADD <Role Name>
  5. USE SECONDARY ROLES NONE

Answer(s): C,E



Viewing page 95 of 221
Viewing questions 471 - 475 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!