Noos
PT EN
RAN-DBDEA-00013
Ranvier · DBDEA

Exam DBDEA Topics: ingestion Difficulty: easy

A newly hired data engineer runs the following statement in a workspace where Unity Catalog manages all data access: ```sql COPY INTO main.ops.shipments FROM 'abfss://raw@companylake.dfs.core.windows.net/shipments/' FILEFORMAT = PARQUET; ``` The target table exists, but the statement fails with a path access error. What must be configured before COPY INTO can read this location?

Options (Reading Mode) Click to filter discussion →
  1. A. A DBFS mount point for the storage account, because COPY INTO can only read paths that are mounted under /mnt
  2. B. A Unity Catalog storage credential and an external location for the path, with READ FILES granted
  3. C. The storage account key embedded directly in the FROM clause, so COPY INTO authenticates on each run
  4. D. An ingestion gateway deployed next to the storage account's private endpoint
Reveal answer

Correct answer: A Unity Catalog storage credential and an external location for the path, with READ FILES granted

Reference: https://docs.databricks.com/aws/en/ingestion/cloud-object-storage/copy-into

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 (B): A Unity Catalog storage credential and an external location for the path, with READ FILES granted

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.