Noos
PT EN
RAN-DBDEA-00030
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A vendor exposes order data only through a paged REST API that returns JSON documents; there are no file drops and no direct database access. The team must land this data daily into a Unity Catalog-governed table. A junior engineer proposes: ```sql COPY INTO main.ops.orders FROM 'https://api.vendor.com/v2/orders' FILEFORMAT = JSON; ``` What is the correct approach?

Options (Reading Mode) Click to filter discussion →
  1. A. Run the proposed statement with FORMAT_OPTIONS ('header' = 'true') added, so that the HTTP endpoint becomes readable as JSON
  2. B. Ask the vendor to publish the data to Kafka, because REST API sources cannot be landed in Unity Catalog tables
  3. C. Register the API URL as a Unity Catalog external location so that COPY INTO treats it as cloud object storage
  4. D. Write a notebook that pages through the API and appends to a UC-governed table, scheduled as a Lakeflow Job task
Reveal answer

Correct answer: Write a notebook that pages through the API and appends to a UC-governed table, scheduled as a Lakeflow Job task

Reference: https://docs.databricks.com/aws/en/jobs/

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 (D): Write a notebook that pages through the API and appends to a UC-governed table, scheduled as a Lakeflow Job task

⚓ Official Documentation Anchor: https://docs.databricks.com/aws/en/jobs/
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.