Databricks Data Engineer Associate · Free practice question 2 of 12
Auto Loader schema hints
Auto Loader at Ferro Cycles infers the schema of incoming JSON files, but it keeps typing the column order_total as STRING when the team needs DECIMAL(10,2). All other columns should still be inferred. Which option addresses this?
- A.cloudFiles.schemaHints = 'order_total DECIMAL(10,2)'
- B.cloudFiles.schemaEvolutionMode = 'rescue'
- C.cloudFiles.useNotifications = 'true'
- D.cloudFiles.maxFilesPerTrigger = '1'
Show answer and explanation
Correct answer: A. cloudFiles.schemaHints = 'order_total DECIMAL(10,2)'
Why: Schema hints let you declare the type of selected columns while Auto Loader continues to infer the rest of the schema. The rescue evolution mode changes how unexpected data is handled rather than setting column types, notification mode changes how new files are discovered, and maxFilesPerTrigger only limits batch size.
More free Databricks Data Engineer Associate questions
- Delta shallow vs deep clone
- Reading notebook task parameters
- collect_set vs collect_list aggregation
- Triggered vs continuous pipeline mode
- Job maximum concurrent runs
- Job task timeout setting
- SHOW GRANTS on Unity Catalog objects
- Transferring object ownership
- Compute policies for cluster governance
- ALTER TABLE ADD COLUMNS on Delta
- Spark lazy evaluation transformations vs actions