SnowPro Advanced: Architect — Question 75

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported.

What could be causing this?

Answer options

• A. There were JSON nulls in the recent data imports.
• B. The order of the keys in the JSON was changed.
• C. The recent data imports contained fewer fields than usual.
• D. There were variations in string lengths for the JSON values in the recent data imports.

Correct answer: A

Explanation

The correct answer is A because JSON nulls can lead to inefficiencies in query performance as they may require additional handling during processing. The order of keys (option B) does not affect the performance since JSON is key-value based. Fewer fields (option C) or variations in string lengths (option D) could also impact performance, but they are less likely to cause significant issues compared to the presence of JSON nulls.