Free COF-C02 Exam Braindumps
SnowPro Core Questions 556–560 (page: 113)

Updated On: 10-Feb-2026

While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

  1. SKIP_BYTE_ORDER_MARK
  2. STRIP_NULL_VALUE
  3. STRIP_OUTER_ARRAY
  4. STRIP_OUTER_ELEMENT

Answer(s): C



Which functions can be used to share unstructured data through a secure view? (Choose two.)

  1. BUILD_SCOPED_FILE_URL
  2. BUILD_STAGE_FILE_URL
  3. GET_ABSOLUTE_PATH
  4. GET_PRESIGNED_URL
  5. GET_RELATIVE_PATH

Answer(s): A,D



Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

  1. CAST
  2. FLATTEN
  3. GET
  4. PARSE_JSON

Answer(s): B



What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

  1. 1 Kilobyte (KB)
  2. 1 Megabyte (MB)
  3. 1 Gigabyte (GB)
  4. 1 Terabyte (TB)

Answer(s): D



For the ALLOWED_VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

  1. 10
  2. 50
  3. 54
  4. 256

Answer(s): B



Viewing page 113 of 221
Viewing questions 561 - 565 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!