Noos
PT EN
RAN-DBDEA-00132
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: medium

A company's gold layer ends with a nightly aggregated orders table that a legacy planning system can only consume from its own PostgreSQL database. Right after the aggregation finishes each night, the table's full contents must be delivered into a PostgreSQL table that the legacy system reads. How should the team deliver the gold table into PostgreSQL?

Options (Reading Mode) Click to filter discussion →
  1. A. Run COPY INTO against the PostgreSQL table, because COPY INTO moves data between Delta tables and any external SQL database
  2. B. Share the gold table using Delta Sharing: the open protocol automatically materializes it as a table inside the PostgreSQL database
  3. C. Schedule a notebook that displays the aggregation results and exports them to CSV, letting the legacy team load the file by hand
  4. D. Add a task that writes the DataFrame with .format('jdbc'), passing the PostgreSQL URL, credentials, and save mode as options
Reveal answer

Correct answer: Add a task that writes the DataFrame with .format('jdbc'), passing the PostgreSQL URL, credentials, and save mode as options

Reference: https://docs.databricks.com/aws/en/archive/connectors/jdbc

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): Add a task that writes the DataFrame with .format('jdbc'), passing the PostgreSQL URL, credentials, and save mode as options

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.