問題文
An analyst is asked to load a set of JSON files that arrive with a different set of keys each week. The downstream reports only ever read three of the keys, but the team wants to keep every key available for later investigation without editing the table definition each week. Which table design meets this need?
選択肢
- Flatten every document into rows of key and value pairs, at load time, and discard the original document structure.
- Create one VARCHAR column per key seen in the first week and add new columns with ALTER TABLE whenever an unfamiliar key appears in a file.
- Load each JSON document into a single VARIANT column, and expose the three reported keys through a view that extracts them by path.
- Store the raw text of each document in a VARCHAR column and parse it with string functions inside every report query.