Noos
PT EN
RAN-DBDEA-00170
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: medium

A data engineer must register an existing Delta dataset as an external table in Unity Catalog and runs the following statement: ```sql CREATE TABLE main.sales.orders_ext (order_id BIGINT, amount DECIMAL(10,2)) USING DELTA LOCATION 's3://acme-raw/orders/'; ``` The statement fails with an error saying that the input path does not match any external location. What is the most likely cause?

Options (Reading Mode) Click to filter discussion →
  1. A. The s3:// path would be accepted if the bucket were publicly readable, so the failure means the bucket policy must be opened.
  2. B. The engineer's account is missing SELECT on the main catalog, and granting SELECT on a catalog is what authorizes table creation.
  3. C. The path is not covered by any registered external location, an object that references a storage credential.
  4. D. The statement was run on a shared cluster, and s3:// locations in CREATE TABLE only resolve on single-user clusters.
Reveal answer

Correct answer: The path is not covered by any registered external location, an object that references a storage credential.

Reference: https://docs.databricks.com/aws/en/data-governance/unity-catalog/

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 (C): The path is not covered by any registered external location, an object that references a storage credential.

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.