Free COF-C02 Exam Braindumps
SnowPro Core Questions 566–570 (page: 115)

Updated On: 10-Feb-2026

A Snowflake user wants to unload data from a relational table sized 5 GB using CSV. The extract needs to be as performant as possible.

What should the user do?

  1. Use Parquet as the unload file format, using Parquet's default compression feature.
  2. Use a regular expression in the stage specification of the COPY command to restrict parsing time.
  3. Increase the default MAX_FILE_SIZE to 5 GB and set SINGLE = true to produce a single file.
  4. Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.

Answer(s): D



How is the MANAGE GRANTS privilege applied?

  1. Globally
  2. At the database level
  3. At the schema level
  4. At the table level

Answer(s): A



What is required for a query execution to be served from the result cache?

  1. The user is the same.
  2. The SQL texts the same.
  3. The SQL query profile is the same.
  4. The virtual warehouse is the same.

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/querying-persisted-results.html#:~:text=If%20the%20query%20was%20a,that%20generated%20the%20cached%20results



Which Snowflake URL type is used by directory tables?

  1. File
  2. Pre-signed
  3. Scoped
  4. Virtual-hosted style

Answer(s): A



At which point is data encrypted when using a PUT command?

  1. When it reaches the virtual warehouse
  2. When it gets micro-partitioned
  3. Before it is sent from the user's machine
  4. After it reaches the internal stage

Answer(s): C


Reference:

https://hevodata.com/learn/snowflake-encryption/#:~:text=Snowflake%20Encryption%20automatically%20encrypts%20files,staging%20area%20supplied%20by%20Snowflake



Viewing page 115 of 221
Viewing questions 571 - 575 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!