Snowflake COF-C02 SnowPro Core Certification Exam Exam Practice Test Questions

• Question 1

  Which command can be used to list all the file formats for which a user has access privileges?

  • LIST
  • ALTER FILE FORMAT
  • DESCRIBE FILE FORMAT
  • SHOW FILE FORMATS

  Show Answer Answer: D Next

• Question 2

  Using variables in Snowflake is denoted by using which SQL character?

  • @
  • &
  • $
  • #

  Show Answer Answer: C Next

• Question 3

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

  • Bytes sent over network
  • Percentage scanned from cache
  • Partitions total
  • Bytes spilled to local storage
  • Partitions scanned

  Show Answer Answer: C, E Next

• Question 4

  What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

  • 1 minutes
  • 5 minutes
  • 10 minutes
  • 15 minutes

  Show Answer Answer: C Next

• Question 5

  What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into <location> command used during data unloading? (Select TWO).

  • Single quote character (')
  • NULL
  • 'NULL'
  • NONE
  • 'NONE'

  Show Answer Answer: A, B Next