Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
To enable case-insensitive behavior of column names in an Auto Loader pipeline while iteratively reading Parquet files from an S3 location with schema evolution mode set to 'rescue', which property should be adjusted?
To enable case-insensitive behavior of column names in an Auto Loader pipeline while iteratively reading Parquet files from an S3 location with schema evolution mode set to 'rescue', which property should be adjusted?
Real Exam
Explanation:
The correct answer is to set the readerCaseSensitive option to false to enable case-insensitive inference of column names. By default, this option is set to true in 'rescue' mode, making the inference case-sensitive. The readerCaseInsensitive option is invalid. This functionality is applicable to AVRO, Parquet, and CSV files.