Noos
PT EN
RAN-DBDEA-00024
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

Auto Loader is ingesting the JSON events below with schema inference, so every field — nested ones included — is currently a string: ```json {"event_ts": "2026-05-01T10:22:31Z", "amount": "49.90", "user_info": {"id": "1042", "dob": "1990-04-18"}} ``` The team wants event_ts read as TIMESTAMP, amount as DOUBLE, and user_info.dob as DATE, while all other fields keep being inferred automatically. Which Auto Loader option does this?

Options (Reading Mode) Click to filter discussion →
  1. A. cloudFiles.schemaHints, e.g. 'event_ts TIMESTAMP, amount DOUBLE, user_info.dob DATE' — pins known types, infers the rest
  2. B. cloudFiles.schemaEvolutionMode set to addNewColumnsWithTypeWidening, which converts inferred strings into native types as data arrives
  3. C. cloudFiles.inferColumnTypes together with a full .schema() declaration listing every column, including all nested fields
  4. D. cloudFiles.rescuedDataColumn, which casts values rescued from type mismatches back into typed columns
Reveal answer

Correct answer: cloudFiles.schemaHints, e.g. 'event_ts TIMESTAMP, amount DOUBLE, user_info.dob DATE' — pins known types, infers the rest

Reference: https://docs.databricks.com/aws/en/ingestion/cloud-object-storage/auto-loader/

Train this exam on Ranvier →

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (A): cloudFiles.schemaHints, e.g. 'event_ts TIMESTAMP, amount DOUBLE, user_info.dob DATE' — pins known types, infers the rest

Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.