Free COF-C02 Exam Braindumps
SnowPro Core Questions 391–395 (page: 80)

Updated On: 10-Feb-2026

Which of the following commands cannot be used within a reader account?

  1. CREATE SHARE
  2. ALTER WAREHOUSE
  3. DROP ROLE
  4. SHOW SCHEMAS
  5. DESCRIBE TABLE

Answer(s): A



Which TABLE function helps to convert semi-structured data to a relational representation?

  1. CHECK_JSON
  2. TO_JSON
  3. FLATTEN
  4. PARSE_JSON

Answer(s): C



Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  1. Bytes sent over network
  2. Percentage scanned from cache
  3. Partitions total
  4. Bytes spilled to local storage
  5. Partitions scanned

Answer(s): C,E



What are the default Time Travel and Fail-safe retention periods for transient tables?

  1. Time Travel - 1 day, Fail-safe - 1 day
  2. Time Travel - 0 days, Fail-safe - 1 day
  3. Time Travel - 1 day, Failsafe - 0 days
  4. Transient tables are retained in neither Fail-safe nor Time Travel.

Answer(s): C



Which command is used to unload data from a Snowflake table into a file in a stage?

  1. COPY INTO
  2. GET
  3. WRITE
  4. EXTRACT INTO

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=a%20Table%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,the%20stage%20for%20the%20table



Viewing page 80 of 221
Viewing questions 396 - 400 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!