Free COF-C02 Exam Braindumps
SnowPro Core Questions 261–265 (page: 54)

Updated On: 10-Feb-2026

What is a responsibility of Snowflake’s virtual warehouses?

  1. Infrastructure management
  2. Metadata management
  3. Query execution
  4. Query parsing and optimization
  5. Management of the storage layer

Answer(s): C



Which data type is supported by Snowflake data classification?

  1. Binary
  2. Float
  3. Geography
  4. Variant

Answer(s): B



When unloading data to an external stage, which compression format can be used for Parquet files with the COPY INTO command?

  1. BROTLI
  2. GZIP
  3. LZO
  4. ZSTD

Answer(s): C



Which SQL command can be used to verify the privileges that are granted to a role?

  1. SHOW GRANTS ON ROLE
  2. SHOW ROLES
  3. SHOW GRANTS TO ROLE
  4. SHOW GRANTS FOR ROLE

Answer(s): C



Which Query Profile result indicates that a warehouse is sized too small?

  1. There are a lot of filter nodes.
  2. Bytes are spilling to external storage.
  3. The number of processed rows is very high.
  4. The number of partitions scanned is the same as partitions total.

Answer(s): B



Viewing page 54 of 221
Viewing questions 266 - 270 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!