Question 620
A VARIANT holds a nested event.source.region path and the analyst needs its value via a function. What function suits?
Explanation
Correct Answer
Correct for path-based retrieval: GET_PATH retrieves a nested value from semi-structured data using a path.
Incorrect Answers
Not the right operation for path-based retrieval: ARRAY_AGG aggregates input values into an ARRAY.
Not the right operation for path-based retrieval: OBJECT_AGG aggregates key-value pairs into an OBJECT.
Not the right operation for path-based retrieval: ARRAY_CONTAINS checks whether a value is present in an ARRAY.