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?
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 is A
To avoid the performance impact for elements that were not extracted, do the following:
Extract semi-structured data elements containing ânullâ values into relational columns before you load them.
Alternatively, if the ânullâ values in your files indicate missing values and have no other special meaning, we recommend setting the file format option STRIP_NULL_VALUES to TRUE when you load the semi-structured data files. This option removes OBJECT elements or ARRAY elements containing ânullâ values.
Option A seems more relevant: JSON with a ânullâ value will have a query performance impact.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MSIDDIQUI18
2Â weeks, 3Â days agoakellaanurag
3Â weeks, 1Â day agoh8er
7Â months agojigsaa7
7Â months, 1Â week agoAtomic_Gecko
8Â months, 2Â weeks ago