nerdexam
Snowflake

COF-R02 · Question #208

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

The correct answer is B. json_extract_path_text(). See the full explanation below for the reasoning.

Question

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options

  • Aparse_json()
  • Bjson_extract_path_text()
  • Cobject_construct()
  • Dflatten

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    72% (23)
  • C
    3% (1)
  • D
    9% (3)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice