A data engineer has created a data pipeline that ingests data from a JSON source using Auto Loader. However, the engineer did not include any type inference or schema hints in their pipeline. After evaluating the data, the engineer found that all the columns in the target table are of the string type, even though some fields contain only float or boolean values. Which of the following explains why Auto Loader inferred all the columns to be of the string type?

Exam-Like

There was a type mismatch between the specific schema and the inferred schema

9.3%

Because JSON does not encode data types, Auto Loader defaults to inferring all columns as strings to avoid schema evolution issues.

63.9%

Auto Loader only works with string data

8.7%

All of the fields had at least one null value

6.2%

Auto Loader cannot infer the schema of ingested data

11.9%

Databricks Certified Data Engineer - Associate