問題文
A team reads a folder of comma-separated files from a stage. They notice that reading a JSON file gives a single column while their CSV read fails without extra setup. Which statement explains the difference?
選択肢
- A CSV read requires the copy option that matches names to columns of the file, while JSON is matched by position and therefore needs nothing.
- A CSV read needs an explicit file format object, while JSON uses a built-in default that the reader applies automatically, so neither call needs a schema.
- A CSV read needs the file to be uncompressed, while JSON in the stage can be read in compressed form without any option.
- A CSV read needs a schema supplied to the reader, while other formats such as JSON are treated as one column of the variant type named with a dollar sign and the digit one.