DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #36
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
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?
Options
- AThere was a type mismatch between the specific schema and the inferred schema
- BJSON data is a text-based format
- CAuto Loader only works with string data
- DAll of the fields had at least one null value
- EAuto Loader cannot infer the schema of ingested data
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.