Free Databricks Certified Data Engineer Associate Actual Exam Questions - Question 3 Discussion
Question No. 3
A data engineer has developed a data pipeline to ingest data from a JSON source using Auto Loader,
but the engineer has not provided any type inference or schema hints in their pipeline. Upon
reviewing the data, the data engineer has noticed that all of the columns in the target table are of
the string type despite some of the fields only including float or boolean values.
Which of the following describes why Auto Loader inferred all of the columns to be of the string
type?
but the engineer has not provided any type inference or schema hints in their pipeline. Upon
reviewing the data, the data engineer has noticed that all of the columns in the target table are of
the string type despite some of the fields only including float or boolean values.
Which of the following describes why Auto Loader inferred all of the columns to be of the string
type?
Select one option, then reveal solution.
US
JV
James V.
2026-02-12
Makes sense that a type mismatch across files would force Auto Loader to default to string, so A.
0
OF
Osama F.
2026-01-28
A/B? If there was a type mismatch (A), Auto Loader might fallback to string to avoid errors. But B also fits since JSON is text and no schema hints usually means defaulting to strings.
0
OF
Osama F.
2026-01-19
Option A also makes sense because if there was any inconsistency in the data types across files, Auto Loader might default to string to avoid errors. That could explain why everything ended up as string.
0
SR
Sohail R.
2026-01-11
It's gotta be B. JSON is text-based, so without schema hints, Auto Loader treats everything as strings by default.
0